ExamGecko
Search Search Login
Home Home / Snowflake / SnowPro Core

Snowflake SnowPro Core Practice Test - Questions Answers, Page 31

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 301

Report
Export
Collapse

What role is required to use Partner Connect?

A.
ACCOUNTADMIN
A.
ACCOUNTADMIN
Answers
B.
ORGADMIN
B.
ORGADMIN
Answers
C.
SECURITYADMIN
C.
SECURITYADMIN
Answers
D.
SYSADMIN
D.
SYSADMIN
Answers
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

Question 302

Report
Export
Collapse

How does a scoped URL expire?

A.
When the data cache clears.
A.
When the data cache clears.
Answers
B.
When the persisted query result period ends.
B.
When the persisted query result period ends.
Answers
C.
The encoded URL access is permanent.
C.
The encoded URL access is permanent.
Answers
D.
The length of time is specified in the expiration_time argument.
D.
The length of time is specified in the expiration_time argument.
Answers
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

Question 303

Report
Export
Collapse

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

A.
Continuous Data Protection (CDP)
A.
Continuous Data Protection (CDP)
Answers
B.
Dynamic Data Masking
B.
Dynamic Data Masking
Answers
C.
External Tokenization
C.
External Tokenization
Answers
D.
Key pair authentication
D.
Key pair authentication
Answers
E.
Row access policies
E.
Row access policies
Answers
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.

Question 304

Report
Export
Collapse

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

A.
Stored procedures can execute database operations while UDFs cannot.
A.
Stored procedures can execute database operations while UDFs cannot.
Answers
B.
Returning a value is required in a stored procedure while returning values in a UDF is optional.
B.
Returning a value is required in a stored procedure while returning values in a UDF is optional.
Answers
C.
Values returned by a stored procedure can be used directly in a SQL statement while the values returned by a UDF cannot.
C.
Values returned by a stored procedure can be used directly in a SQL statement while the values returned by a UDF cannot.
Answers
D.
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.
D.
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.
Answers
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.

Question 305

Report
Export
Collapse

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

A.
When users will be using compute at different times throughout a 24/7 period
A.
When users will be using compute at different times throughout a 24/7 period
Answers
B.
When managing a steady workload
B.
When managing a steady workload
Answers
C.
When the compute must be available with no delay or lag time
C.
When the compute must be available with no delay or lag time
Answers
D.
When the user does not want to have to manually turn on the warehouse each time it is needed
D.
When the user does not want to have to manually turn on the warehouse each time it is needed
Answers
E.
When the warehouse is shared across different teams
E.
When the warehouse is shared across different teams
Answers
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

Question 306

Report
Export
Collapse

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

A.
It assigns each unloaded data file a unique name.
A.
It assigns each unloaded data file a unique name.
Answers
B.
It uses the put command to download the data by default.
B.
It uses the put command to download the data by default.
Answers
C.
It uses COPY INTO <location> for bulk unloading where the default option is SINGLE - TRUE.
C.
It uses COPY INTO <location> for bulk unloading where the default option is SINGLE - TRUE.
Answers
D.
It uses COPY INTO <location> to copy the data from a table into one or more files in an external stage only.
D.
It uses COPY INTO <location> to copy the data from a table into one or more files in an external stage only.
Answers
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.

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?

A.
Table definition
A.
Table definition
Answers
B.
Stage definition
B.
Stage definition
Answers
C.
Session level
C.
Session level
Answers
D.
COPY INTO TABLE statement
D.
COPY INTO TABLE statement
Answers
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

Question 308

Report
Export
Collapse

Which statement accurately describes a characteristic of a materialized view?

A.
A materialized view can query only a single table.
A.
A materialized view can query only a single table.
Answers
B.
Data accessed through materialized views can be stale.
B.
Data accessed through materialized views can be stale.
Answers
C.
Materialized view refreshes need to be maintained by the user.
C.
Materialized view refreshes need to be maintained by the user.
Answers
D.
Querying a materialized view is slower than executing a query against the base table of the view.
D.
Querying a materialized view is slower than executing a query against the base table of the view.
Answers
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

Question 309

Report
Export
Collapse

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

A.
Append-only
A.
Append-only
Answers
B.
External
B.
External
Answers
C.
Insert-only
C.
Insert-only
Answers
D.
Standard
D.
Standard
Answers
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

Question 310

Report
Export
Collapse

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

A.
Create dashboards.
A.
Create dashboards.
Answers
B.
Write and run SQL queries.
B.
Write and run SQL queries.
Answers
C.
Explore databases and objects.
C.
Explore databases and objects.
Answers
D.
Explore executed query performance.
D.
Explore executed query performance.
Answers
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.

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