ExamGecko
Home / Snowflake / SnowPro Core
Ask Question

Snowflake SnowPro Core Practice Test - Questions Answers, Page 40

Question list
Search

Question 391

Report
Export
Collapse

Which Snowflake feature allows a user to track sensitive data for compliance, discovery, protection, and resource usage?

Tags
Tags
Comments
Comments
Internal tokenization
Internal tokenization
Row access policies
Row access policies
Suggested answer: A

Explanation:

Tags in Snowflake allow users to track sensitive data for compliance, discovery, protection, and resource usage.They enable the categorization and tracking of data, supporting compliance with privacy regulations678.

Reference: [COF-C02] SnowPro Core Certification Exam Study Guide

asked 23/09/2024
Bianca Duizer
48 questions

Question 392

Report
Export
Collapse

What are key characteristics of virtual warehouses in Snowflake? (Select TWO).

Warehouses that are multi-cluster can have nodes of different sizes.
Warehouses that are multi-cluster can have nodes of different sizes.
Warehouses can be started and stopped at any time.
Warehouses can be started and stopped at any time.
Warehouses can be resized at any time, even while running.
Warehouses can be resized at any time, even while running.
Warehouses are billed on a per-minute usage basis.
Warehouses are billed on a per-minute usage basis.
Warehouses can only be used for querying and cannot be used for data loading.
Warehouses can only be used for querying and cannot be used for data loading.
Suggested answer: B, C

Explanation:

Virtual warehouses in Snowflake can be started and stopped at any time, providing flexibility in managing compute resources.They can also be resized at any time, even while running, to accommodate varying workloads910.

Reference: [COF-C02] SnowPro Core Certification Exam Study Guide

asked 23/09/2024
safiqueahmed kazi
37 questions

Question 393

Report
Export
Collapse

Which parameter can be set at the account level to set the minimum number of days for which Snowflake retains historical data in Time Travel?

DATA_RETENTION_TIME_IN_DAYS
DATA_RETENTION_TIME_IN_DAYS
MAX_DATA_EXTENSION_TIME_IN_DAYS
MAX_DATA_EXTENSION_TIME_IN_DAYS
MIN_DATA_RETENTION_TIME_IN_DAYS
MIN_DATA_RETENTION_TIME_IN_DAYS
MAX CONCURRENCY LEVEL
MAX CONCURRENCY LEVEL
Suggested answer: A

Explanation:

The parameterDATA_RETENTION_TIME_IN_DAYScan be set at the account level to define the minimum number of days Snowflake retains historical data for Time Travel1.

asked 23/09/2024
Cristian Lazo
38 questions

Question 394

Report
Export
Collapse

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?

CREATE TABLE <table_name> LIKE TABLE_A;
CREATE TABLE <table_name> LIKE TABLE_A;
CREATE VIEW <view_name> AS SELECT * FROM TABLE_A;
CREATE VIEW <view_name> AS SELECT * FROM TABLE_A;
CREATE TABLE <table_name> AS SELECT * FROM TABLE_A;
CREATE TABLE <table_name> AS SELECT * FROM TABLE_A;
CREATE MATERIALIZED VIEW <view name> AS SELECT * FROM TABLE A;
CREATE MATERIALIZED VIEW <view name> AS SELECT * FROM TABLE A;
Suggested answer: C

Explanation:

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.

asked 23/09/2024
Alejandro Ramirez Cuesta
37 questions

Question 395

Report
Export
Collapse

What objects in Snowflake are supported by Dynamic Data Masking? (Select TWO).'

Views
Views
Materialized views
Materialized views
Tables
Tables
External tables
External tables
Future grants
Future grants
Suggested answer: A, C

Explanation:

Dynamic Data Masking in Snowflake supportstables and views.These objects can have masking policies applied to their columns to dynamically mask data at query time3.

asked 23/09/2024
Andrew Oliphant
36 questions

Question 396

Report
Export
Collapse

What happens when a Snowflake user changes the data retention period at the schema level?

All child objects will retain data for the new retention period.
All child objects will retain data for the new retention period.
All child objects that do not have an explicit retention period will automatically inherit the new retention period.
All child objects that do not have an explicit retention period will automatically inherit the new retention period.
All child objects with an explicit retention period will be overridden with the new retention period.
All child objects with an explicit retention period will be overridden with the new retention period.
All explicit child object retention periods will remain unchanged.
All explicit child object retention periods will remain unchanged.
Suggested answer: B

Explanation:

When the data retention period is changed at the schema level, all child objects that do not have an explicit retention period set will inherit the new retention period from the schema4.

asked 23/09/2024
Mian Mudasir Bari
40 questions

Question 397

Report
Export
Collapse

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

TO_CHAR
TO_CHAR
TO_VARIANT
TO_VARIANT
TO_VARCHAR
TO_VARCHAR
STRIP NULL VALUE
STRIP NULL VALUE
Suggested answer: D

Explanation:

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

asked 23/09/2024
Willians Lima Pereira
45 questions

Question 398

Report
Export
Collapse

While working with unstructured data, which file function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs?

GET_PRESIGNED_URL
GET_PRESIGNED_URL
GET_ABSOLUTE_PATH
GET_ABSOLUTE_PATH
BUILD_STAGE_FILE_URL
BUILD_STAGE_FILE_URL
BUILD SCOPED FILE URL
BUILD SCOPED FILE URL
Suggested answer: C

Explanation:

TheBUILD_STAGE_FILE_URLfunction generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs2.

asked 23/09/2024
Christian Galea
40 questions

Question 399

Report
Export
Collapse

Which Snowflake database object can be used to track data changes made to table data?

Tag
Tag
Task
Task
Stream
Stream
Stored procedure
Stored procedure
Suggested answer: C

Explanation:

AStreamobject in Snowflake is used for change data capture (CDC), which records data manipulation language (DML) changes made to tables, including inserts, updates, and deletes3.

asked 23/09/2024
EMELINE LE QUENTREC
29 questions

Question 400

Report
Export
Collapse

What transformations are supported when loading data into a table using the COPY INTO <table> command? (Select TWO).

Column reordering
Column reordering
Column omission
Column omission
JOIN function
JOIN function
FLATTEN function
FLATTEN function
GROUP BY function
GROUP BY function
Suggested answer: A, B

Explanation:

TheCOPY INTO <table>command in Snowflake supports column reordering and column omission as part of its data transformation capabilities during the load process45.

asked 23/09/2024
Daniel Ramos
34 questions
Total 627 questions
Go to page: of 63