Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1051:

  A Snowflake account has activated federated authentication.

  What will occur when a user with a password that was defined by Snowflake attempts to log in to Snowflake?

  A. The user will be unable to enter a password.
  B. The user will encounter an error, and will not be able to log in.
  C. The user will be able to log into Snowflake successfully.
  D. After entering the username and password, the user will be redirected to an Identity Provider (IdP) login page.
  D. After entering the username and password, the user will be redirected to an Identity Provider (IdP) login page.

  ---

  Explanation

• Question 1052:

  Snowflake's approach to the management of system access combines which of the following models? (Choose two.)

  A. Security Assertion Markup Language (SAML)
  B. Role-Based Access Control (RBAC)
  C. Identity Access Management (AM)
  D. Create, Read, Update, and Delete (CRUD)
  E. Discretionary Access Control (DAC)
  F. Mandatory Access Control (MAC)
  B. Role-Based Access Control (RBAC)

  ---

  Explanation

• Question 1053:

  What is the outcome of querying a VARIANT column using an invalid path?

  A. NULL
  B. Undefined data
  C. An empty siring
  D. An invalid identifier error
  D. An invalid identifier error

  ---

  Explanation

• Question 1054:

  Increasing the size of a Virtual Warehouse from an X-Small to an X-Large is an example of:

  A. Scaling rhythmically
  B. Scaling max
  C. Scaling out
  D. Scaling up
  D. Scaling up

  ---

  Explanation

• Question 1055:

  Which of the following statements describes a schema in Snowflake?

  A. A logical grouping of objects that belongs to a single database
  B. A logical grouping of objects that belongs to multiple databases
  C. A named Snowflake object that includes all the information required to share a database
  D. A uniquely identified Snowflake account within a business entity
  A. A logical grouping of objects that belongs to a single database

  ---

  Explanation

• Question 1056:

  Which URL type allows users to access unstructured data without authenticating into Snowflake or passing an authorization token?

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

  ---

  Explanation

  Pre-signed URLs are used to download or access files, via a web browser for example, without authenticating into Snowflake or passing an authorization token. These URLs are ideal for business intelligence applications or reporting tools that need to display the unstructured file contents.

• Question 1057:

  What is the default character set used when loading CSV files into Snowflake?

  A. UTF-8
  B. UTF-16
  C. ISO S859-1
  D. ANSI_X3.A
  A. UTF-8

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/intro-summary-loading.html#:~:text=For%20delimited%20files%20(CSV%2C%20TSV,encoding%20to%20 use%20for% 20loading. For delimited files (CSV, TSV, etc.), the default character set is UTF-8. To use any other characters sets, you must explicitly specify the encoding to use for loading. For the list of supported character sets, see Supported Character Sets for Delimited Files (in this topic).

• Question 1058:

  Which privileges apply to stored procedures? (Choose two.)

  A. MODIFY
  B. MONITOR
  C. OPERATE
  D. OWNERSHIP
  E. USAGE
  D. OWNERSHIP
  E. USAGE

  ---

  Explanation

  USAGE

  Enables calling a stored procedure.

  ALL [ PRIVILEGES ]

  Grants all privileges, except OWNERSHIP, on the stored procedure.

  OWNERSHIP

  Grants full control over the stored procedure; required to alter the stored procedure. Only a single role can hold this privilege on a specific object at a time. Note that in a managed access schema, only the schema owner (i.e. the role with the OWNERSHIP privilege on the schema) or a role with the MANAGE GRANTS privilege can grant or revoke privileges on objects in the schema, including future grants.

• Question 1059:

  Use of which file function allows a user to share unstructured data from an internal stage with an external reporting tool that does not have access to Snowflake?

  A. BUILD_SCOPED_FILE_URL
  B. GET_PRESIGNED_URL
  C. BUILD_STAGE_FILE_URL
  D. GET_STAGE_LOCATION
  B. GET_PRESIGNED_URL

  ---

  Explanation

  The GET_PRESIGNED_URL function in Snowflake generates a pre-signed URL for a file in an internal stage. This URL can be shared with external tools or users who do not have direct access to Snowflake, allowing them to download the

  file.

  To generate a pre-signed URL:

  SELECT GET_PRESIGNED_URL(@my_stage/file.txt);

  Once generated, the URL can be shared with external users or applications, enabling them to access the file directly.

  References:

  Snowflake Documentation: GET_PRESIGNED_URL

  Snowflake Documentation: Working with Stages

• Question 1060:

  Which column is used with streams to track changes to metadata?

  A. METADATA$ROW_ID
  B. METADATA$START_SCAN_TIME
  C. METADATA$FILE_CONTENT_KEY
  D. METADATA$FILE_ROW_NUMBER
  A. METADATA$ROW_ID

  ---

  Explanation