Topic 1: Exam pool A
What tasks can be completed using the copy command? (Select TWO)
A.
Columns can be aggregatedColumns can be joined with an existing table
B.
Columns can be joined with an existing table
C.
Columns can be reordered
D.
Columns can be omitted
E.
Data can be loaded without the need to spin up a virtual warehouse
Columns can be reordered
Columns can be omitted
Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).
A.
Internal stages
B.
Incremental backups
C.
Time Travel
D.
Zero-copy clones
E.
Fail-safe
Time Travel
Fail-safe
Time travel and fail safe are the two continuous data protection features support the recovery of data automatically. Snowflake provides powerful CDP features for ensuring the maintenance and availability of your historical data (i.e. data that has been changed or deleted):
https://docs.snowflake.com/en/user-guide/data-availability.html
Which of the following commands cannot be used within a reader account?
A.
CREATE SHARE
B.
ALTER WAREHOUSE
C.
DROP ROLE
D.
SHOW SCHEMAS
E.
DESCRBE TABLE
ALTER WAREHOUSE
A reader account is intended primarily for querying data shared by the provider of the account. Adding new data to the account and/or updating shared data in the account is not supported. Changing the configuration of virtual warehouses is also not permitted as those resources are owned and managed by the provider of the account which is sharing the data.
Which semi-structured file formats are supported when unloading data from a table? (Select TWO).
A.
ORC
B.
XML
C.
Avro
D.
Parquet
E.
JSON
Parquet
JSON
Semi-structured
JSON, Parquet
https://docs.snowflake.com/en/user-guide/data-unloadprepare.html#:~:text=Supported-File-Formats,-The-following-file&text=Delimited-(CSV%2C-TSV%2C-etc.)
True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.
A.
True
B.
False
False
https://docs.snowflake.com/en/user-guide/security-access-controlconsiderations.
html
What is the purpose of an External Function?
A.
To call code that executes outside of Snowflake
B.
To run a function in another Snowflake database
C.
To share data in Snowflake with external parties
D.
To ingest data from on-premises data sources
To call code that executes outside of Snowflake
Explanation: https://docs.snowflake.com/en/sql-reference/external-functions.html
Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?
A.
Pipes
B.
Streams
C.
Tasks
D.
Procedures
Streams
https://dataterrain.com/how-to-change-tracking-using-table-streams-insnowflake/#:~:text=A-stream-is-a-Snowflake,as-metadata-about-each-change.
Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?
A.
An FTP server with TLS encryption
B.
An HTTPS server with WebDAV
C.
A Google Cloud storage bucket
D.
A Windows server file share on Azure
A Google Cloud storage bucket
True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.
A.
True
True
What happens when a virtual warehouse is resized?
A.
When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected
B.
When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.
C.
The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.
D.
Users who are trying to use the warehouse will receive an error message until the resizing is complete
When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.
Page 5 out of 50 Pages |
Previous |