What command is used to load files into an Internal Stage within Snowflake? Select one.

• A.PUT
• B.COPY INTO
• C.TRANSFER
• D.INSERT

Comment: *

Name: *

Email: *

Verification: *

A sales table FCT_SALES has 100 million records.
The following Query was executed
SELECT COUNT (1) FROM FCT__SALES;
How did Snowflake fulfill this query?

• A.Query against the result set cache
• B.Query against a virtual warehouse cache
• C.Query against the most-recently created micro-partition
• D.Query against the metadata excite

Comment: *

Name: *

Email: *

Verification: *

Which of the following is the Snowflake Account_Usage.Metering_History view used for?

• A.Gathering the hourly credit usage for an account
• B.Compiling an account's average cloud services cost over the previous month
• C.Summarizing the throughput of Snowpipe costs for an account
• D.Calculating the funds left on an account's contract

Comment: *

Name: *

Email: *

Verification: *

A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH.
Which of the following statements will accommodate this request?

• A.ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;
• B.GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;
• C.GRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;
• D.GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;

Comment: *

Name: *

Email: *

Verification: *

At what levels can a resource monitor be configured? (Select TWO).

• A.Account
• B.Database
• C.Organization
• D.Schema
• E.Virtual warehouse

Comment: *

Name: *

Email: *

Verification: *