Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 1051:

  A sales table FCT_SALES has 100 million records. The following Query was executed

  SELECT COUNT (1) FROM FCT__SALES;

  How did Snowflake fulfill this query?

  A. Query against the result set cache

  B. Query against a virtual warehouse cache

  C. Query against the most-recently created micro-partition

  D. Query against the metadata excite

  Correct Answer: D

• Question 1052:

  Which of the following Snowflake objects can be shared using a secure share? (Select TWO).

  A. Materialized views

  B. Sequences

  C. Procedures

  D. Tables

  E. Secure User Defined Functions (UDFs)

  Correct Answer: DE

  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

  https://docs.snowflake.com/en/user-guide/data-sharing-intro.html

• Question 1053:

  Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?

  A. Each Snowflake account can be hosted in a different cloud vendor and region.

  B. Each Snowflake account must be hosted in a different cloud vendor and region

  C. All Snowflake accounts must be hosted in the same cloud vendor and region

  D. Each Snowflake account can be hosted in a different cloud vendor, but must be in the same region.

  Correct Answer: A

• Question 1054:

  What Snowflake role must be granted for a user to create and manage accounts?

  A. ACCOUNTADMIN

  B. ORGADMIN

  C. SECURITYADMIN

  D. SYSADMIN

  Correct Answer: B

• Question 1055:

  What feature can be used to reorganize a very large table on one or more columns?

  A. Micro-partitions

  B. Clustering keys

  C. Key partitions

  D. Clustered partitions

  Correct Answer: B

  https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html

• Question 1056:

  What SQL command would be used to view all roles that were granted to user.1?

  A. show grants to user USER1;

  B. show grants of user USER1;

  C. describe user USER1;

  D. show grants on user USER1;

  Correct Answer: A

• Question 1057:

  A company strongly encourages all Snowflake users to self-enroll in Snowflake's default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake. Which application will the Snowflake users need to install on their devices in order to connect with MFA?

  A. Okta Verify

  B. Duo Mobile

  C. Microsoft Authenticator

  D. Google Authenticator

  Correct Answer: B

  https://docs.snowflake.com/en/user-guide/security-mfa.html

• Question 1058:

  Which copy INTO command outputs the data into one file?

  A. SINGLE=TRUE

  B. MAX_FILE_NUMBER=1

  C. FILE_NUMBER=1

  D. MULTIPLE=FAISE

  Correct Answer: A

• Question 1059:

  True or False: A customer using SnowSQL / native connectors will be unable be unable to able to also use the Snowflake Web interface (UI) unless access to the UI is explicitly granted by supported.

  A. True

  B. False

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/user-guide/connecting.html

• Question 1060:

  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?

  A. All data from all of the files on the stage will be appended to the table

  B. Only data about new customers from the new files will be appended to the table

  C. The operation will fail with the error uncertain files in stage.

  D. All data from only the newly-added files will be appended to the table.

  Correct Answer: D

  https://docs.snowflake.com/en/user-guide/data-load-considerations-load.html#executing-parallel-copy-statements-that-reference-the-same-data-files