ExamGecko
Home / Snowflake / SnowPro Core
Ask Question

Snowflake SnowPro Core Practice Test - Questions Answers, Page 31

Question list
Search

Question 301

Report
Export
Collapse

What role is required to use Partner Connect?

ACCOUNTADMIN
ACCOUNTADMIN
ORGADMIN
ORGADMIN
SECURITYADMIN
SECURITYADMIN
SYSADMIN
SYSADMIN
Suggested answer: A

Explanation:

To use Partner Connect, the ACCOUNTADMIN role is required.Partner Connect allows account administrators to easily create trial accounts with selected Snowflake business partners and integrate these accounts with Snowflake

asked 23/09/2024
Max Archer
38 questions

Question 302

Report
Export
Collapse

How does a scoped URL expire?

When the data cache clears.
When the data cache clears.
When the persisted query result period ends.
When the persisted query result period ends.
The encoded URL access is permanent.
The encoded URL access is permanent.
The length of time is specified in the expiration_time argument.
The length of time is specified in the expiration_time argument.
Suggested answer: B

Explanation:

A scoped URL expires when the persisted query result period ends, which is typically after the results cache expires.This is currently set to 24 hours

asked 23/09/2024
Aung Nyi Nyi Win
30 questions

Question 303

Report
Export
Collapse

Which features make up Snowflake's column level security? (Select TWO).

Continuous Data Protection (CDP)
Continuous Data Protection (CDP)
Dynamic Data Masking
Dynamic Data Masking
External Tokenization
External Tokenization
Key pair authentication
Key pair authentication
Row access policies
Row access policies
Suggested answer: B, C

Explanation:

Snowflake's column level security features include Dynamic Data Masking and External Tokenization.Dynamic Data Masking uses masking policies to selectively mask data at query time, while External Tokenization allows for the tokenization of data before loading it into Snowflake and detokenizing it at query runtime5.

asked 23/09/2024
evalson martin laplap
49 questions

Question 304

Report
Export
Collapse

What is the difference between a stored procedure and a User-Defined Function (UDF)?

Stored procedures can execute database operations while UDFs cannot.
Stored procedures can execute database operations while UDFs cannot.
Returning a value is required in a stored procedure while returning values in a UDF is optional.
Returning a value is required in a stored procedure while returning values in a UDF is optional.
Values returned by a stored procedure can be used directly in a SQL statement while the values returned by a UDF cannot.
Values returned by a stored procedure can be used directly in a SQL statement while the values returned by a UDF cannot.
Multiple stored procedures can be called as part of a single executable statement while a single SQL statement can only call one UDF at a time.
Multiple stored procedures can be called as part of a single executable statement while a single SQL statement can only call one UDF at a time.
Suggested answer: A

Explanation:

Stored procedures in Snowflake can perform a variety of database operations, including DDL and DML, whereas UDFs are designed to return values and cannot execute database operations1.

asked 23/09/2024
Lal George
26 questions

Question 305

Report
Export
Collapse

When should a user consider disabling auto-suspend for a virtual warehouse? (Select TWO).

When users will be using compute at different times throughout a 24/7 period
When users will be using compute at different times throughout a 24/7 period
When managing a steady workload
When managing a steady workload
When the compute must be available with no delay or lag time
When the compute must be available with no delay or lag time
When the user does not want to have to manually turn on the warehouse each time it is needed
When the user does not want to have to manually turn on the warehouse each time it is needed
When the warehouse is shared across different teams
When the warehouse is shared across different teams
Suggested answer: B, C

Explanation:

Disabling auto-suspend for a virtual warehouse is recommended when there is a steady workload, which ensures that compute resources are always available.Additionally, it is advisable to disable auto-suspend when immediate availability of compute resources is critical, eliminating any startup delay

asked 23/09/2024
Nidal Allamadani
45 questions

Question 306

Report
Export
Collapse

How does Snowflake handle the bulk unloading of data into single or multiple files?

It assigns each unloaded data file a unique name.
It assigns each unloaded data file a unique name.
It uses the put command to download the data by default.
It uses the put command to download the data by default.
It uses COPY INTO <location> for bulk unloading where the default option is SINGLE - TRUE.
It uses COPY INTO <location> for bulk unloading where the default option is SINGLE - TRUE.
It uses COPY INTO <location> to copy the data from a table into one or more files in an external stage only.
It uses COPY INTO <location> to copy the data from a table into one or more files in an external stage only.
Suggested answer: A

Explanation:

When unloading data, Snowflake assigns each file a unique name to ensure there is no overlap or confusion between files.This is part of the bulk unloading process where data is exported from Snowflake tables into flat files3.

asked 23/09/2024
Julius Nammeh
44 questions

Question 307

Report
Export
Collapse

If file format options are specified in multiple locations, the load operation selects which option FIRST to apply in order of precedence?

Table definition
Table definition
Stage definition
Stage definition
Session level
Session level
COPY INTO TABLE statement
COPY INTO TABLE statement
Suggested answer: D

Explanation:

When file format options are specified in multiple locations, the load operation applies the options in the following order of precedence: first, the COPY INTO TABLE statement; second, the stage definition; and third, the table definition1

asked 23/09/2024
Darren Sloan
41 questions

Question 308

Report
Export
Collapse

Which statement accurately describes a characteristic of a materialized view?

A materialized view can query only a single table.
A materialized view can query only a single table.
Data accessed through materialized views can be stale.
Data accessed through materialized views can be stale.
Materialized view refreshes need to be maintained by the user.
Materialized view refreshes need to be maintained by the user.
Querying a materialized view is slower than executing a query against the base table of the view.
Querying a materialized view is slower than executing a query against the base table of the view.
Suggested answer: B

Explanation:

A characteristic of a materialized view is that the data accessed through it can be stale.This is because the data in a materialized view may not reflect the latest changes in the base tables until the view is refreshed

asked 23/09/2024
marco giovinazzo
29 questions

Question 309

Report
Export
Collapse

Which stream type can be used for tracking the records in external tables?

Append-only
Append-only
External
External
Insert-only
Insert-only
Standard
Standard
Suggested answer: B

Explanation:

The stream type that can be used for tracking the records in external tables is 'External'.This type of stream is specifically designed to track changes in external tables

asked 23/09/2024
Mekmek Kh
37 questions

Question 310

Report
Export
Collapse

What can a Snowflake user do in the Activity section in Snowsight?

Create dashboards.
Create dashboards.
Write and run SQL queries.
Write and run SQL queries.
Explore databases and objects.
Explore databases and objects.
Explore executed query performance.
Explore executed query performance.
Suggested answer: D

Explanation:

In the Activity section in Snowsight, Snowflake users can explore the performance of executed queries.This includes monitoring queries, viewing details about queries, including performance data, and exploring each step of an executed query in the query profile1.

asked 23/09/2024
Neha Kumari
50 questions
Total 627 questions
Go to page: of 63