What internal stages are available in Snowflake? (Choose three.)

• A.Schema stage
• B.Named stage
• C.User stage
• D.Stream stage
• E.Table stage
• F.Database stage

Comment: *

Name: *

Email: *

Verification: *

What is the name of the SnowSQLfile that can store connection information?

• A.history
• B.config
• C.snowsqLcnf
• D.snowsql.pubkey

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 MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;
• C.GRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;
• D.GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;

Comment: *

Name: *

Email: *

Verification: *

What does Snowflake attempt to do if any of the compute resources for a virtual warehouse fail to provision during start-up?

• A.Repair the failed resources.
• B.Restart failed resources.
• C.Provision the failed resources
• D.Queue the failed resources

Comment: *

Name: *

Email: *

Verification: *

What is the recommended file sizing for data loading using Snowpipe?

• A.A compressed file size greater than 100 MB, and up to 250 MB
• B.A compressed file size greater than 100 GB, and up to 250 GB
• C.A compressed file size greater than 10 MB, and up to 100 MB
• D.A compressed file size greater than 1 GB, and up to 2 GB

Comment: *

Name: *

Email: *

Verification: *