QUESTION: 109

Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).

Load files that are approximately 25 MB or smaller.
Remove all dates and timestamps.
Load files that are approximately 100-250 MB (or larger)
Avoid using embedded characters such as commas for numeric data types
Remove semi-structured data types

Answer(s): C,D

Reference:

https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare.html

Reveal Solution Next Question

A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors, using the following command:

COPY INTO my table FROM @my stage;

The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files.
If the user runs the same copy into command what will happen?

All data from all of the files on the stage will be appended to the table
Only data about new customers from the new files will be appended to the table
The operation will fail with the error uncertain files in stage.
All data from only the newly-added files will be appended to the table.

Answer(s): A

Reveal Solution Next Question

QUESTION: 111

A user has unloaded data from Snowflake to a stage.
Which SQL command should be used to validate which data was loaded into the stage?

list @file stage
show @file stage
view @file stage
verify @file stage

Answer(s): A

Reveal Solution Next Question

QUESTION: 112

What happens when a cloned table is replicated to a secondary database? (Select TWO)

A read-only copy of the cloned tables is stored.
The replication will not be successful.
The physical data is replicated
Additional costs for storage are charged to a secondary account
Metadata pointers to cloned tables are replicated

Answer(s): C,D

Explanation:

Cloned objects are replicated physically rather than logically to secondary databases. That is, cloned tables in a standard database do not contribute to the overall data storage unless or until DML operations on the clone add to or modify existing data. However, when a cloned table is replicated to a secondary database, the physical data is also replicated, increasing the data storage usage for your account.

Reference:

https://docs.snowflake.com/en/user-guide/database-replication-considerations.html#:~:text=Replication%20and%20Cloning,-Cloned%20objects%20are&text=However%2C%20when%20a%20cloned%20table,storage%20usage%20for%20your%20account.

Reveal Solution Next Question

Free COF-R02 Exam Braindumps (page: 29)

QUESTION: 109

Reference:

QUESTION: 110

QUESTION: 111

QUESTION: 112

Explanation:

Reference:

COF-R02 Discussions & Posts