Font size
WorksheetsSnow Test Question 60 6.0
Total questions: 60
Worksheet time: 34mins
According to snowflake architecture, data storage is independent of compute
TRUE
FALSE
All virtual warehouses in snowflake has access to all data
TRUE
FALSE
Which layer in the snowflake architecture contains virtual warehouse
Cloud services
Query processing
Database Storage
None
Which layer in snowflake contains data in compressed, columnar format
Cloud services
Query processing
Database storage
None
Which of the below approach would result in a better performance through linear scaling of data ingestion workload
Resize virtual warehouse
Consider the practice of organizing data by granular path
Consider the practice of splitting input file batch within the recommended range of 10 MB and 100 MB
All of the above
Snowflake provides specific administration features and capabilities to support the following activities except?
Manage databases and warehouses within snowflake account
Manage roles and users within a snowflake account
Monitor usage and manage resources to control costs in a snowflake account
Manage 3rd party applications providing data to a snowflake account
Select all characteristics of snowflake's multi-cluster environment
Multiple virtual warehouses in a deployment
Individual warehouses scale out/in based on query activity
Multi-cluster warehouses support the same properties and actions as single-cluster warehouse
User must specify which cluster each query will use
What are the two modes in which a multi-cluster warehouse can run?
Static
Dynamic
Maximized
Auto-scale
None of the above
What does snowflake offer to help control the credits consumed by a multi-cluster warehouse running in Auto-scale mode?
Auto scale
Scaling policy
Maximum_number_of_server_clusters
Minimum_number_of_server_clusters
None of the above
What scaling policies are supported by snowflake?
Standard
Economy
Premium
You are sizing a snowflake warehouse, what factors would you consider?Number of users
Number of users
Number of concurrent queries
Number of tables being queried
Data size and composition
Compute usage billing in snowflake is based on
Per-second basis, with a minimum of 60 seconds
Per-second basis only
By number of users
SQL functionality in snowflake can be extended by
USER DEFINED FUNCTIONS USING SQL
USER DEFINED FUNCTIONS USING JAVASCRIPT
SESSION VARIABLES
NONE OF THE ABOVE
To provide failover protection, how many availability zones does snowflake replicate to
one
two
three
as configured by user
Which of the following is not a characteristic of micro-partitions in snowflake?
New partitions are created in logical properties
Avoids skews between partitions
Partitioning is automatically completed on the natural ingestion order of the data
The natural ingestion order maintains correlations between columns which could be useful for pruning
The storage architecture of snowflake has two key features, they are
Time travel
Replication
Zero-copy cloning
Query tag
Which is not a characteristic of time travel?
Protection from accidental data operations
Previous versions of data automatically retained
Retention period selected by customers (up to 90 days for Enterprise edition)
Recover data with the cost of running backups
The commands to load data into snowflake are
COPY AND PUT
COPY AND INSERT
INSERT AND PUT
NONE OF THE ABOVE
In order to load data into snowflake, which of the below are required?
Virtual Warehouse
Predefined target table
Staging location with data staged
File format
Which of the following is not a snowpipe feature?
Snowpipe can load data from any internal or external stage
It is a server-less compute model
The service provides REST end points and uses snowflake provided compute resources to load the data and retrieve history reports
Snowpipe loads data after it is in stage and use executes the LOADDATA command
Which feature does not come with query profile?
Graphical representation of the main components of the processing plan of the query
Details and statistics for the overall query
Hints for improving the query performance
Statistics for each component of the query
Snowflake mechanism to limit the number of micro-partitions scanned by a query is called what?
Pruning
Selection
Filtering
None of the above
Which type of data integration tools leverage snowflake's scalable compute for data transformation?
ELT
ETL
Database replication
Streaming
Snowflake offers tools to extract data from source systems
TRUE
FALSE
Which of the following are options when creating a virtual warehouse
Auto Suspend
Auto Resume
Storage Size
Server count
The warehouse cache may be reset if a running warehouse is suspended and then resumes
TRUE
FALSE
A table in snowflake can only be queried using the virtual warehouse used to load the data
TRUE
FALSE
Snowflake caches are automatically invalidated if the underlying data changes
TRUE
FALSE
The query profiler view is only available for completed queries
TRUE
FALSE
Which best describes zero-copy cloning?
Metadata only operation
No replication of data
Unmodified data stored once and modified data stored as new micro partitions
All of the above
Your business team runs a set of identical queries every day after the batch ETL run is complete. From the following actions, what is the best action that you will recommend.
After the ETL run, execute the identical queries so that they remain in the result cache
After the ETL run, resize the warehouse to a larger warehouse
After the ETL run, copy the tables to another schema for the business users to query
If you would like to disable the query cache, what will you do?
ALTER SESSION SET USE_CACHED_RESULT = FALSE;
ALTER SESSION SET USE_CACHED_RESULT = OFF;
ALTER SESSION SET USE_QUER_CACHE = TRUE;
A task can have a maximum of 100 child tasks
TRUE
FALSE
Snowflake guarantees that only one instance of a task with a defined predecessor task is running at a given time
TRUE
FALSE
You created an warehouse(ETL_WH) which is sized at XSMALL, you want to resize the Warehouse to SMALL. How will you do that?
alter warehouse etl_wh set warehouse_size=SMALL;
You will need to recreate the warehouse with the new size
Once created an warehouse can never be re-sized
You have just loaded a file named student_data.csv from your snowflake stage to snowflake table. You try to reload again using the COPY INTO command. You will be able to load the file
TRUE
FALSE
For a particular snowflake session, you can specify more than one virtual warehouse
TRUE
FALSE
Time travel and fail safe requires additional storage which will cost you storage cost
TRUE
FALSE
From which of the following stage locations can snowflake load data
AWS S3
AZURE BLOB STORAGE
GOOGLE CLOUD STORAGE
INTERNAL STAGE
*FILE SERVER/IBM CLOUD STORAGE
ACCOUNTADMIN ROLE encapsulates the SYSADMIN and SECURITYADMIN systemdefined roles and ACCOUNTADMIN sits on top of the role hierarchy
TRUE
FALSE
Select the two true statements about multi cluster warehouse
These type of warehouses cannot be resumed or suspended
Multi cluster warehouses can be created on snowflake hosted on AWS only
As query demand decreases, clusters are removed from this warehouse
When query workload increases, clusters are automatically added
If you want to clone a table, your role must have which access on the Table
SELECT
USAGE
READ
CLONE
You have three worksheets open in Snowflake Web UI. You can have three different roles in these worksheets
TRUE
FALSE
When will you consider creating a clustering key on a table. Please select all that applies
The table houses multi-terabyte data
The table has variant columns
The query performance on the table has degraded over time
Which of the below objects will contribute to your account level storage usage?
Secure Views
Internal Stage
External stage
Database and all tables inside it
Functions
A consumer of shared database can add as many tables and views they want in the shared database
FALSE
TRUE
To have multi cluster data virtual warehouse, what should be the minimum snowflake subscription
ENTERPRISE
BUSINESS CRITICAL
STANDARD
Once a new release has been deployed, Snowflake does not move all accounts to the release at the same time. It follows a staged release approach.
TRUE
FALSE
When you are loading data through the COPY command, the table and the file being loaded must have the same order of columns
FALSE
TRUE
A reader account user will not be able to do the following
LOAD DATA
INSERT
SELECT
UPDATE
Which two modes are available in Multi cluster warehouse
Auto-scale
Peak Scale
Flexible
Maximized
Which of the below operations are allowed on an inbound share data?
*MERGE/*CREATE TABLE
ALTER TABLE
SELECT WITH GROUP BY
SELECT WITH JOIN
INSERT INTO
Select the most accurate statement regarding Snowflake's transaction support
ACID Compliant
Requires special user configuration
BASE compliant
Works like a NoSQL database
Select the table type that is automatically deleted after the session is closed and hence it has no fail-safe or time travel option post closure of the session
TRANSIENT
TEMPORARY
PERMANENT
EXTERNAL
What does snowflake recommend for making a variant column accessible in a BI Tool?
Create a View
Create a separate table
Use Parse_Json
Convert into external table
When you load data into snowflake, snowflake reorganizes the data into its internal optimized compressed columnar format
TRUE
FALSE
When you clone a table, it does not include the load history of the source table, and hence the data files that were already loaded in source table can be reloaded in the clone table
TRUE
FALSE
A snowflake account hosted on AWS cannot load data from a file that is staged in GCP or Azure
FALSE
TRUE
If you clone a database, the internal snowflake stages in that database are also cloned
FALSE
TRUE
Which command is used to download data from Snowflake stage
PUT
GET
COPY
DUMP
