Topic 1: Exam pool A
True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.
A.
True
B.
False
True
Query result cache is all about fetching the data from cloud services layer
and saving the cost by not running the virtual warehouse.
What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)
A.
Data can be filtered by an optional where clause
B.
Incoming data can be joined with other tables
C.
Columns can be reordered
D.
Columns can be omitted
E.
Row level access can be defined
Columns can be reordered
Columns can be omitted
A user unloaded a Snowflake table called mytable to an internal stage called mystage. Which command can be used to view the list of files that has been uploaded to the staged?
A.
list @mytable;
B.
list @%raytable;
C.
list @ %m.ystage;
D.
list @mystage;
list @mystage;
Which services does the Snowflake Cloud Services layer manage? (Select TWO).
A.
Compute resources
B.
Query execution
C.
Authentication
D.
Data storage
E.
Metadata
Authentication
Metadata
https://docs.snowflake.com/en/user-guide/intro-key-concepts.html
The cloud services layer is a collection of services that coordinate activities across Snowflake. These services tie together all of the different components of Snowflake in order to process user requests, from login to query dispatch. The cloud services layer also runs on compute instances provisioned by Snowflake from the cloud provider.
Services managed in this layer include:
Which of the following compute resources or features are managed by Snowflake? (Select TWO).
A.
Execute a COPY command
B.
Updating data
C.
Snowpipe
D.
AUTOMATIC__CLUSTERING
E.
Scaling up a warehouse
Execute a COPY command
AUTOMATIC__CLUSTERING
A user has 10 files in a stage containing new customer data. The ingest operation
completes with no errors, using the following command:
COPY INTO my__table FROM @my__stage;
The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files. If the user runs the same copy into command what will happen?
A.
All data from all of the files on the stage will be appended to the table
B.
Only data about new customers from the new files will be appended to the table
C.
The operation will fail with the error uncertain files in stage.
D.
All data from only the newly-added files will be appended to the table.
All data from all of the files on the stage will be appended to the table
During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?
A.
STATEMENT_TIMEOUT__IN__SECONDS
B.
STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
C.
MAX_CONCURRENCY__LEVEL
D.
QUERY_TIMEOUT_IN_SECONDS
STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
The parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS sets the limit for a query to wait in the queue in order to get its chance of running on the warehouse. The query will quit after reaching this limit. By default, the value of this parameter is 0 which mean the queries will wait indefinitely in the waiting queue.
https://community.snowflake.com/s/article/Warehouse-Concurrency-and-Statement-Timeout-Parameters#:~:text=The-parameter-STATEMENT_QUEUED_TIMEOUT_IN_SECONDS-sets-the,indefinitely-in-the-waiting-queue.
What feature can be used to reorganize a very large table on one or more columns?
A.
Micro-partitions
B.
Clustering keys
C.
Key partitions
D.
Clustered partitions
Clustering keys
Explanation: https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html
Which command is used to unload data from a Snowflake table into a file in a stage?
A.
COPY INTO
B.
GET
C.
WRITE
D.
EXTRACT INTO
COPY INTO
Explanation: https://docs.snowflake.com/en/user-guide/data-unloadsnowflake.
html#:~:text=Your-User-Stage-
,Use-the-COPY-INTO-command-to-unload-all-the,more-files-in-your-stage.
True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.
A.
True
B.
False
False
By default, COPY INTO location statements separate table data into a set of output files to take advantage of parallel operations. The maximum size for each file is set using the MAX_FILE_SIZE copy option. The default value is 16777216 (16 MB) but can be increased to accommodate larger files. The maximum file size supported is 5 GB for Amazon S3, Google Cloud Storage, or Microsoft Azure stages. To unload data to a single output file (at the potential cost of decreased performance), specify the SINGLE = true copy option in your statement. You can optionally specify a name for the file in the path.
| Page 8 out of 50 Pages |
| Previous |
Copyright © - All Rights Reserved