What are supported file formats for unloading data from Snowflake? (Choose three.)

• A.XML
• B.JSON
• C.Parquet
• D.ORC
• E.AVRO
• F.CSV

Comment: *

Name: *

Email: *

Verification: *

Which copy INTO command outputs the data into one file?

• A.SINGLE=TRUE
• B.MAX_FILE_NUMBER=1
• C.FILE_NUMBER=1
• D.MULTIPLE=FAISE

Comment: *

Name: *

Email: *

Verification: *

Assume there is a table consisting of five micro-partitions with values ranging from A to Z.
Which diagram indicates a well-clustered table?

• A.
• B.
• C.
• D.

Comment: *

Name: *

Email: *

Verification: *

How many credits does a size 3X-Large virtual warehouse consume if it runs continuously for 2 hours?

• A.32
• B.64
• C.128
• D.256

Comment: *

Name: *

Email: *

Verification: *

How does the search optimization service help Snowflake users improve query performance?

• A.It scans the micro-partitions based on the joins used in the queries and scans only join columns.
• B.II maintains a persistent data structure that keeps track of the values of the table's columns m each of its micro-partitions.
• C.It scans the local disk cache to avoid scans on the tables used in the Query.
• D.It keeps track of running queries and their results and saves those extra scans on the table.

Comment: *

Name: *

Email: *

Verification: *