Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1371:

  Which statement describes Snowflake tables?

  A. Snowflake tables are logical representations of underlying physical data.
  B. Snowflake tables are the physical instantiation of data loaded into Snowflake.
  C. Snowflake tables require that clustering keys be defined to perform optimally.
  D. Snowflake tables are owned by a user.
  A. Snowflake tables are logical representations of underlying physical data.

  ---

  Explanation

• Question 1372:

  What is the MINIMUM Snowflake edition required to use object tagging?

  A. Standard
  B. Enterprise
  C. Business Critical
  D. Virtual Private Snowflake (VPS)
  B. Enterprise

  ---

  Explanation

• Question 1373:

  What identifiers are supported when creating a Snowflake account hostname? (Select TWO).

  A. Cloud region
  B. Snowflake domain
  C. Account name
  D. Account locator
  E. Account cloud platform
  A. Cloud region
  C. Account name

  ---

  Explanation

  A Snowflake account hostname is a combination of the cloud region and the account name.

  The hostname follows this

  structure:https://..snowflakecomputing.com.

  Examples:

  References:

  Snowflake Documentation: Account Identifiers

  Snowflake Hostname Structure

• Question 1374:

  Which view will return users who have queried a table?

  A. SNOWFLAKE.ACCOUNT_USAGE.WAREHOUSE_EVENT_HISTORY
  B. SNOWFLAKE.ACCOUNT_USAGE.ACCESS_HISTORY
  C. SNOWFLAKE.ACCOUNT_USAGE.COLUMNS
  D. SNOWFLAKE.ACCOUNT_USAGE.OBJECT_DEPENDENCIES
  B. SNOWFLAKE.ACCOUNT_USAGE.ACCESS_HISTORY

  ---

  Explanation

• Question 1375:

  What is the MOST efficient way to load streaming data into Snowflake?

  A. Use the COPY command.
  B. Use Snowpipe.
  C. Use the Load Data Wizard.
  D. Use tasks and streams.
  B. Use Snowpipe.

  ---

  Explanation

• Question 1376:

  Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)

  A. SHOW STORAGE BY TABLE;
  B. SHOW TABLES;
  C. Information Schema-> TABLE_HISTORY
  D. Information Schema-> TABLE_FUNCTION
  E. Information Schema-> TABLE_STORAGE_METRICS
  B. SHOW TABLES;
  E. Information Schema-> TABLE_STORAGE_METRICS

  ---

  Explanation

• Question 1377:

  Which file format is MOST performant in Snowflake for data loading?

  A. Parquet
  B. CSV
  C. ORC
  D. Avro
  B. CSV

  ---

  Explanation

• Question 1378:

  Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).

  A. The table contains a column that has very low cardinality
  B. DML statements that are being issued against the table are blocked
  C. The table has a small number of micro-partitions
  D. Queries on the table are running slower than expected
  E. The clustering depth for the table is large
  D. Queries on the table are running slower than expected
  E. The clustering depth for the table is large

  ---

  Explanation

• Question 1379:

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

  A. ACCOUNTADMIN
  B. ORGADMIN
  C. SECURITYADMIN
  D. SYSADMIN
  B. ORGADMIN

  ---

  Explanation

• Question 1380:

  How can a Snowflake user post-process the result of SHOW FILE FORMATS?

  A. Use the RESULT_SCAN function.
  B. Create a CURSOR for the command.
  C. Put it in the FROM clause in brackets.
  D. Assign the command to RESULTSET.
  A. Use the RESULT_SCAN function.

  ---

  Explanation

  first run SHOW FILE FORMATS then SELECT * FROM TABLE(RESULT_SCAN(LAST_QUERY_ID(-1))) https://docs.snowflake.com/en/sql-reference/functions/result_scan#usage-notes