ExamGecko
Home / Snowflake / SnowPro Core
Ask Question

Snowflake SnowPro Core Practice Test - Questions Answers, Page 39

Question list
Search

Question 381

Report
Export
Collapse

Which function unloads data from a relational table to JSON?

TO_OBJECT
TO_OBJECT
TO_JSON
TO_JSON
TO_VARIANT
TO_VARIANT
OBJECT CONSTRUCT
OBJECT CONSTRUCT
Suggested answer: B

Explanation:

TheTO_JSONfunction is used to convert a VARIANT value into a string containing the JSON representation of the value. This function is suitable for unloading data from a relational table to JSON format.

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

asked 23/09/2024
sicnarep sicnarep
44 questions

Question 382

Report
Export
Collapse

Which commands can only be executed using SnowSQL? (Select TWO).

COPY INTO
COPY INTO
GET
GET
LIST
LIST
PUT
PUT
REMOVE
REMOVE
Suggested answer: C, D

Explanation:

TheLISTandPUTcommands are specific to SnowSQL and cannot be executed in the web interface or other SQL clients.LISTis used to display the contents of a stage, andPUTis used to upload files to a stage.

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

asked 23/09/2024
Renats Fasulins
41 questions

Question 383

Report
Export
Collapse

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

A Query Profile can help users right-size virtual warehouses.
A Query Profile can help users right-size virtual warehouses.
A Query Profile defines the hardware specifications of the virtual warehouse.
A Query Profile defines the hardware specifications of the virtual warehouse.
A Query Profile can help determine the number of virtual warehouses available.
A Query Profile can help determine the number of virtual warehouses available.
A Query Profile automatically scales the virtual warehouse based on the query complexity.
A Query Profile automatically scales the virtual warehouse based on the query complexity.
Suggested answer: A

Explanation:

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

asked 23/09/2024
Nicholas Stoner
41 questions

Question 384

Report
Export
Collapse

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

To store actual data from external stages
To store actual data from external stages
To automatically expire file URLs for security
To automatically expire file URLs for security
To manage user privileges and access control
To manage user privileges and access control
To store file-level metadata about data files in a stage
To store file-level metadata about data files in a stage
Suggested answer: D

Explanation:

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

asked 23/09/2024
Franklin Leon
36 questions

Question 385

Report
Export
Collapse

Which statements describe benefits of Snowflake's separation of compute and storage? (Select TWO).

The separation allows independent scaling of computing resources.
The separation allows independent scaling of computing resources.
The separation ensures consistent data encryption across all virtual data warehouses.
The separation ensures consistent data encryption across all virtual data warehouses.
The separation supports automatic conversion of semi-structured data into structured data for advanced data analysis.
The separation supports automatic conversion of semi-structured data into structured data for advanced data analysis.
Storage volume growth and compute usage growth can be tightly coupled.
Storage volume growth and compute usage growth can be tightly coupled.
Compute can be scaled up or down without the requirement to add more storage.
Compute can be scaled up or down without the requirement to add more storage.
Suggested answer: A, E

Explanation:

Snowflake's architecture allows for the independent scaling of compute resources, meaning you can increase or decrease the computational power as needed without affecting storage. This separation also means that storage can grow independently of compute usage, allowing for more flexible and cost-effective data management.

asked 23/09/2024
Arti Karangiya
34 questions

Question 386

Report
Export
Collapse

Which commands are restricted in owner's rights stored procedures? (Select TWO).

SHOW
SHOW
MERGE
MERGE
INSERT
INSERT
DELETE
DELETE
DESCRIBE
DESCRIBE
Suggested answer: A, E

Explanation:

In owner's rights stored procedures, certain commands are restricted to maintain security and integrity. The SHOW and DESCRIBE commands are limited because they can reveal metadata and structure information that may not be intended for all roles.

asked 23/09/2024
Bryan Smith
43 questions

Question 387

Report
Export
Collapse

Which Snowflake feature allows administrators to identify unused data that may be archived or deleted?

Access history
Access history
Data classification
Data classification
Dynamic Data Masking
Dynamic Data Masking
Object tagging
Object tagging
Suggested answer: A

Explanation:

The Access History feature in Snowflake allows administrators to track data access patterns and identify unused data. This information can be used to make decisions about archiving or deleting data to optimize storage and reduce costs.

asked 23/09/2024
Tim Baas
42 questions

Question 388

Report
Export
Collapse

Which privilege must be granted by one role to another role, and cannot be revoked?

MONITOR
MONITOR
OPERATE
OPERATE
OWNERSHIP
OWNERSHIP
ALL
ALL
Suggested answer: C

Explanation:

The OWNERSHIP privilege is unique in that it must be granted by one role to another and cannot be revoked. This ensures that the transfer of ownership is deliberate and permanent, reflecting the importance of ownership in managing access and permissions.

asked 23/09/2024
Dinu Jose Varghese
38 questions

Question 389

Report
Export
Collapse

How can performance be optimized for a query that returns a small amount of data from a very large base table?

Use clustering keys
Use clustering keys
Create materialized views
Create materialized views
Use the search optimization service
Use the search optimization service
Use the query acceleration service
Use the query acceleration service
Suggested answer: C

Explanation:

The search optimization service in Snowflake is designed to improve the performance of selective point lookup queries on large tables, which is ideal for scenarios where a query returns a small amount of data from a very large base table1.

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

asked 23/09/2024
Sergio Quintero Angel
36 questions

Question 390

Report
Export
Collapse

What does the LATERAL modifier for the FLATTEN function do?

Casts the values of the flattened data
Casts the values of the flattened data
Extracts the path of the flattened data
Extracts the path of the flattened data
Joins information outside the object with the flattened data
Joins information outside the object with the flattened data
Retrieves a single instance of a repeating element in the flattened data
Retrieves a single instance of a repeating element in the flattened data
Suggested answer: C

Explanation:

The LATERAL modifier for the FLATTEN function allows joining information outside the object (such as other columns in the source table) with the flattened data, creating a lateral view that correlates with the preceding tables in the FROM clause2345.

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

asked 23/09/2024
Peter Stones
39 questions
Total 627 questions
Go to page: of 63