Snowflake COF-R02 Practice Test - Questions Answers, Page 11
Related questions
Question 101

Which of the following objects can be shared through secure data sharing?
Explanation:
Secure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts. The following Snowflake database objects can be shared:
Tables
External tables
Secure views
Secure materialized views
Secure UDFs
Snowflake enables the sharing of databases through shares, which are created by data providers and “imported” by data consumers.
https://docs.snowflake.com/en/user-guide/data-sharingintro.html#:~:text=Secure%20Data%20Sharing%20enables%20sharing,External%20tables
Question 102

Which of the following commands cannot be used within a reader account?
Explanation:
A reader account is intended primarily for querying data shared by the provider of the account.
Adding new data to the account and/or updating shared data in the account is not supported.
Changing the configuration of virtual warehouses is also not permitted as those resources are owned and managed by the provider of the account which is sharing the data.
Question 103

A user unloaded a Snowflake table called mytable to an internal stage called mystage.
Which command can be used to view the list of files that has been uploaded to the staged?
Question 104

Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)
Explanation:
https://docs.snowflake.com/en/user-guide/intro-editions.html
Question 105

Which command is used to unload data from a Snowflake table into a file in a stage?
Explanation:
https://docs.snowflake.com/en/user-guide/data-unloadsnowflake.html#:~:text=Your%20User%20Stage-,Use%20the%20COPY%20INTO%20command%20to%20unload%20all%20the,more%20files%20in%20your%20stage.
Question 106

How often are encryption keys automatically rotated by Snowflake?
Explanation:
All Snowflake-managed keys are automatically rotated by Snowflake when they are more than 30 days old. Active keys are retired, and new keys are created. When Snowflake determines the retired key is no longer needed, the key is automatically destroyed.
https://docs.snowflake.com/en/user-guide/security-encryptionmanage.html#:~:text=All%20Snowflake%2Dmanaged%20keys%20are,the%20key%20is%20automatically%20destroyed.
Question 107

What are value types that a VARIANT column can store? (Select TWO)
Explanation:
Characteristics of a VARIANT
A VARIANT can store a value of any other type, including OBJECT and ARRAY. The maximum length of a VARIANT is 16 MB.
https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html#:~:text=VARIANT-,Characteristics%20of%20a%20VARIANT,a%20VARIANT%20is%2016%20MB.
Question 108

A user has an application that writes a new Tile to a cloud storage location every 5 minutes.
What would be the MOST efficient way to get the files into Snowflake?
Explanation:
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html
Question 109

Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).
Explanation:
https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare.html
Question 110

A user has 10 files in a stage containing new customer dat a. 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?
Question