Topic 1: Exam pool A
Which command can be used to stage local files from which Snowflake interface?
A.
SnowSQL
B.
Snowflake classic web interface (Ul)
C.
Snowsight
D.
.NET driver
SnowSQL
Explanation: https://docs.snowflake.com/en/user-guide/snowsql-use.html
What SQL command would be used to view all roles that were granted to user.1?
A.
show grants to user USER1;
B.
show grants of user USER1;
C.
describe user USER1;
D.
show grants on user USER1;
show grants to user USER1;
How often are encryption keys automatically rotated by Snowflake?
A.
30 Days
B.
60 Days
C.
90 Days
D.
365 Days
30 Days
All Snowflake-managed keys are automatically rotated by Snowflake when they are more than 30 days old. Active keys are retired, and new keys are created. When Snowflake determines the retired key is no longer needed, the key is automatically destroyed.
https://docs.snowflake.com/en/user-guide/security-encryptionmanage.
html#:~:text=All-Snowflake%2Dmanaged-keys-are,the-key-is%
20automatically-destroyed.
A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option What does the STRIP_OUTER_ARRAY file format do?
A.
It removes the last element of the outer array.
B.
It removes the outer array structure and loads the records into separate table rows,
C.
It removes the trailing spaces in the last element of the outer array and loads the
records into separate table columns
D.
It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records
It removes the outer array structure and loads the records into separate table rows,
Data Size Limitations
The VARIANT data type imposes a 16 MB size limit on individual rows. For some semi-structured data formats (e.g. JSON), data sets are frequently a simple concatenation of multiple documents. The JSON output from some software is composed of a single huge array containing multiple records. There is no need to separate the documents with line breaks or commas, though both are supported. If the data exceeds 16 MB, enable the STRIP_OUTER_ARRAY file format option for the COPY INTO <table> command to remove the outer array structure and load the records into separate table rows:
copy into <table>
from @~/<file>.json
file_format = (type = 'JSON' strip_outer_array = true);
https://docs.snowflake.com/en/user-guide/semistructured-considerations.html
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
| Page 4 out of 42 Pages |
| Previous |