The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)

• A.Users
• B.Tables
• C.Databases
• D.Internal Stages

Comment: *

Name: *

Email: *

Verification: *

What is the MOST performant file format for loading data in Snowflake?

• A.CSV (Unzipped)
• B.Parquet
• C.CSV (Gzipped)
• D.ORC

Comment: *

Name: *

Email: *

Verification: *

A user needs to load Snowflake files from a stage that contains data from the past 5 years while using the least amount of operational overhead. The file names follow a specific format, such as files ending in _01.gz.
Which command should be used to load the data from 2024?

• A.Use the COPY INTO command to individually load the needed files.
• B.Use the COPY INTO command using the PATTERN parameter to define the needed files.
• C.Use the REMOVE command to eliminate unwanted files, then use the COPY INTO command.
• D.Use the GET command to download the needed files, then create a new stage and load the files onto the stage using the COPY INTO command.

Comment: *

Name: *

Email: *

Verification: *

Which activities are managed by Slowflake's Cloud Services layer? (Select TWO).

• A.Authorisation
• B.Access delegation
• C.Data pruning
• D.Data compression
• E.Query parsing and optimization

Comment: *

Name: *

Email: *

Verification: *

While unloading data into a stage, how can the user ensure that the output will be a single file?

• A.Use the copy option files=single.
• B.Use the COPY Option SINGLE=TRUE .
• C.Use the get option SINGLE-TRUE.
• D.Use the GET option FILES-SINGLE.

Comment: *

Name: *

Email: *

Verification: *