ExamGecko
Home / Snowflake / SnowPro Core / List of questions
Ask Question

Snowflake SnowPro Core Practice Test - Questions Answers, Page 41

Question list
Search

Question 401

Report
Export
Collapse

Which Snowflake table objects can be shared with other accounts? (Select TWO).

Temporary tables
Temporary tables
Permanent tables
Permanent tables
Transient tables
Transient tables
External tables
External tables
User-Defined Table Functions (UDTFs)
User-Defined Table Functions (UDTFs)
Suggested answer: B, D

Explanation:

In Snowflake,permanent tablesandexternal tablescan be shared with other accounts using Secure Data Sharing.Temporary tables, transient tables, and UDTFs are not shareable objects

asked 23/09/2024
Malik Adeel Imtiaz
30 questions

Question 402

Report
Export
Collapse

Which object can be used with Secure Data Sharing?

View
View
Materialized view
Materialized view
External table
External table
User-Defined Function (UDF)
User-Defined Function (UDF)
Suggested answer: A

Explanation:

Viewscan be used with Secure Data Sharing in Snowflake.Materialized views, external tables, and UDFs are not typically shared directly for security and performance reasons2.

asked 23/09/2024
Nelson Alvaro
49 questions

Question 403

Report
Export
Collapse

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

Review the granted privileges to the database object.
Review the granted privileges to the database object.
Review the row access policy for the database object.
Review the row access policy for the database object.
Query the ACCESS_HlSTORY view in the ACCOUNT_USAGE schema.
Query the ACCESS_HlSTORY view in the ACCOUNT_USAGE schema.
Query the REPLICATION USAGE HISTORY view in the ORGANIZATION USAGE schema.
Query the REPLICATION USAGE HISTORY view in the ORGANIZATION USAGE schema.
Suggested answer: C

Explanation:

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.

asked 23/09/2024
Oktorio Rizki Prasetya
46 questions

Question 404

Report
Export
Collapse

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

FOR
FOR
LOOP
LOOP
REPEAT
REPEAT
WHILE
WHILE
Suggested answer: B

Explanation:

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

asked 23/09/2024
Tsige Tessema
31 questions

Question 405

Report
Export
Collapse

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

Column compression
Column compression
Data clustering
Data clustering
Micro-partitioning
Micro-partitioning
Metadata management
Metadata management
Suggested answer: C

Explanation:

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.

asked 23/09/2024
Jordan Arribas Aranda
36 questions

Question 406

Report
Export
Collapse

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

ACCESS_HISTORY
ACCESS_HISTORY
DATA_TRANSFER_HISTORY
DATA_TRANSFER_HISTORY
WAREHOUSE_METERING_HISTORY
WAREHOUSE_METERING_HISTORY
MONETIZED_USAGE_DAILY
MONETIZED_USAGE_DAILY
LISTING TELEMETRY DAILY
LISTING TELEMETRY DAILY
Suggested answer: D, E

Explanation:

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.

asked 23/09/2024
Daniel Silva
42 questions

Question 407

Report
Export
Collapse

What are the least privileges needed to view and modify resource monitors? (Select TWO).

SELECT
SELECT
OWNERSHIP
OWNERSHIP
MONITOR
MONITOR
MODIFY
MODIFY
USAGE
USAGE
Suggested answer: C, D

Explanation:

To view and modify resource monitors, the least privileges needed are MONITOR and MODIFY.These privileges allow a user to monitor credit usage and make changes to resource monitors3.

asked 23/09/2024
Tom Rez
35 questions

Question 408

Report
Export
Collapse

How can a Snowflake user traverse semi-structured data?

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

Explanation:

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.

asked 23/09/2024
Crystal Eagle
31 questions

Question 409

Report
Export
Collapse

What is the purpose of the Snowflake SPLIT TO_TABLE function?

To count the number of characters in a string
To count the number of characters in a string
To split a string into an array of sub-strings
To split a string into an array of sub-strings
To split a string and flatten the results into rows
To split a string and flatten the results into rows
To split a string and flatten the results into columns
To split a string and flatten the results into columns
Suggested answer: C

Explanation:

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.

asked 23/09/2024
Oliver Mark
36 questions

Question 410

Report
Export
Collapse

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

Snowflake SnowPro Core image Question 410 74771 09232024004505000000

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

Data:employee.name
Data:employee.name
DATA:employee.name
DATA:employee.name
data:Employee.name
data:Employee.name
data:employee.name
data:employee.name
Suggested answer: D

Explanation:

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.

asked 23/09/2024
Josh Rose
40 questions
Total 627 questions
Go to page: of 63