Which views are included in the DATA SHARING USAGE schema? (Select TWO).

• A.ACCESS_HISTORY
• B.DATA_TRANSFER_HISTORY
• C.WAREHOUSE_METERING_HISTORY
• D.MONETIZED_USAGE_DAILY
• E.LISTING TELEMETRY DAILY

Comment: *

Name: *

Email: *

Verification: *

A Snowflake user has two tables that contain numeric values and is trying to find out which values are present in both tables. Which set operator should be used?

• A.MINUS
• B.MFRCK
• C.UNION
• D.INTERSECT

Comment: *

Name: *

Email: *

Verification: *

Which of the following statements is true of Snowflake micro-partitioning?

• A.Micro-partitioning can be disabled within a Snowflake account
• B.Micro-partitioning: requires a partitioning schema to be defined up front
• C.Micro-partitioning has been known to introduce data skew
• D.Micro-partitioning is transparently completed using the ordering that occurs when the data is inserted/loaded

Comment: *

Name: *

Email: *

Verification: *

From what stage can a Snowflake user omit the FROM clause while loading data into a table?

• A.The user stage
• B.The table stage
• C.The internal named stage
• D.The external named stage

Comment: *

Name: *

Email: *

Verification: *

What are the main differences between the account usage views and the information schema views? (Select TWO).

• A.No active warehouse to needed to query account usage views but one is needed to query information schema views.
• B.Account usage views do not contain data about tables but information schema views do.
• C.Account issue views contain dropped objects but information schema views do not.
• D.Data retention for account usage views is 1 year but is 7 days to 6 months for information schema views, depending on the view.
• E.Information schema views are read-only but account usage views are not.

Comment: *

Name: *

Email: *

Verification: *