Online Access Free SnowPro-Core Exam Questions

Which services does the Snowflake Cloud Services layer manage? (Choose two.)

• A.Compute resources
• B.Query execution
• C.Metadata
• D.Data storage
• E.Authentication

Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

• A.Compute layer
• B.Storage layer
• C.Cloud services layer
• D.Cloud agnostic layer

Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)

• A.Roles
• B.Stored Procedures
• C.Tables
• D.Secure Views
• E.Secure User-Defined Functions (UDFs)
• F.Schemas

What is the recommended way to change the existing file format type in my format from CSV to JSON?

• A.ALTER FILE FORMAT my_format SET TYPE=JSON;
• B.ALTER FILE FORMAT my format SWAP TYPE WITH JSON;
• C.CREATE OR REPLACE FILE FORMAT my format TYPE-JSON;
• D.REPLACE FILE FORMAT my format TYPE-JSON;

When should a stored procedure be created with caller's rights?

• A.When the caller needs to run a statement that could not execute outside of the stored procedure
• B.When the stored procedure needs to operate on objects that the caller does not have privileges on
• C.When the caller needs to be prevented from viewing the source code of the stored procedure
• D.When the stored procedure needs to run with the privileges of the role that called the stored procedure