Practice Free SnowPro Core Exam Online Questions
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_s1 WHERE ..
- 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 …. AS
call stored_proc1(); call stored_proc2(); - C . Use a stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask …. AS call stored_proc_multiple_statements_inside();
- D . Create a task for each SQL statement (e.g. resulting in task1, task2, etc.) and string the series of SQL statements by having a control task calling task1, task2, etc. sequentially.
Which of the following statements apply to Snowflake in terms of security? (Choose two.)
- A . Snowflake leverages a Role-Based Access Control (RBAC) model.
- B . Snowflake requires a user to configure an IAM user to connect to the database.
- C . All data in Snowflake is encrypted.
- D . Snowflake can run within a user’s own Virtual Private Cloud (VPC).
- E . All data in Snowflake is compressed.
Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?
- A . STRIP_NULL_VALUES
- B . SKIP_BYTE_ORDER_MARK
- C . REPLACE_INVALID_CHARACTERS
- D . VALIDATION_MODE
A Snowflake user has two tables that contain numeric values and is trying to find out which values are present in both tables.
Which set operator should be used?
- A . INTERSECT
- B . MFRCK
- C . MINUS
- D . UNION
A materialized view should be created when which of the following occurs? (Choose two.)
- A . There is minimal cost associated with running the query.
- B . The query consumes many compute resources every time it runs.
- C . The base table gets updated frequently.
- D . The query is highly optimized and does not consume many compute resources.
- E . The results of the query do not change often and are used frequently.
Assume there is a table consisting of five micro-partitions with values ranging from A to Z.
Which diagram indicates a well-clustered table?
A)
B)
C)
D)
- A . Option A
- B . Option B
- C . Option C
- D . Option D
In which Snowflake layer does Snowflake reorganize data into its internal optimized, compressed, columnar format?
- A . Cloud Services
- B . Database Storage
- C . Query Processing
- D . Metadata Management
How do Snowflake data providers share data that resides in different databases?
- A . External tables
- B . Secure views
- C . Materialized views
- D . User-Defined Functions (UDFs)
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.
Which data type can store more than one type of data structure?
- A . JSON
- B . BINARY
- C . VARCHAR
- D . VARIANT