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

Comment: *

Name: *

Email: *

Verification: *

A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed.
What will occur?

• A.The virtual warehouse that is defined at the session level will be used to read all data.
• B.The default virtual warehouse will be used to read all data.
• C.No virtual warehouse will be used, data will be read from the local disk cache.
• D.No virtual warehouse will be used, data will be read from the result cache.

Comment: *

Name: *

Email: *

Verification: *

The effects of query pruning can be observed by evaluating which statistics? (Select TWO).

• A.Partitions scanned
• B.Partitions total
• C.Bytes scanned
• D.Bytes read from result
• E.Bytes written

Comment: *

Name: *

Email: *

Verification: *

Which Snowflake architectural layer is responsible for a query execution plan?

• A.Compute
• B.Data storage
• C.Cloud services
• D.Cloud provider

Comment: *

Name: *

Email: *

Verification: *

How does the Access_History view enhance overall data governance pertaining to read and write operations?
(Select TWO).

• A.Shows how the accessed data was moved from the source lo the target objects
• B.Provides a unified picture of what data was accessed and when it was accessed
• C.Protects sensitive data from unauthorized access while allowing authorized users to access it at query runtime
• D.Identifies columns with personal information and tags them so masking policies can be applied to protect sensitive data
• E.Determines whether a given row in a table can be accessed by the user by filtering the data based on a given policy

Comment: *

Name: *

Email: *

Verification: *