Font size
WorksheetsKnowledge Check 4 (Final)
Total questions: 15
Worksheet time: 23mins
What all options are available for data transformation while loading data into a table using the COPY command? (Select all that apply)
Truncation of Text Strings
Column omission
Casts
Join
Column reordering
What is the expiration period of a File URL?
Length of time specified in the expiration_time argument
The URL expires when the persisted query result period ends
It is Permanent
Which data does not fit into a predefined data model or schema?
All of these
Semi-Structured Data
Structured-data
Unstructured Data
How can we turn off the query result cache?
Setting the parameter USE_CACHED_RESULT to FALSE
Setting the parameter USE_CACHED_INFO to FALSE
Setting the parameter USE_QUERY_CACHED to FALSE
Query result cache can be turned off.
How long do results remain in the Query results cache?
16 hours
31 hours
1 hour
12 hours
24 hours
Micro-partitioning is the on-demand feature of Snowflake. It is required to be enabled explicitly by ACCOUNTADMIN. (True / False)
True
False
Which services are managed by Snowflake's cloud services layer? (Select all that apply)
Infrastructure Management
Access Control
Metadata Management
Authentication
Query Parsing and Optimization
Which of these types of VIEW does Snowflake support? (Select 3)
SECURE VIEW
TEMPORARY VIEW
STANDARD VIEW
MATERIALIZED VIEW
PERMANENT VIEW
Which of these Snowflake features does enable accessing historical data (i.e., data that has been changed or deleted) at any point within a defined period?
Zero Copy Cloning
Search Optimization Service
Data Sharing
Time Travel
Which object parameter can users with the ACCOUNTADMIN role use to set the default retention period for their account?
DATA_RETENTION_TIME_IN_DAYS
DATA_RETENTION_IN_TIME_TRAVEL
DATA_RETENTION_TIME_MAX
DATA_RETENTION_TIME_IN_HOURS
John has to create a PIPE that will be triggered for loading by calling the Snowpipe REST endpoints. What parameter does he need to specify in CREATE PIPE statement?
AUTO_INGEST = FALSE
API_INGEST = FALSE
AUTO_INGEST = TRUE
API_INGEST = TRUE
Which copy option is used to delete the file from the Snowflake stage when data from staged files are loaded successfully?
DELETE = TRUE
PURGE = TRUE
DEL = TRUE
REMOVE = TRUE
What size limit does VARIANT data type impose on individual rows?
16 GB
16 MB
10 GB
10 MB
100 MB
The best use of Snowpipe is to load large volumes of data and incrementally make them available for analysis. (True/False)
True
False
There are multiple ways you can trigger the loading of files from the stage into Snowpipe. Select two ways generally used to trigger the loading with Snowpipe.
Automating Snowpipe using cloud messaging (notification)
Calling Snowpipe SOAP endpoints
Calling Snowpipe REST endpoints
By executing START PIPE <pipe_name>
