Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 611:

  What command should be used to move data from a Snowflake database table into one or more files in an external stage?

  A. GET
  B. COPY INTO
  C. PUT
  D. SHOW
  B. COPY INTO

  ---

  Explanation

• Question 612:

  Which object-level parameters can be set to help control query processing and concurrency? (Choose two).

  A. MAX_CONCURRENCY_LEVEL
  B. DATA_RETENTION_TIME_IN_DAYS
  C. MIN_DATA_RETENTION_TIME_IN_DAYS
  D. STATEMENT_TIMEOUT_IN_SECONDS
  E. STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
  D. STATEMENT_TIMEOUT_IN_SECONDS
  E. STATEMENT_QUEUED_TIMEOUT_IN_SECONDS

  ---

  Explanation

• Question 613:

  When connecting to Snowflake using SnowSQL, what are ways to explicitly specify the password? (Choose two.)

  A. Use public and private key pair authentication
  B. Run a web-based authorization ow
  C. Use an OAuth token
  D. Enter through an interactive prompt
  E. Specify using SNOWSQL_PWD environment variables
  D. Enter through an interactive prompt
  E. Specify using SNOWSQL_PWD environment variables

  ---

  Explanation

• Question 614:

  What identi ers are supported when creating a Snowflake account hostname? (Choose two.)

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

  ---

  Explanation

• Question 615:

  Which role is responsible for managing the billing and credit data within Snowflake?

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

  ---

  Explanation

• Question 616:

  Where does Snowflake store the data output from a query that was executed in the past 24 hours?

  A. In a micro-partition
  B. In a remote disk
  C. In the result cache layer
  D. In the local disk cache layer
  C. In the result cache layer

  ---

  Explanation

• Question 617:

  Snowpipe via REST API can only reference External Stages as source.

  A. True
  B. False
  B. False

  ---

  Explanation

  https://community.snowflake.com/s/article/Making-Transient-table-by-Default

• Question 618:

  Which virtual warehouse auto-suspend con gurations will result in a warehouse that runs continually, 24 hours a day, 7 days a week? (Choose two.)

  A. -1
  C. 86400
  D. 172800
  E. NULL
  A. -1
  E. NULL

  ---

  Explanation

• Question 619:

  How does Snowflake define its approach to Discretionary Access Control (DAC)?

  A. A defined level of access to an object.
  B. An entity to which access can be granted.
  C. Each object has an owner, who can in turn grant access to that object.
  D. Access privileges are assigned to roles, which are in turn assigned to users.
  C. Each object has an owner, who can in turn grant access to that object.

  ---

  Explanation

• Question 620:

  A Query Profile shows a UnionAll operator with an extra Aggregate operator on top.

  What does this signify?

  A. Exploding joins
  B. Inefficient pruning
  C. UNION without ALL
  D. Queries that are too large to fit in memory
  C. UNION without ALL

  ---

  Explanation