Font size
WorksheetsSnowflake pro core 80 Qst part 1.2
Total questions: 45
Worksheet time: 25mins
Snowflake provides a mechanism for its customer to override its natural clustering algorithms. This method is
Micro-Partitions
Clustering Keys
Key partitions
Clustered partitions
True or False: A single database can exist in more than one Snowflake account.
True
False
Which of the following roles is recommended to be used to create and manage users and roles?
SYSADMIN
SECURITYADMIN
PUBLIC
ACCOUNTADMIN
True or False: A customer using SnowSQL/native connectors will be unable to also use the Snowflake Web Interface (UI) unless access to the UI is explicitly granted by support
True
False
Account-level storage usage can be monitored via:
The Snowflake Web Interface (UI) in the Databases section
The Snowflake Web interface (UI) in the Account->Billing & Usage section
The Information Schema -> Account_Usage_History View
The Account Usage Schema -> Account_Usage_metrics View
True or False: The COPY command must specify a File Format in order to execute
True
False
What are the three layers that make up Snowflake's architecture? (Choose three)
Compute
Tri-Secret secure
Storage
Cloud Services
Why would a customer size a Virtual Warehouse from an X-Small to a Medium?
To accommodate more queries
To accommodate more users
To accommodate Fluctuations in workload
to accommodate a more complex workload
True or False: Reader accounts incur no additional Compute cost to the data provider since they are simply reading the shared data without making changes
True
False
True or False: Snowflake charges a premium for storing semi-structured data
True
False
Which of the following statements describes a benefit of Snowflake's separation of compute and storage? (Choose all that apply)
Growth of storage and compute are tightly coupled together
Storage expands without the requirement to add more compute
Compute can scaled up or down without the requirement to add more storage
Multiple compute clusters can access stored data without contention
True or False: It is possible to unload structured data to semi-structured formats such as JSON and Parquet
True
False
In which layer of its architecture does Snowflake store its metadata statistics
Storage Layer
Compute Layer
DataBase Layer
Cloud Services Layer
True or False: Data in fail-safe can be deleted by a user or the Snowflake team before it expires.
True
False
True or False: Snowflake's data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base
True
False
Which of the following statements are true of Virtual Warehouse? (Choose all the apply)
Customers can change the size of the warehouse after creation
A Warehouse can be resized while running
A Warehouse can be configured to suspend after a period of inactivity
A warehouse can be configured to auto-resume when new queries are submitted
Which type of table corresponds to a single Snowflake session?
Temporary
Transient
Provisional
Permanent
When a Pipe is recreated using the CREATE OR REPLACE PIPE command
The Pipe load history is reset to empty
The REFRESH parameter is set to TRUE
Previously loaded files will be ignored
All of the above
What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?
Standard
Premier
Enterprise
Business Critical Edition
True or False: A third-party tool that supports standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to Snowflake
True
False
True or False: It is possible to load data into Snowflake without creating a named File Format object
True
False
True or False: A table in Snowflake can only be queried using the Virtual Warehouse that used to load the data
True
False
Which of the following statements are true of Snowflake data loading? (Choose three)
VARIANT "null" values are not the same as SQL NULL values
It is recommended to do frequent, single row DMLs
It is recommended to validate the data before loading into the Snowflake target table
It is recommended to use staging tables to manage MERGE statements
True or False: Query ID's are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issue
True
False
A deterministic query is run at 8 am, takes 5 minutes , and the results are cached. Which of the following statements are true? (Choose two)
The exact query will ALWAYS return the precomputed result set for the RESULT_CACHE_ACTIVE = time period
The same exact query will return the precomputed results if the underlying data hasn't changed and the results were last accessed within previous 24 hour period
The same exact query even if the underlying data has changed as long as the results were last accessed within the previous 24 hour period
The "24 hour" timer on the precomputed results gets renewed every time the exact query is executed
Which item in Data Warehouse migration process does not apply in Snowflake?
Migrate users
Migrate Schemas
Migrate Indexes
Build the Data Pipeline
What is the maximum compressed row size in Snowflake?
8KB
16MB
50MB
4000GB
Which of the following statements are true of Snowflake release: (Choose two)
They happen approximately weekly
They roll up and release approximately monthly, but customers can request early release application
During a release, new customer request/queries/connections transparently move over to the newer version
A customer is assigned a 30 minute window (that can be moved anytime within a week) during which the system will be unavailable and customer is upgraded
If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium warehouse?
4
16
32
128
Which is true of Snowflake network polices? A Snowflake network policy: (Choose Ttwo)
Is available to all Snowflake editions
Is only available to customers with Business Critical Edition
Restricts or enables access to specific IP addresses
Is activated using an "ALTER DATABASE" command
Query results are stored in the Result Cache for how long after they are last accessed, assuming no data change have occurred?
1 hour
3 hours
12 hours
24 hours
A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables.
The tables are now orphaned
The user that deleted the role
SYSADMIN
The assumed role that dropped the role
Which of the following connectors are available in the downloads section of the Snowflake Web Interface (UI)? (Choose two).
SnowSQL
ODBC
R
HIVE
TRUE or FALSE: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership unit is transferred to another user.
TRUE
FALSE
The Query History in the Snowflake Web Interface (UI) is kept for approximately
60 minutes
24 hours
14 days
30 days
1 year
To run a Multi-Cluster Warehouse in auto-scale mode, a user would:
Configure the Maximum Cluster setting to "Auto-Scale"
Set the Warehouse type to "Auto"
Set the Minimum Cluster and Maximum Clusters settings to the same value
Set the Minimum Clusters and Maximum Clusters settings to the different values
Fail-safe is unavailable on which table types? (Choose two)
Temporary
Transient
Provisional
Permanent
Which of the following objects is not covered by Time Travel?
Tables
Schemas
Databases
Stages
True or False: Micro-partition metadata enables some operations to be completed without requiring Computed
True
False
Which of the following commands are not blocking operations?(Choose two)
Update
Insert
Merge
Copy
Snowflake recommends, as a minimum, that all users with the following role(s) should be enrolled in Multi-Factor Authentication (MFA)
SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN
SECURITYADMIN, ACCOUNTADMIN, SYSADMIN
SECURITYADMIN, ACCOUNTADMIN
ACCOUNTADMIN
True or False: Users are able to see the result sets of queries executed by other users that share their same role
True
False
True or False: The user has to specify which cluster a query will run on in a multi-cluster warehouse
True
False
True or False: Pipes can be suspended and resumed
True
False
Which of the following languages can be used to implement Snowflake User Defined Function (UDFs)? (Choose two)
Java
Javascript
SQL
Python
