ExamGecko
Login
Home / Snowflake / SnowPro Core / List of questions
Ask Question

Snowflake SnowPro Core Practice Test - Questions Answers, Page 17

List of questions

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?

The explain plan output is available graphically.
The explain plan output is available graphically.
An explain plan can be used to conduct performance analysis without executing a query.
An explain plan can be used to conduct performance analysis without executing a query.
An explain plan will handle queries with temporary tables and the query profiler will not.
An explain plan will handle queries with temporary tables and the query profiler will not.
An explain plan's output will display automatic data skew optimization information.
An explain plan's output will display automatic data skew optimization information.
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

asked 23/09/2024
Jose Manuel Belmonte Martinez
34 questions

Question 162

Report
Export
Collapse

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

VARIANT
VARIANT
VARRAY
VARRAY
STRUCT
STRUCT
ARRAY
ARRAY
QUEUE
QUEUE
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

asked 23/09/2024
Marcelo I Sotelo S
36 questions

Question 163

Report
Export
Collapse

What affects whether the query results cache can be used?

If the query contains a deterministic function
If the query contains a deterministic function
If the virtual warehouse has been suspended
If the virtual warehouse has been suspended
If the referenced data in the table has changed
If the referenced data in the table has changed
If multiple users are using the same virtual warehouse
If multiple users are using the same virtual warehouse
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.

asked 23/09/2024
Heidar Heidari nia
33 questions

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?

SELECT SUM (ORDER_AMT) FROM SALES;
SELECT SUM (ORDER_AMT) FROM SALES;
SELECT AVG(ORDER_QTY) FROM SALES;
SELECT AVG(ORDER_QTY) FROM SALES;
SELECT MIN(ORDER_AMT) FROM SALES;
SELECT MIN(ORDER_AMT) FROM SALES;
SELECT ORDER_AMT * ORDER_QTY FROM SALES;
SELECT ORDER_AMT * ORDER_QTY FROM SALES;
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.

asked 23/09/2024
Mustapha Amine Atmani
46 questions

Question 165

Report
Export
Collapse

How many days is load history for Snowpipe retained?

1 day
1 day
7 days
7 days
14 days
14 days
64 days
64 days
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.

asked 23/09/2024
Francisco Jesús Cano Hinarejos
53 questions

Question 166

Report
Export
Collapse

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

Within the policy DDL
Within the policy DDL
Within the create table or create view DDL
Within the create table or create view DDL
By future APPLY for all objects in a schema
By future APPLY for all objects in a schema
Within a control table
Within a control table
Using the command ALTER <object> ADD ROW ACCESS POLICY ;
Using the command ALTER <object> ADD ROW ACCESS POLICY ;
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

asked 23/09/2024
Michael Love
27 questions

Question 167

Report
Export
Collapse

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

JOIN
JOIN
COPY INTO
COPY INTO
PUT
PUT
GET
GET
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

asked 23/09/2024
Lars Bleckmann
41 questions

Question 168

Report
Export
Collapse

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

Reader
Reader
Consumer
Consumer
Vendor
Vendor
Standard
Standard
Personalized
Personalized
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.

asked 23/09/2024
stefano atzei
33 questions

Question 169

Report
Export
Collapse

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

90 days
90 days
1 day
1 day
7 days
7 days
45 days
45 days
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

asked 23/09/2024
Kyle Norton
37 questions

Question 170

Report
Export
Collapse

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

When it is unknown how much compute power is needed
When it is unknown how much compute power is needed
If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)
If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)
If the runtime of the executed query is very slow
If the runtime of the executed query is very slow
When a large number of concurrent queries are run on the same warehouse
When a large number of concurrent queries are run on the same warehouse
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

asked 23/09/2024
Janko Schutte
32 questions
Total 627 questions
Go to page: of 63
Open VPLUS File
Convert VPLUS to PDF

Related questions

What is a key feature of Snowflake architecture?
Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).
How is unstructured data retrieved from data storage?
Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?
A materialized view should be created when which of the following occurs? (Choose two.)
What happens when a virtual warehouse is resized?
How can a Snowflake user traverse semi-structured data?
When would Snowsight automatically detect if a target account is in a different region and enable cross-cloud auto-fulfillment?
A user needs to create a materialized view in the schema MYDB.MYSCHEM
User-level network policies can be created by which of the following roles? (Select TWO).