SnowPro Core Certification Exam (SnowPro-Core) Free Practice Test

Question 1

Which command should be used to unload all the rows from a table into one or more files in a named stage?

A. PUT

B. INSERT INTO

C. COPY INTO

D. GET

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 2

Who can grant object privileges in a regular schema?

A. Database owner

B. SYSADMIN

C. Schema owner

D. Object owner

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 3

What does Snowflake recommend regarding database object ownership? (Select TWO).

A. Use only MANAGED ACCESS SCHEMAS for66 objects owned by ACCOUNTADMIN.

B. Create objects with a custom role and grant this role to SYSADMIN.

C. Create objects with ACCOUNTADMIN and do not reassign ownership.

D. Create objects with SYSADMIN.

E. Create objects with SECURITYADMIN to ease granting of privileges later.

Correct Answer: B,D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 4

How can a Snowflake administrator determine which user has accessed a database object that contains sensitive information?

A. Review the granted privileges to the database object.

B. Query the REPLICATION USAGE HISTORY view in the ORGANIZATION USAGE schema.

C. Query the ACCESS_HlSTORY view in the ACCOUNT_USAGE schema.

D. Review the row access policy for the database object.

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 5

What is a feature of column-level security in Snowflake?

A. Network policies

B. External tokenization

C. Role access policies

D. Internal tokenization

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 6

A Snowflake user is writing a User-Defined Function (UDF) that includes some unqualified object names.
How will those object names be resolved during execution?

A. Snowflake will first check the current schema, and them the PUBLIC schema of the current database.

B. Snowflake will first check the current schema, and then the schema the previous query used

C. Snowflake will resolve them according to the SEARCH_PATH parameter.

D. Snowflake will only check the schema the UDF belongs to.

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 7

What is the purpose of the STRIP NULL_VALUES file format option when loading semi-structured data files into Snowflake?

A. It converts null values to empty strings during loading.

B. It removes null values from all columns in the data.

C. It removes object or array elements containing null values.

D. It skips rows with null values during the loading process.

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 8

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

A. Cloud services layer

B. Cloud agnostic layer

C. Compute layer

D. Storage layer

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 9

What activities can a user with the ORGADMIN role perform? (Select TWO).

A. Create an account for an organization.

B. Edit the account data for an organization.

C. Delete the account data for an organization.

D. Select all the data in tables for all accounts in an organization.

E. View usage information for all accounts in an organization.

Correct Answer: A,E

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 10

When should a multi-cluster virtual warehouse be used in Snowflake?

A. When there is significant disk spilling shown on the Query Profile

B. When dynamic vertical scaling is being used in the warehouse

C. When queuing is delaying query execution on the warehouse

D. When there are no concurrent queries running on the warehouse

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 11

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

A. Provision the failed resources

B. Queue the failed resources

C. Restart failed resources.

D. Repair the failed resources.

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 12

How many network policies can be assigned to an account or specific user at a time?

A. One

B. Unlimited

C. Two

D. Three

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 13

What will prevent unauthorized access to a Snowflake account from an unknown source?

A. Role-Based Access Control (RBAC)

B. Multi-Factor Authentication (MFA)

C. Network policy

D. End-to-end encryption

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Welcome to TestSimulate

Snowflake SnowPro Core Certification (SnowPro-Core) Free Practice Test