SnowPro-Core Snowflake Exam Questions and Free Practice Test

Question 61

- (Exam Topic 1)
True or False: Snowflake charges a premium for storing semi-structured data.

A. True

B. False

Correct Answer:B
Reference:
https://snowflakecommunity.force.com/s/question/0D50Z00008ckwNuSAI/does-snowflakecharges- premium-for-storing-semi-structured-data

Question 62

- (Exam Topic 3)
When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?

A. 10-50 MB

B. 100-250 MB

C. 300-500 MB

D. 1000-1500 MB

Correct Answer:B

Question 63

- (Exam Topic 2)
Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)

A. SCIM

B. Federated authentication

C. TLS 1.2

D. Key-pair authentication

E. OAuth

F. OCSP authentication

Correct Answer:BDE

Question 64

- (Exam Topic 1)
Which of the following statements would be used to export/unload data from Snowflake?

A. COPY INTO @stage

B. EXPORT TO @stage

C. INSERT INTO @stage

D. EXPORT_TO_STAGE(stage = > @Wage, select = > 'select * from t1);

Correct Answer:A
Reference: https://docs.snowflake.com/en/user-guide/data-unload-considerations.html

Question 65

- (Exam Topic 3)
How does Snowflake Fail-safe protect data in a permanent table?

A. Fail-safe makes data available up to 1 day, recoverable by user operations.

B. Fail-safe makes data available for 7 days, recoverable by user operations.

C. Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.

D. Fail-safe makes data available up to 1 day, recoverable only by Snowflake Support.

Correct Answer:C

Question 66

- (Exam Topic 1)
Which of the following statements about data sharing are true? choose 2 answers

A. New objects created by a Data Provider are automatically shared with existing Data Consumers & Reader Accounts

B. All database objects can be included In a shared database

C. Reader Accounts are created and funded by Data Prowlers

D. Shared databases are read-only

Correct Answer:CD

START SnowPro-Core EXAM