Topic 2: Exam pool B
How many days is load history for Snowpipe retained?
A.
1 day
B.
7 days
C.
14 days
D.
64 days
14 days
What impacts the credit consumption of maintaining a materialized view? (Choose two.)
A.
Whether or not it is also a secure view
B.
How often the underlying base table is queried
C.
How often the base table changes
D.
Whether the materialized view has a cluster key defined
E.
How often the materialized view is queried
Whether the materialized view has a cluster key defined
How often the materialized view is queried
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.
Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.
What are common issues found by using the Query Profile? (Choose two.)
A.
Identifying queries that will likely run very slowly before executing them
B.
Locating queries that consume a high amount of credits
C.
Identifying logical issues with the queries
D.
Identifying inefficient micro-partition pruning
E.
Data spilling to a local or remote disk
Identifying queries that will likely run very slowly before executing them
Identifying inefficient micro-partition pruning
Which services does the Snowflake Cloud Services layer manage? (Choose two.)
A.
Compute resources
B.
Query execution
C.
Authentication
D.
Data storage
E.
Metadata
Authentication
Metadata
In a Snowflake role hierarchy, what is the top-level role?
A.
SYSADMIN
B.
ORGADMIN
C.
ACCOUNTADMIN
D.
SECURITYADMIN
ORGADMIN
Which of the following statements describe features of Snowflake data caching? (Choose two.)
A.
When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.
B.
When the data cache is full, the least-recently used data will be cleared to make room.
C.
A user can only access their own queries from the query result cache.
D.
A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in
queries.
E.
The RESULT_SCAN table function can access and filter the contents of the query result cache.
When the data cache is full, the least-recently used data will be cleared to make room.
A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in
queries.
Which of the following objects are contained within a schema? (Choose two.)
A.
Role
B.
Stream
C.
Warehouse
D.
External table
E.
User
F.
Share
Warehouse
External table
Which statement is true about running tasks in Snowflake?
A.
A task can be called using a CALL statement to run a set of predefined SQL commands.
B.
A task allows a user to execute a single SQL statement/command using a predefined schedule.
C.
A task allows a user to execute a set of SQL commands on a predefined schedule.
D.
A task can be executed using a SELECT statement to run a predefined SQL command.
A task allows a user to execute a set of SQL commands on a predefined schedule.
Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)
A.
Data is live, ready-to-query, and can be personalized.
B.
Data needs to be loaded into a cloud provider as a consumer account.
C.
Data is not available for copying or moving to an individual Snowflake account.
D.
Data is available without copying or moving.
E.
Data transformations are required when combining Data Marketplace datasets with existing data in Snowflake.
Data is live, ready-to-query, and can be personalized.
Data is available without copying or moving.
| Page 12 out of 50 Pages |
| Previous |
Copyright © - All Rights Reserved