Which of the following compute resources or features are managed by Snowflake? (Select TWO).

• A.Updating data
• B.Snowpipe
• C.Scaling up a warehouse
• D.Execute a COPY command
• E.AUTOMATIC__CLUSTERING

Comment: *

Name: *

Email: *

Verification: *

Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)

• A.Management of metadata
• B.Computing the data
• C.Maintaining Availability Zones
• D.Infrastructure security
• E.Parsing and optimizing queries

Comment: *

Name: *

Email: *

Verification: *

Which role in Snowflake allows a user to enable replication for multiple accounts?

• A.SECURITYADMIN
• B.ORGADMIN
• C.SYSADMIN
• D.ACCOUNTADMIN

Comment: *

Name: *

Email: *

Verification: *

What file formats does Snowflake support for loading semi-structured data? (Choose three.)

• A.TSV
• B.JSON
• C.PDF
• D.Avro
• E.Parquet
• F.JPEG

Comment: *

Name: *

Email: *

Verification: *

How can a 5 GB table be downloaded into a single file MOST efficiently?

• A.Keep the default MAX_FILE_SIZE to 16 MB
• B.Set the default MAX_FILE_SI2E to 5 GB.
• C.Set the SINGLE parameter to TRUE.
• D.Use a regular expression in the stage specifications of the COPY command.

Comment: *

Name: *

Email: *

Verification: *