A user needs to know this information about an object:
1. Who accessed the data?
2. When was the data accessed?
3. What columns were accessed?
Which account usage schema view should be used?

• A.QUERYHISTORY
• B.ACCESS_HISTORY
• C.EVENT_USAGE_HISTORY
• D.OBJECT DEPENDENCIES

Comment: *

Name: *

Email: *

Verification: *

What would cause different results to be returned when running the same query twice?

• A.SAMPLE is used and the seed is set
• B.sample is used and the seed is not set.
• C.Fraction-based sampling is used.
• D.Fixed-size sampling Is used.

Comment: *

Name: *

Email: *

Verification: *

How does a Snowflake stored procedure compare to a User-Defined Function (UDF)?

• A.A single executable statement can call only two stored procedures. In contrast, a single SQL statement can call multiple UDFs.
• B.A single executable statement can call only one stored procedure. In contrast, a single SQL statement can call multiple UDFs.
• C.A single executable statement can call multiple stored procedures. In contrast, multiple SQL statements can call the same UDFs.
• D.Multiple executable statements can call more than one stored procedure. In contrast, a single SQL statement can call multiple UDFs.

Comment: *

Name: *

Email: *

Verification: *

What features does Snowflake Time Travel enable?

• A.Querying data-related objects that were created within the past 365 days
• B.Restoring data-related objects that have been deleted within the past 90 days
• C.Conducting point-in-time analysis for Bl reporting
• D.Analyzing data usage/manipulation over all periods of time

Comment: *

Name: *

Email: *

Verification: *

True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *