Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 931:

  Snowflake users can create a resource monitor at which levels? (Select TWO).

  A. User level
  B. Pipe level
  C. Account level
  D. Cloud services level
  E. Virtual warehouse level
  C. Account level
  E. Virtual warehouse level

  ---

  Explanation

• Question 932:

  Which grant will provide a user with access to data that is in a Snowflake share?

  A. GRANT SELECT ON ALL TABLES IN DATABASE TO USER ;
  B. GRANT READ ON ALL TABLES IN DATABASE TO ROLE ;
  C. GRANT IMPORTED PRIVILEGES ON DATABASE TO ROLE ;
  D. GRANT USE ON DATABASE TO ROLE ;
  C. GRANT IMPORTED PRIVILEGES ON DATABASE TO ROLE ;

  ---

  Explanation

  When a consumer imports a shared database , they must explicitly grant the IMPORTED PRIVILEGES to a role in order to access the shared objects.

  Snowflake Docs: Accessing Shared Data

• Question 933:

  At what level is the ALLOW_CLIENT_MFA_CACHING parameter con gurable in Snow ake?

  A. User
  B. Session
  C. Account
  D. Virtual warehouse
  C. Account

  ---

  Explanation

• Question 934:

  Which data types in Snowflake are synonymous for FLOAT? (Choose two.)

  A. DECIMAL
  B. DOUBLE
  C. NUMBER
  D. NUMERIC
  E. REAL
  B. DOUBLE
  E. REAL

  ---

  Explanation

• Question 935:

  When creating a user it is advisable sable to:

  A. Set the user to be initially disabled
  B. Force an immediate password change
  C. Set a default role for the user
  D. Set the number of minutes to unlock to 15 minutes
  E. Set the users access to expire within a specified timeframe
  B. Force an immediate password change
  C. Set a default role for the user

  ---

  Explanation

• Question 936:

  How does a Snowflake stored procedure compare to a User-Defined Function (UDF)?

  A. A single executable statement can call only two stored procedures. In contrast, a single SQL statement can call multiple UDFs.
  B. A single executable statement can call only one stored procedure. In contrast, a single SQL statement can call multiple UDFs.
  C. A single executable statement can call multiple stored procedures. In contrast, multiple SQL statements can call the same UDFs.
  D. Multiple executable statements can call more than one stored procedure. In contrast, a single SQL statement can call multiple UDFs.
  B. A single executable statement can call only one stored procedure. In contrast, a single SQL statement can call multiple UDFs.

  ---

  Explanation

• Question 937:

  Which statement best describes Snowflake tables?

  A. Snowflake tables are logical representations of underlying physical data
  B. Snowflake tables ate 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

  https://docs.snowflake.com/en/user-guide/tables-micro-partitions.html

• Question 938:

  What is the purpose of an External Function?

  A. To call code that executes outside of Snowflake
  B. To run a function in another Snowflake database
  C. To share data in Snowflake with external parties
  D. To ingest data from on-premises data sources
  A. To call code that executes outside of Snowflake

  ---

  Explanation

  https://docs.snowflake.com/en/sql-reference/external-functions.html

• Question 939:

  When unloading data with the COPY INTO command, what is the purpose of the PARTITION BY parameter option?

  A. To sort the contents of the output file by the specified expression.
  B. To delimit the records in the output file using the specified expression.
  C. To include a new column in the output using the specified window function expression.
  D. To split the output into multiple files, one for each distinct value of the specified expression.
  D. To split the output into multiple files, one for each distinct value of the specified expression.

  ---

  Explanation

• Question 940:

  Which term is used to describe information about disk usage for operations where intermediate results cannot be accommodated in a Snowflake virtual warehouse memory?

  A. Pruning
  B. Spilling
  C. Join explosion
  D. Queue overloading
  B. Spilling

  ---

  Explanation