What is true about sharing data in Snowflake? (Choose two.)

• A.A Snowflake account can both provide and consume shared data.
• B.The Data Consumer pays only for compute resources to query the shared data.
• C.The Provider is charged for compute resources used by the Data Consumer to query the shared data.
• D.The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.
• E.The Data Consumer pays for data storage as well as for data computing.

Comment: *

Name: *

Email: *

Verification: *

What type of query benefits the MOST from search optimization?

• A.A query that uses only disjunction (i.e., OR) predicates
• B.A query that includes analytical expressions
• C.A query that uses equality predicates or predicates that use IN
• D.A query that filters on semi-structured data types

Comment: *

Name: *

Email: *

Verification: *

What can be used to view warehouse usage over time? (Select Two).

• A.The billing and usage tab in the Snowflake web Ul
• B.The Query history view
• C.The WAREHOUSE_METERING__HISTORY View
• D.The load HISTORY view
• E.The show warehouses command

Comment: *

Name: *

Email: *

Verification: *

Which of the following terms best describes Snowflake's database architecture?

• A.Columnar shared nothing
• B.Shared disk
• C.Multi-cluster, shared data
• D.Cloud-native shared memory

Comment: *

Name: *

Email: *

Verification: *

Which statement best describes "clustering"?

• A.Clustering represents the way data is grouped together and stored within Snowflake's micro-partitions
• B.The database administrator must define the clustering methodology for each Snowflake table
• C.The clustering key must be included on the COPY command when loading data into Snowflake
• D.Clustering can be disabled within a Snowflake account

Comment: *

Name: *

Email: *

Verification: *