ExamGecko
Search Search Login
Home Home / Snowflake / SnowPro Core

Snowflake SnowPro Core Practice Test - Questions Answers, Page 17

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?
Will data cached in a warehouse be lost when the warehouse is resized?

Question 161

Report
Export
Collapse

What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?

A.
The explain plan output is available graphically.
A.
The explain plan output is available graphically.
Answers
B.
An explain plan can be used to conduct performance analysis without executing a query.
B.
An explain plan can be used to conduct performance analysis without executing a query.
Answers
C.
An explain plan will handle queries with temporary tables and the query profiler will not.
C.
An explain plan will handle queries with temporary tables and the query profiler will not.
Answers
D.
An explain plan's output will display automatic data skew optimization information.
D.
An explain plan's output will display automatic data skew optimization information.
Answers
Suggested answer: B

Explanation:

An explain plan is beneficial because it allows for the evaluation of how a query will be processed without the need to actually execute the query.This can help in understanding the query's performance implications and potential bottlenecks without consuming resources that would be used if the query were run

Question 162

Report
Export
Collapse

Which data types are supported by Snowflake when using semi-structured data? (Choose two.)

A.
VARIANT
A.
VARIANT
Answers
B.
VARRAY
B.
VARRAY
Answers
C.
STRUCT
C.
STRUCT
Answers
D.
ARRAY
D.
ARRAY
Answers
E.
QUEUE
E.
QUEUE
Answers
Suggested answer: A, D

Explanation:

Snowflake supports the VARIANT and ARRAY data types for semi-structured data. VARIANT can store values of any other type, including OBJECT and ARRAY, making it suitable for semi-structured data formats like JSON.ARRAY is used to store an ordered list of elements

Question 163

Report
Export
Collapse

What affects whether the query results cache can be used?

A.
If the query contains a deterministic function
A.
If the query contains a deterministic function
Answers
B.
If the virtual warehouse has been suspended
B.
If the virtual warehouse has been suspended
Answers
C.
If the referenced data in the table has changed
C.
If the referenced data in the table has changed
Answers
D.
If multiple users are using the same virtual warehouse
D.
If multiple users are using the same virtual warehouse
Answers
Suggested answer: C

Explanation:

The query results cache can be used as long as the data in the table has not changed since the last time the query was run.If the underlying data has changed, Snowflake will not use the cached results and will re-execute the query1.

Question 164

Report
Export
Collapse

Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?

A.
SELECT SUM (ORDER_AMT) FROM SALES;
A.
SELECT SUM (ORDER_AMT) FROM SALES;
Answers
B.
SELECT AVG(ORDER_QTY) FROM SALES;
B.
SELECT AVG(ORDER_QTY) FROM SALES;
Answers
C.
SELECT MIN(ORDER_AMT) FROM SALES;
C.
SELECT MIN(ORDER_AMT) FROM SALES;
Answers
D.
SELECT ORDER_AMT * ORDER_QTY FROM SALES;
D.
SELECT ORDER_AMT * ORDER_QTY FROM SALES;
Answers
Suggested answer: B

Explanation:

Operations that do not require compute resources are typically those that can leverage previously cached results. However, if no queries have been executed previously, all the given operations would require compute to execute.It's important to note that certain operations like DDL statements and queries that hit the result cache do not consume compute credits2.

Question 165

Report
Export
Collapse

How many days is load history for Snowpipe retained?

A.
1 day
A.
1 day
Answers
B.
7 days
B.
7 days
Answers
C.
14 days
C.
14 days
Answers
D.
64 days
D.
64 days
Answers
Suggested answer: C

Explanation:

Snowpipe retains load history for 14 days.This allows users to view and audit the data that has been loaded into Snowflake using Snowpipe within this time frame3.

Question 166

Report
Export
Collapse

How can a row access policy be applied to a table or a view? (Choose two.)

A.
Within the policy DDL
A.
Within the policy DDL
Answers
B.
Within the create table or create view DDL
B.
Within the create table or create view DDL
Answers
C.
By future APPLY for all objects in a schema
C.
By future APPLY for all objects in a schema
Answers
D.
Within a control table
D.
Within a control table
Answers
E.
Using the command ALTER <object> ADD ROW ACCESS POLICY ;
E.
Using the command ALTER <object> ADD ROW ACCESS POLICY ;
Answers
Suggested answer: A, E

Explanation:

A row access policy can be applied to a table or a view within the policy DDL when defining the policy.Additionally, an existing row access policy can be applied to a table or a view using theALTER <object> ADD ROW ACCESS POLICY command

Question 167

Report
Export
Collapse

Which command can be used to load data files into a Snowflake stage?

A.
JOIN
A.
JOIN
Answers
B.
COPY INTO
B.
COPY INTO
Answers
C.
PUT
C.
PUT
Answers
D.
GET
D.
GET
Answers
Suggested answer: C

Explanation:

ThePUTcommand is used to load data files into a Snowflake stage.This command uploads data files from a local file system to a specified stage in Snowflake

Question 168

Report
Export
Collapse

What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)

A.
Reader
A.
Reader
Answers
B.
Consumer
B.
Consumer
Answers
C.
Vendor
C.
Vendor
Answers
D.
Standard
D.
Standard
Answers
E.
Personalized
E.
Personalized
Answers
Suggested answer: C, E

Explanation:

In the Snowflake Data Marketplace, the types of data listings available include 'Vendor', which refers to the providers of data, and 'Personalized', which indicates customized data offerings tailored to specific consumer needs45.

Question 169

Report
Export
Collapse

What is the maximum Time Travel retention period for a temporary Snowflake table?

A.
90 days
A.
90 days
Answers
B.
1 day
B.
1 day
Answers
C.
7 days
C.
7 days
Answers
D.
45 days
D.
45 days
Answers
Suggested answer: B

Explanation:

The maximum Time Travel retention period for a temporary Snowflake table is 1 day.This is the standard retention period for temporary tables, which allows for accessing historical data within a 24-hour window

Question 170

Report
Export
Collapse

When should a multi-cluster warehouse be used in auto-scaling mode?

A.
When it is unknown how much compute power is needed
A.
When it is unknown how much compute power is needed
Answers
B.
If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)
B.
If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)
Answers
C.
If the runtime of the executed query is very slow
C.
If the runtime of the executed query is very slow
Answers
D.
When a large number of concurrent queries are run on the same warehouse
D.
When a large number of concurrent queries are run on the same warehouse
Answers
Suggested answer: D

Explanation:

A multi-cluster warehouse should be used in auto-scaling mode when there is a need to handle a large number of concurrent queries.Auto-scaling allows Snowflake to automatically add or remove compute clusters to balance the load, ensuring that performance remains consistent during varying levels of demand

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