Topic 1: Exam pool A
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.
When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).
A.
Use multi-clustered warehousing to scale out warehouse capacity
B.
Scale up the warehouse size to allow Queries to execute faster
C.
Stop and start the warehouse to clear the queued queries
D.
Migrate some queries to a new warehouse to reduce load
E.
Limit user access to the warehouse so fewer queries are run against it.
Use multi-clustered warehousing to scale out warehouse capacity
Migrate some queries to a new warehouse to reduce load
Which of the following Snowflake objects can be shared using a secure share? (Select TWO).
A.
Materialized views
B.
Sequences
C.
Procedures
D.
Tables
E.
Secure User Defined Functions (UDFs)
Tables
Secure User Defined Functions (UDFs)
Secure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts. The following Snowflake database objects can be shared:
Which of the following can be executed/called with Snowpipe?
A.
A User Defined Function (UDF)
B.
A stored procedure
C.
A single copy_into statement
D.
A single insert__into statement
A single copy_into statement
Which data type can be used to store geospatial data in Snowflake?
A.
Variant
B.
Object
C.
Geometry
D.
Geography
Geography
| Page 7 out of 42 Pages |
| Previous |