Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1691:

  Which type of join will list all rows in the specified table, even if those rows have no match in the other table?

  A. Cross join
  B. Inner join
  C. Natural join
  D. Outer join
  D. Outer join

  ---

  Explanation

• Question 1692:

  What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?

  A. The explain plan output is available graphically.
  B. An explain plan can be used to conduct performance analysis without executing a query.
  C. An explain plan will handle queries with temporary tables and the query profiler will not.
  D. An explain plan's output will display automatic data skew optimization information.
  B. An explain plan can be used to conduct performance analysis without executing a query.

  ---

  Explanation

• Question 1693:

  Where is Snowflake metadata stored?

  A. Within the data files
  B. In the virtual warehouse layer
  C. In the cloud services layer
  D. In the remote storage layer
  C. In the cloud services layer

  ---

  Explanation

• Question 1694:

  What is a limitation of a Materialized View?

  A. A Materialized View cannot support any aggregate functions
  B. A Materialized View can only reference up to two tables
  C. A Materialized View cannot be joined with other tables
  D. A Materialized View cannot be defined with a JOIN
  D. A Materialized View cannot be defined with a JOIN

  ---

  Explanation

  There are several limitations to using materialized views:

  A materialized view can query only a single table.

  Joins, including self-joins, are not supported.

• Question 1695:

  Which query will return a sample of a table with 1000 rows named testtable, in which each row has a 10% probability of being included in the sample?

  A. select * from testtable sample (0.1);
  B. select * from testtable sample (10);
  C. select * from testtable sample (0.1 rows);
  D. select * from testtable sample (10 rows);
  B. select * from testtable sample (10);

  ---

  Explanation

• Question 1696:

  While using a COPY command with a Validation_mode parameter, which of the following statements will return an error?

  A. Statements that insert a duplicate record during a load
  B. Statements that have a specific data type in the source
  C. Statements that have duplicate file names
  D. Statements that transform data during a load
  D. Statements that transform data during a load

  ---

  Explanation

• Question 1697:

  What can a user win a reader account do in Snowflake?

  A. Load now data
  B. Update existing data
  C. Create a new snare
  D. Query shared data
  D. Query shared data

  ---

  Explanation

• Question 1698:

  Which URL provides access to files in Snowflake without authorization?

  A. File URL
  B. Scoped URL
  C. Pre-signed URL
  D. Scoped file URL
  C. Pre-signed URL

  ---

  Explanation

• Question 1699:

  A Virtual Warehouse can be resized while suspended.

  A. True
  B. False
  A. True

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/warehouses-tasks.html#effects-of-resizing-a-suspended-warehouse

• Question 1700:

  Which Multi-Factor Authentication (MFA) method is supported in Snowflake?

  A. Biometric fingerprint scanner
  B. Email-based verification links
  C. SMS codes sent to a registered mobile phone
  D. A stored passkey that can be accessed multiple ways
  C. SMS codes sent to a registered mobile phone

  ---

  Explanation