Topic 2: Exam pool B
The is the minimum Fail-safe retention time period for transient tables?
A.
1 day
B.
7 days
C.
12 hours
D.
0 days
0 days
Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?
A.
parse_json()
B.
json_extract_path_text()
C.
object_construct()
D.
flatten
json_extract_path_text()
What affects whether the query results cache can be used?
A.
If the query contains a deterministic function
B.
If the virtual warehouse has been suspended
C.
If the referenced data in the table has changed
D.
If multiple users are using the same virtual warehouse
If the virtual warehouse has been suspended
Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?
A.
SHOW GRANTS OF ROLE MY_ROLE
B.
SHOW GRANTS TO ROLE MY_ROLE
C.
SHOW GRANTS FOR ROLE MY_ROLE
D.
SHOW GRANTS ON ROLE MY_ROLE
SHOW GRANTS TO ROLE MY_ROLE
What happens to historical data when the retention period for an object ends?
A.
The data is cloned into a historical object.
B.
The data moves to Fail-safe
C.
Time Travel on the historical data is dropped.
D.
The object containing the historical data is dropped.
The object containing the historical data is dropped.
The following JSON is stored in a VARIANT column called src of the CAR_SALES table:
A user needs to extract the dealership information from the JSON. How can this be accomplished?
A.
select src:dealership from car_sales;
B.
select src.dealership from car_sales;
C.
select src:Dealership from car_sales;
D.
select dealership from car_sales;
select src:dealership from car_sales;
What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?
A.
30 days
B.
7 days
C.
48 hours
D.
24 hours
24 hours
Which of the following accurately describes shares?
A.
Tables, secure views, and secure UDFs can be shared
B.
Shares can be shared
C.
Data consumers can clone a new table from a share
D.
Access to a share cannot be revoked once granted
Tables, secure views, and secure UDFs can be shared
When cloning a database, what is cloned with the database? (Choose two.)
A.
Privileges on the database
B.
Existing child objects within the database
C.
Future child objects within the database
D.
Privileges on the schemas within the database
E.
Only schemas and tables within the database
Existing child objects within the database
Only schemas and tables within the database
Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?
A.
Optimizes the virtual warehouse size and multi-cluster setting to economy mode
B.
Allows a user to import the files in a sequential order
C.
Increases the latency staging and accuracy when loading the data
D.
Allows optimization of parallel operations
Allows optimization of parallel operations
What is the MAXIMUM size limit for a record of a VARIANT data type?
A.
8MB
B.
16MB
C.
32MB
D.
128MB
16MB
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.
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.
| Page 17 out of 42 Pages |
| Previous |