Free SnowPro-Core Exam Dumps

Question 16

- (Exam Topic 2)
True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.

A. True
B. False

Correct Answer:A
You can experiment the same with snowflake UI.

Question 17

- (Exam Topic 3)
Which of the following statements describes a schema in Snowflake?

A. A logical grouping of objects that belongs to a single database
B. A logical grouping of objects that belongs to multiple databases
C. A named Snowflake object that includes all the information required to share a database
D. A uniquely identified Snowflake account within a business entity

Correct Answer:A

Question 18

- (Exam Topic 1)
Which of the following items does the Cloud services Layer manage? Choose 4 answers

A. user authentication
B. Metadata
C. Query compilation and optimization
D. external blob storage
E. Data security

Correct Answer:ABCE

Question 19

- (Exam Topic 3)
Which of the following significantly improves the performance of selective point lookup queries on a table?

A. Clustering
B. Materialized Views
C. Zero-copy Cloning
D. Search Optimization Service

Correct Answer:A

Question 20

- (Exam Topic 2)
A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors, using the following command:
COPY INTO my__table FROM @my__stage;
The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files.
If the user runs the same copy into command what will happen?

A. All data from all of the files on the stage will be appended to the table
B. Only data about new customers from the new files will be appended to the table
C. The operation will fail with the error uncertain files in stage.
D. All data from only the newly-added files will be appended to the table.

Correct Answer:A