ExamGecko
Search Search Login
Home Home / Snowflake / SnowPro Core

Snowflake SnowPro Core Practice Test - Questions Answers, Page 39

Question list
Search
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

A materialized view should be created when which of the following occurs? (Choose two.)
When would Snowsight automatically detect if a target account is in a different region and enable cross-cloud auto-fulfillment?
A view is defined on a permanent table. A temporary table with the same name is created in the same schema as the referenced table. What will the query from the view return?
A user needs to create a materialized view in the schema MYDB.MYSCHEM
Which Snowflake technique can be used to improve the performance of a query?
What is a key feature of Snowflake architecture?
Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?
User-level network policies can be created by which of the following roles? (Select TWO).
Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?
What happens when a virtual warehouse is resized?

Question 381

Report
Export
Collapse

Which function unloads data from a relational table to JSON?

A.
TO_OBJECT
A.
TO_OBJECT
Answers
B.
TO_JSON
B.
TO_JSON
Answers
C.
TO_VARIANT
C.
TO_VARIANT
Answers
D.
OBJECT CONSTRUCT
D.
OBJECT CONSTRUCT
Answers
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

Question 382

Report
Export
Collapse

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

A.
COPY INTO
A.
COPY INTO
Answers
B.
GET
B.
GET
Answers
C.
LIST
C.
LIST
Answers
D.
PUT
D.
PUT
Answers
E.
REMOVE
E.
REMOVE
Answers
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

Question 383

Report
Export
Collapse

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

A.
A Query Profile can help users right-size virtual warehouses.
A.
A Query Profile can help users right-size virtual warehouses.
Answers
B.
A Query Profile defines the hardware specifications of the virtual warehouse.
B.
A Query Profile defines the hardware specifications of the virtual warehouse.
Answers
C.
A Query Profile can help determine the number of virtual warehouses available.
C.
A Query Profile can help determine the number of virtual warehouses available.
Answers
D.
A Query Profile automatically scales the virtual warehouse based on the query complexity.
D.
A Query Profile automatically scales the virtual warehouse based on the query complexity.
Answers
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

Question 384

Report
Export
Collapse

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

A.
To store actual data from external stages
A.
To store actual data from external stages
Answers
B.
To automatically expire file URLs for security
B.
To automatically expire file URLs for security
Answers
C.
To manage user privileges and access control
C.
To manage user privileges and access control
Answers
D.
To store file-level metadata about data files in a stage
D.
To store file-level metadata about data files in a stage
Answers
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

Question 385

Report
Export
Collapse

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

A.
The separation allows independent scaling of computing resources.
A.
The separation allows independent scaling of computing resources.
Answers
B.
The separation ensures consistent data encryption across all virtual data warehouses.
B.
The separation ensures consistent data encryption across all virtual data warehouses.
Answers
C.
The separation supports automatic conversion of semi-structured data into structured data for advanced data analysis.
C.
The separation supports automatic conversion of semi-structured data into structured data for advanced data analysis.
Answers
D.
Storage volume growth and compute usage growth can be tightly coupled.
D.
Storage volume growth and compute usage growth can be tightly coupled.
Answers
E.
Compute can be scaled up or down without the requirement to add more storage.
E.
Compute can be scaled up or down without the requirement to add more storage.
Answers
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.

Question 386

Report
Export
Collapse

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

A.
SHOW
A.
SHOW
Answers
B.
MERGE
B.
MERGE
Answers
C.
INSERT
C.
INSERT
Answers
D.
DELETE
D.
DELETE
Answers
E.
DESCRIBE
E.
DESCRIBE
Answers
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.

Question 387

Report
Export
Collapse

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

A.
Access history
A.
Access history
Answers
B.
Data classification
B.
Data classification
Answers
C.
Dynamic Data Masking
C.
Dynamic Data Masking
Answers
D.
Object tagging
D.
Object tagging
Answers
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.

Question 388

Report
Export
Collapse

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

A.
MONITOR
A.
MONITOR
Answers
B.
OPERATE
B.
OPERATE
Answers
C.
OWNERSHIP
C.
OWNERSHIP
Answers
D.
ALL
D.
ALL
Answers
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.

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?

A.
Use clustering keys
A.
Use clustering keys
Answers
B.
Create materialized views
B.
Create materialized views
Answers
C.
Use the search optimization service
C.
Use the search optimization service
Answers
D.
Use the query acceleration service
D.
Use the query acceleration service
Answers
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

Question 390

Report
Export
Collapse

What does the LATERAL modifier for the FLATTEN function do?

A.
Casts the values of the flattened data
A.
Casts the values of the flattened data
Answers
B.
Extracts the path of the flattened data
B.
Extracts the path of the flattened data
Answers
C.
Joins information outside the object with the flattened data
C.
Joins information outside the object with the flattened data
Answers
D.
Retrieves a single instance of a repeating element in the flattened data
D.
Retrieves a single instance of a repeating element in the flattened data
Answers
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

Total 627 questions
Go to page: of 63
ExamGecko

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Twitter X
Facebook
Medium
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy Policy
Disclaimer
Terms