SnowPro-Core Exam - SnowPro Core Certification Exam

NEW QUESTION 1

How a Snowpipe charges calculated?

• A. Per-second/per Warehouse size
• B. Per-second/per-core granularity
• C. Number of Pipes in account
• D. Total storage bucket size

Answer: B

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-load-snowpipe-billing.html

NEW QUESTION 2

What happens when an external or an internal stage is dropped? (Select TWO).

• A. When dropping an external stage, the files are not removed and only the stage is dropped
• B. When dropping an external stage, both the stage and the files within the stage are removed
• C. When dropping an internal stage, the files are deleted with the stage and the files are recoverable
• D. When dropping an internal stage, the files are deleted with the stage and the files are not recoverable
• E. When dropping an internal stage, only selected files are deleted with the stage and are not recoverable

Answer: AC

NEW QUESTION 3

What COPY INTO SQL command should be used to unload data into multiple files?

• A. SINGLE=TRUE
• B. MULTIPLE=TRUE
• C. MULTIPLE=FALSE
• D. SINGLE=FALSE

Answer: C

NEW QUESTION 4

How would a user execute a series of SQL statements using a task?

• A. Include the SQL statements in the body of the task CREATE TASK mytask .. AS INSERT INTO target1 SELECT .. FROM stream_s1 WHERE .. INSERT INTO target2 SELECT .. FROM stream_s1WHERE ..
• B. A stored procedure can have only one DML statement per stored procedure invocation and therefore the user should sequence stored procedure calls in the task definition CREATE TASK mytask .... AScall stored_proc1(); call stored_proc2();
• C. Use a stored procedure executing multiple SQL statements and invoke the stored procedure from the tas
• D. CREATE TASK mytask .... AS call stored_proc_multiple_statements_inside();
• E. Create a task for each SQL statement (e.
• F. resulting in task1, task2, etc.) and string the series of SQL statements by having a control task calling task1, task2, et
• G. sequentially.

Answer: D

NEW QUESTION 5

Which of the following statements is true of Snowflake?

• A. It was built specifically for the cloud
• B. It was built as an on-premises solution and then ported to the cloud
• C. It was designed as a hybrid database to allow customers to store data either on premises or in the cloud
• D. It was built for Hadoop architecture
• E. It's based on an Oracle Architecture

Answer: A

Explanation:
Reference: https://www.stitchdata.com/resources/snowflake/

NEW QUESTION 6

What is the recommended method for loading data into Snowflake?

• A. Load row by row
• B. Load data in batch
• C. Load data by writing it In the Snowflake Web Interface (UI)
• D. Load data via frequent, angle row DML's

Answer: B

NEW QUESTION 7

Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)

• A. Tri-Secret Secure
• B. Time Travel
• C. Fail-safe
• D. Data encryption
• E. External stages

Answer: BC

NEW QUESTION 8

To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

• A. Configure the Maximum Clusters setting to “Auto-Scale”
• B. Set the Warehouse type to “Auto”
• C. Set the Minimum Clusters and Maximum Clusters settings to the same value
• D. Set the Minimum Clusters and Maximum Clusters settings to the different values

Answer: D

Explanation:
Reference: https://help.pentaho.com/Documentation/9.1/Products/Modify_Snowflake_warehouse

NEW QUESTION 9

Which of the following is a data tokenization integration partner?

• A. Protegrity
• B. Tableau
• C. DBeaver
• D. SAP

Answer: A

NEW QUESTION 10

Which type of table corresponds to a single Snowflake session?

• A. Temporary
• B. Translent
• C. Provisional
• D. Permanent

Answer: A

Explanation:
Snowflake supports creating temporary tables
for storing non-permanent, transitory data (e.g. ETL data,
session-specific data). Temporary tables only exist within the session in which they were created and persist only for the remainder of the session.
https://docs.snowflake.com/en/user-guide/tables-temp-transient.html#:~:text=Snowflake%20supports%20creatin

NEW QUESTION 11

Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)

• A. Files
• B. External tables
• C. Secure User-Defined Functions (UDFs)
• D. Sequences
• E. Streams

Answer: BC

NEW QUESTION 12

True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.

• A. True
• B. False

Answer: A

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/ui-worksheet.html

NEW QUESTION 13

When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

• A. The Pipe load history is reset to empty
• B. The REFRESH parameter is set to TRUE
• C. Previously loaded files will be ignored
• D. All of the above

Answer: A

Explanation:
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-manage.html#load-history "When a pipe is recreated, the load history is dropped."

NEW QUESTION 14

True or False: All Snowflake table types include fail-safe storage.

• A. True
• B. False

Answer: B

NEW QUESTION 15

True or False: Once created, a micro-partition will never be changed.

• A. True
• B. False

Answer: A

Explanation:
Reference: https://interworks.com/blog/kbridges/2019/03/12/time-travel-with-snowflake/

NEW QUESTION 16

What SQL command would be used to view all roles that were granted to user.1?

• A. show grants to user USER1;
• B. show grants of user USER1;
• C. describe user USER1;
• D. show grants on user USER1;

Answer: A

NEW QUESTION 17

A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access?

• A. GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;
• B. GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;
• C. GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER1;
• D. GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;

Answer: B

NEW QUESTION 18

When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

• A. The cloned views and the stored procedures will reference the cloned tables in the cloned database.
• B. An error will occur, as views with qualified references cannot be cloned.
• C. An error will occur, as stored objects cannot be cloned.
• D. The stored procedures and views will refer to tables in the source database.

Answer: D

NEW QUESTION 19
......