Question 1

True or False: Data Providers can share data with only the Data Consumer.

Options :

A : True

B : False

Answer: B

Question 2

The first user assigned to a new account, ACCOUNTADMIN, should create at least one additional user with

which administrative privilege?

Options :

A : USERADMIN

B : PUBLIC

C : ORGADMIN

D : SYSADMIN

Answer: D

Question 3

What affects whether the query results cache can be used?

Options :

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

Answer: B

Question 4

What happens to historical data when the retention period for an object ends?

Options :

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.

Answer: D

Question 5

During periods of warehouse contention which parameter controls the maximum length of time a warehouse

will hold a query for processing?

Options :

A : STATEMENT_TIMEOUT__IN__SECONDS

B : STATEMENT_QUEUED_TIMEOUT_IN_SECONDS

C : MAX_CONCURRENCY__LEVEL

D : QUERY_TIMEOUT_IN_SECONDS

Answer: B