Snowflake SnowPro-Core Exam Practice Test Instant Access

Question 1

Which Snowflake feature provides increased login security for users connecting to Snowflake that is powered by Duo Security service?

AOAuth

BNetwork policies

CSingle Sign-On (SSO)

DMulti-Factor Authentication (MFA)

Answer : D

Multi-Factor Authentication (MFA) provides increased login security for users connecting to Snowflake. Snowflake's MFA is powered by Duo Security service, which adds an additional layer of security during the login process.

Question 2

A column named "Data" contains VARIANT data and stores values as follows:

How will Snowflake extract the employee's name from the column data?

AData:employee.name

BDATA:employee.name

Cdata:Employee.name

Ddata:employee.name

Answer : D

In Snowflake, to extract a specific value from a VARIANT column, you use the column name followed by a colon and then the key. The keys are case-sensitive. Therefore, to extract the employee's name from the ''Data'' column, the correct syntax isdata:employee.name.

Question 3

What is the purpose of the Snowflake SPLIT TO_TABLE function?

ATo count the number of characters in a string

BTo split a string into an array of sub-strings

CTo split a string and flatten the results into rows

DTo split a string and flatten the results into columns

Answer : C

The purpose of the Snowflake SPLIT_TO_TABLE function is to split a string based on a specified delimiter and flatten the results into rows.This table function is useful for transforming a delimited string into a set of rows that can be further processed or queried5.

Question 4

How can a Snowflake user traverse semi-structured data?

AInsert a colon (:) between the VARIANT column name and any first-level element.

BInsert a colon (:) between the VARIANT column name and any second-level element. C. Insert a double colon (: :) between the VARIANT column name and any first-level element.

DInsert a double colon (: :) between the VARIANT column name and any second-level element.

Answer : A

To traverse semi-structured data in Snowflake, a user can insert a colon (:) between the VARIANT column name and any first-level element.This path syntax is used to retrieve elements in a VARIANT column4.

Question 5

Which views are included in the DATA SHARING USAGE schema? (Select TWO).

AACCESS_HISTORY

BDATA_TRANSFER_HISTORY

CWAREHOUSE_METERING_HISTORY

DMONETIZED_USAGE_DAILY

ELISTING TELEMETRY DAILY

Answer : D, E

The DATA_SHARING_USAGE schema includes views that display information about listings published in the Snowflake Marketplace or a data exchange, which includes DATA_TRANSFER_HISTORY and LISTING_TELEMETRY_DAILY2.

Question 6

What is the primary purpose of a directory table in Snowflake?

ATo store actual data from external stages

BTo automatically expire file URLs for security

CTo manage user privileges and access control

DTo store file-level metadata about data files in a stage

Answer : D

A directory table in Snowflake is used to store file-level metadata about the data files in a stage. It is conceptually similar to an external table and provides information such as file size, last modified timestamp, and file URL. Reference: [COF-C02] SnowPro Core Certification Exam Study Guide

Question 7

What is the relationship between a Query Profile and a virtual warehouse?

AA Query Profile can help users right-size virtual warehouses.

BA Query Profile defines the hardware specifications of the virtual warehouse.

CA Query Profile can help determine the number of virtual warehouses available.

DA Query Profile automatically scales the virtual warehouse based on the query complexity.

Answer : A

A Query Profile provides detailed execution information for a query, which can be used to analyze the performance and behavior of queries. This information can help users optimize and right-size their virtual warehouses for better efficiency. Reference: [COF-C02] SnowPro Core Certification Exam Study Guide

Snowflake SnowPro Core Exam Practice Test