SnowPro Core Data Loading and Unloading Quiz

1. What is the default behavior of COPY INTO if a duplicate row is detected?

Skip the row

Abort the load

Replace the existing row

Insert duplicate

2. True or False: Snowflake supports loading data directly from HTTPS URLs without staging files.

True

False

Submit

4. Which parameter controls whether NULL values are written to the output during UNLOAD?

NULL_IF

SKIP_NULLS

EMPTY_AS_NULL

WRITE_NULLS

5. True or False: A table stage is associated with a specific table and cannot be shared with other tables.

True

False

6. What does PURGE=TRUE do after a successful COPY operation?

Deletes loaded files from the stage

Removes duplicate rows from table

Clears the stage directory

Truncates the target table

7. Which parameter in UNLOAD specifies the maximum file size in bytes?

MAX_FILE_SIZE

FILE_SIZE_LIMIT

PARTITION_SIZE

CHUNK_SIZE

8. True or False: The UNLOAD command can partition output files by column values.

True

False

9. The STRIP_OUTER_ARRAY parameter applies to which file format?

JSON

CSV

Parquet

ORC

10. Which command creates a named external stage pointing to an S3 bucket?

CREATE STAGE

CREATE EXTERNAL STORAGE

CREATE LOCATION

CREATE CLOUD LINK

11. Which command loads data from a staged file into a Snowflake table?

COPY INTO

INSERT INTO

LOAD DATA

IMPORT TABLE

12. True or False: External stages require you to provide cloud storage credentials in Snowflake.

True

False

13. Which file format does Snowflake natively support for data loading?

CSV, JSON, Parquet

Only CSV

Only JSON

Only Parquet

14. What does the VALIDATION_MODE parameter allow you to do in COPY INTO?

Test the load without inserting data

Encrypt data before loading

Compress files automatically

Rollback failed transactions

15. True or False: Snowflake can automatically transform data during the COPY operation using SELECT statements.

True

False

16. Which parameter specifies the character that separates fields in a delimited file?

FIELD_DELIMITER

COLUMN_SEPARATOR

DELIMITER_CHAR

FIELD_TERMINATOR

17. What does the ON_ERROR option in COPY INTO control?

How errors during load are handled

Compression level for files

Encryption algorithm used

Parallel thread count

18. An internal stage is stored in which Snowflake location by default?

Snowflake-managed cloud storage

Customer's AWS S3 bucket

Customer's Azure Blob storage

On-premises data center

19. Which of the following are valid Snowflake staging types?

Internal, External, Dynamic

Internal, External, Temporary

User, Table, Database

Permanent, Transient, Ephemeral

20. What is the primary purpose of the UNLOAD command in Snowflake?

Export table data to staged files

Remove rows from a table

Compress table data

Archive historical data

SnowPro Core Data Loading and Unloading Quiz

1. What is the default behavior of COPY INTO if a duplicate row is detected?

2.

What first name or nickname would you like us to use?

2. True or False: Snowflake supports loading data directly from HTTPS URLs without staging files.

3. The ENFORCE_LENGTH parameter in COPY INTO ensures that ____ do not exceed specified column widths.

4. Which parameter controls whether NULL values are written to the output during UNLOAD?

5. True or False: A table stage is associated with a specific table and cannot be shared with other tables.

6. What does PURGE=TRUE do after a successful COPY operation?

7. Which parameter in UNLOAD specifies the maximum file size in bytes?

8. True or False: The UNLOAD command can partition output files by column values.

9. The STRIP_OUTER_ARRAY parameter applies to which file format?

10. Which command creates a named external stage pointing to an S3 bucket?

11. Which command loads data from a staged file into a Snowflake table?

12. True or False: External stages require you to provide cloud storage credentials in Snowflake.

13. Which file format does Snowflake natively support for data loading?

14. What does the VALIDATION_MODE parameter allow you to do in COPY INTO?

15. True or False: Snowflake can automatically transform data during the COPY operation using SELECT statements.

16. Which parameter specifies the character that separates fields in a delimited file?

17. What does the ON_ERROR option in COPY INTO control?

18. An internal stage is stored in which Snowflake location by default?

19. Which of the following are valid Snowflake staging types?

20. What is the primary purpose of the UNLOAD command in Snowflake?