Snowflake SnowPro-Core Exam Practice Test Instant Access

Question 1

Which Snowflake function is maintained separately from the data and helps to support features such as Time Travel, Secure Data Sharing, and pruning?

AColumn compression

BData clustering

CMicro-partitioning

DMetadata management

Answer : C

Micro-partitioning is a Snowflake function that is maintained separately from the data and supports features such as Time Travel, Secure Data Sharing, and pruning.It allows Snowflake to efficiently manage and query large datasets by organizing them into micro-partitions1.

Question 2

Which type of loop requires a BREAK statement to stop executing?

AFOR

BLOOP

CREPEAT

DWHILE

Answer : B

TheLOOPtype of loop in Snowflake Scripting does not have a built-in termination condition and requires aBREAKstatement to stop executing4.

Question 3

How can a Snowflake administrator determine which user has accessed a database object that contains sensitive information?

AReview the granted privileges to the database object.

BReview the row access policy for the database object.

CQuery the ACCESS_HlSTORY view in the ACCOUNT_USAGE schema.

DQuery the REPLICATION USAGE HISTORY view in the ORGANIZATION USAGE schema.

Answer : C

To determine which user has accessed a database object containing sensitive information, a Snowflake administrator can query theACCESS_HISTORYview in theACCOUNT_USAGEschema, which provides information about access to database objects3.

Question 4

Which Snowflake function will parse a JSON-null into a SQL-null?

ATO_CHAR

BTO_VARIANT

CTO_VARCHAR

DSTRIP NULL VALUE

Answer : D

TheSTRIP_NULL_VALUEfunction in Snowflake is used to convert a JSON null value into a SQL NULL value1.

Question 5

A tag object has been assigned to a table (TABLE_A) in a schema within a Snowflake database.

Which CREATE object statement will automatically assign the TABLE_A tag to a target object?

ACREATE TABLE <table_name> LIKE TABLE_A;

BCREATE VIEW <view_name> AS SELECT * FROM TABLE_A;

CCREATE TABLE <table_name> AS SELECT * FROM TABLE_A;

DCREATE MATERIALIZED VIEW <view name> AS SELECT * FROM TABLE A;

Answer : C

When a tag object is assigned to a table, using the statementCREATE TABLE <table_name> AS SELECT * FROM TABLE_Awill automatically assign the TABLE_A tag to the newly created table2.

Question 6

Which Snowflake object does not consume any storage costs?

ASecure view

BMaterialized view

CTemporary table

DTransient table

Answer : C

Temporary tables do not consume any storage costs in Snowflake because they only exist for the duration of the session that created them and are automatically dropped when the session ends, thus incurring no long-term storage charges4. Reference: [COF-C02] SnowPro Core Certification Exam Study Guide

Question 7

Which solution improves the performance of point lookup queries that return a small number of rows from large tables using highly selective filters?

AAutomatic clustering

BMaterialized views

CQuery acceleration service

DSearch optimization service

Answer : D

The search optimization service improves the performance of point lookup queries on large tables by using selective filters to quickly return a small number of rows.It creates an optimized data structure that helps in pruning the micro-partitions that do not contain the queried values3. Reference: [COF-C02] SnowPro Core Certification Exam Study Guide

Snowflake SnowPro Core Exam Practice Test