Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 1071:

  True or False: Snowflake's Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.

  A. True

  B. False

  Correct Answer: A

  Snowflake is a single, integrated platform delivered as-a-service. It features storage, compute, and global services layers that are physically separated but logically integrated.

• Question 1072:

  What is the most granular object that the Time Travel retention period can be defined on? Select one.

  A. Account

  B. Database

  C. Schema

  D. Table

  Correct Answer: D

  Reference: https://docs.snowflake.com/en/user-guide/data-time-travel.html#data-retention-period

• Question 1073:

  True or False: All Snowflake table types include fail-safe storage.

  A. True

  B. False

  Correct Answer: B

• Question 1074:

  True or False: Snowflake charges additional fees to Data providers for each share they create.

  A. True

  B. False

  Correct Answer: B

  "The costs for sharing data with Snowflake are minimal and straightforward. Data providers simply pay Snowflake for the data they store, and data consumers pay for the compute resources their queries consume."

• Question 1075:

  Which of the following statements describes a benefit of Snowflake's separation of compute and storage? (Choose all that apply.)

  A. Growth of storage and compute are tightly coupled together

  B. Storage expands without the requirement to add more compute

  C. Compute can be scaled up or down without the requirement to add more storage

  D. Multiple compute clusters can access stored data without contention

  Correct Answer: BCD

  Reference: https://towardsdatascience.com/why-you-are-throwing-money-away-if-your-cloud-data-warehousedoesnt-separate-storage-and-compute-65d2dffd450f

• Question 1076:

  Which of the following best describes where Snowflake's metadata is stored?

  A. Within the data files

  B. Inside the Virtual Warehouses

  C. In the Cloud Services Layer

  D. within the drivers

  Correct Answer: C

• Question 1077:

  Which of the following statement is true of Snowflake? Select one.

  A. It was built specifically for the cloud

  B. it was built as an on-premises solution and then potted to the cloud

  C. It was designed as a hybrid database to allow customers to store data either on premises or in the cloud

  D. It was built for Hadoop architecture

  E. It's based on an Oracle Architecture

  Correct Answer: A

• Question 1078:

  True or False: When data share is established between a Data Provider and a data Consumer, the Data Consumer can extend that data share to other Data Consumers.

  A. True

  B. False

  Correct Answer: B

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

• Question 1079:

  True or False: A third-party tool that supports standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to Snowflake.

  A. True

  B. False

  Correct Answer: B

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

  Snowflake provides a JDBC type 4 driver that supports core JDBC functionality. The JDBC driver must be installed in a 64-bit environment and requires Java 1.8 (or higher). The driver can be used with most client tools/applications that support JDBC for connecting to a database server.

• Question 1080:

  Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)

  A. Number of users

  B. Warehouse size

  C. Amount of data processed

  D. # of clusters for the Warehouse

  Correct Answer: BD

  https://docs.snowflake.com/en/user-guide/credits.html#virtual-warehouse-credit-usage

  "Snowflake credits are charged based on the number of virtual warehouses you use, how long they run, and their size."