When retrieving data from a table which type of query will benefit the MOST from use of the search optimization service?

• A.Queries that involve one or more columns inside the cluster key using the lowest cardinality to select filters.
• B.Queries on fields in a VARIANT column that will return all data as structured data.
• C.Queries with unpredictable data volumes.
• D.Queries with highly-selective table filters that return a small subset of rows.

Comment: *

Name: *

Email: *

Verification: *

In which scenarios would a user have to pay Cloud Services costs? (Select TWO).

• A.Compute Credits = 50 Credits Cloud Services = 10
• B.Compute Credits = 80 Credits Cloud Services = 5
• C.Compute Credits = 10 Credits Cloud Services = 9
• D.Compute Credits = 120 Credits Cloud Services = 10
• E.Compute Credits = 200 Credits Cloud Services = 26

Comment: *

Name: *

Email: *

Verification: *

A large JSON file contains a single array with many 10 MB JSON objects that include NULLs. The NULLs are meaningful and do not indicate any missing values.
What file format parameters will ensure that all of the data is loaded into Snowflake?

• A.TYPE = JSON, STRIP_OUTER_ARRAY = FALSE, STRIP_NULL_VALUES = TRUE
• B.TYPE = JSON, STRIP_OUTER_ARRAY = TRUE, STRIP_NULL_VALUES = FALSE
• C.TYPE = JSON, STRIP_OUTER_ARRAY = TRUE, STRIP_NULL_VALUES = TRUE
• D.TYPE = JSON, STRIP_OUTER_ARRAY = FALSE, STRIP_NULL_VALUES = FALSE

Comment: *

Name: *

Email: *

Verification: *

Which actions can be performed using a resource monitor in Snowflake? (Select TWO).

• A.Monitor the performance of individual queries in real-time
• B.Automatically allocate more storage space to a virtual warehouse
• C.Modify the queries being executed within a virtual warehouse.
• D.Suspend a virtual warehouse when its credit usage reaches a defined limit.
• E.Trigger a notification to account administrators when credit usage reaches a specified threshold

Comment: *

Name: *

Email: *

Verification: *

What is the recommended use for the COPY INTO < location > SINGLE = TRUE command?

• A.To load data without duplications
• B.To load an individual file
• C.To copy data and parse the results into single stages
• D.To unload a single file from a table into a stage

Comment: *

Name: *

Email: *

Verification: *