Snowflake Snowflake Certifications COF-R02 Questions & Answers

• Question 271:

  True or False: The COPY command must specify a File Format in order to execute.

  A. True

  B. False

  Correct Answer: B

  Create Stage: https://docs.snowflake.com/en/sql-reference/sql/create-stage.html

  Create Table (STAGE_FILE_FORMAT option): https://docs.snowflake.com/en/sql-reference/sql/create-table.html Copy Into: https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html

• Question 272:

  Which of the following statements would be used to export/unload data from Snowflake?

  A. COPY INTO @stage

  B. EXPORT TO @stage

  C. INSERT INTO @stage

  D. EXPORT_TO_STAGE(stage = > @Wage, select = > 'select * from t1);

  Correct Answer: A

  Reference: https://docs.snowflake.com/en/user-guide/data-unload-considerations.html

• Question 273:

  Which of the following objects is not covered by Time Travel?

  A. Tables

  B. Schemas

  C. Databases

  D. Stages

  Correct Answer: D

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

• Question 274:

  True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.

  A. True

  B. False

  Correct Answer: A

  Reference: https://docs.snowflake.com/en/user-guide/data-unload-prepare.html

• Question 275:

  Which of the following terms best describes Snowflake's database architecture?

  A. Columnar shared nothing

  B. Shared disk

  C. Multi-cluster, shared data

  D. Cloud-native shared memory

  Correct Answer: C

  https://www.snowflake.com/product/architecture/

  Built from the ground up for the cloud, Snowflake's unique multi-cluster shared data architecture delivers the performance, scale, elasticity, and concurrency today's organizations require.

• Question 276:

  Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)

  A. Custom

  B. Economy

  C. Optimized

  D. Standard

  Correct Answer: BD

  Reference: https://community.snowflake.com/s/article/Snowflake-Visualizing-Warehouse-Performance

• Question 277:

  Which of the following statements is true of Snowflake?

  A. It was built specifically for the cloud

  B. It was built as an on-premises solution and then ported 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

  Reference: https://www.stitchdata.com/resources/snowflake/

• Question 278:

  Which of the following roles is recommended to be used to create and manage users and roles?

  A. SYSADMIN

  B. SECURITYADMIN

  C. PUBLIC

  D. ACCOUNTADMIN

  Correct Answer: B

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

  "Security admin: Role that can manage any object grant globally, as well as create, monitor, and manage users and roles"

• Question 279:

  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 280:

  True or False: An active warehouse is required to run a COPY INTO statement.

  A. True

  B. False

  Correct Answer: A