Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 1181:

  Which of the following statements is true of data loading? Select one.

  A. Resizing the virtual warehouse from x-Small to Small will process a single file twice as fast

  B. The "deal file size for loading is 16MB to match micro-partition size

  C. Marry files in the 10-lOOMB range tend to land In the 'sweet spot" for load parallelism Once loaded, there is no option to force a reload of an already loaded file

  Correct Answer: C

• Question 1182:

  Snowflake is designed for which type of workloads? (Choose two.)

  A. OLAP (Analytics) workloads

  B. OLTP (Transactional) workloads

  C. Concurrent workloads

  D. On-premise workloads

  Correct Answer: AC

  Reference:

  https://blog.couchbase.com/its-the-workload-stupid/

  https://www.quora.com/Can-Snowflake-be-used-for-an-OLTP-system-or-is-it-only-best-suited-for-warehousing

• Question 1183:

  Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting? (Choose all that apply.)

  A. JDBC

  B. SnowSQL

  C. Snowflake Web Interface (UI)

  D. ODBC

  E. Python

  Correct Answer: ABCDE

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

• Question 1184:

  Which of the following DML commands isn't supported by Snowflake?

  A. UPSERT

  B. MERGE

  C. UPDATE

  D. TRUNCATE TABLE

  Correct Answer: A

  Reference: https://docs.snowflake.com/en/sql-reference/sql-dml.html

• Question 1185:

  How many shares can be consumed by single Data Consumer?

  A. 1

  B. 10

  C. 100, but can be increased by contacting support

  D. Unlimited

  Correct Answer: D

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

• Question 1186:

  True or False: When Snowflake is configured to use Single Sign-on (sso), Snowflake receive the usernames and credentials from the sso service and loads them into the customer's Snowflake account.

  A. True

  B. false:

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/user-guide/admin-security-fed-auth-configure-snowflake.html

• Question 1187:

  True or False: Snowflake's data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.

  A. True

  B. False

  Correct Answer: A

• Question 1188:

  True or False: Users are able to see the result sets of queries executed by other users that share their same role.

  A. True

  B. False

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html

• Question 1189:

  True or False the longer the data retention period, the higher the resulting storage costs.

  A. True

  B. False

  Correct Answer: A

• Question 1190:

  Which of the following statements is true of Snowflake micro-partitioning?

  A. Micro-partitioning has been known to introduce data skew

  B. Micro-partitioning: requires a partitioning schema to be defined up front

  C. Micro-partitioning is transparently completed using the ordering that occurs when the data is inserted/loaded

  D. Micro-partitioning can be disabled within a Snowflake account

  Correct Answer: C

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