The maintenance & tuning and upgrade of Snowflake is performed by the Snowflake (company) without requiring any action from the customers
Options are :
Answer :True
Micro partitions are small in size and (before compression) are generally of size ?
Options are :
- 500MB-1GB
- 50-500 MB
(Correct)
- 10-50MB
Answer :50-500 MB
Snowflake UDFs can be written in which of the following languages?
Options are :
- PYTHON
- JAVASCRIPT
(Correct)
- JAVA
- SQL
(Correct)
Answer :JAVASCRIPT
SQL
When a database or a schema is cloned, which of the following statements are true for the snowpipes in that database?
Options are :
- Any Snowpipes that reference an external stage are NOT cloned
- Any Snowpipes that reference an internal stage are NOT cloned
(Correct)
- Any Snowpipes that reference an external stage are cloned
(Correct)
- Any Snowpipes that reference an internal stage are cloned
Answer :Any Snowpipes that reference an internal stage are NOT cloned
Any Snowpipes that reference an external stage are cloned
By warehouse size we mean the number of servers in each cluster.
Options are :
Answer :TRUE
What is the maximum failsafe retention period for transient & temporary tables?
Options are :
Answer :0
What is a virtual warehouse is Snowflake?
Options are :
- Virtual warehouse is a concept through which two or more physical tables are joined together.
- Virtual warehouse is a name given to reporting views
- Virtual warehouse is the name given to the compute cluster(s) that are used by Snowflake to execute queries
(Correct)
Answer :Virtual warehouse is the name given to the compute cluster(s) that are used by Snowflake to execute queries
A virtual warehouse starts consuming credits once all the servers in the virtual warehouse are provisioned?
Options are :
Answer :TRUE
It is mandatory to define a clustering key for permanent tables in Snowflake?
Options are :
Answer :False
In order to share data as a producer and consume data as a consumer you must have two separate Snowflake accounts, one for sharing data and one for consuming shared data.
Options are :
Answer :FALSE
Which of the following scaling type would result in Snowflake preserving credits over performance?
Options are :
- ECONOMY
(Correct)
- COST
- STANDARD
- PERFORMANCE
Answer :ECONOMY
In VARIANT column the NULL values are stored as a literal string "null"
Options are :
Answer :TRUE
The snowflake credits used by a virtual warehouses increase proportionately as the size of the virtual warehouse is increased
Options are :
- Yes. The credits usage is tied with the warehouse size
(Correct)
- No. The virtual warehouse size has no implication on the number of credits being used
Answer :Yes. The credits usage is tied with the warehouse size
Snowflake maintains the partitions using the order of the data in which it is inserted
Options are :
Answer :TRUE
Snowflake technology has been build from scratch, specifically designed for execution on cloud platforms.
Options are :
Answer :Yes
Which type of Snowflake tables will cease to exist once the session is closed?
Options are :
- Transient
- Clustered
- Temporary
(Correct)
- Permanent
Answer :Temporary
Which of the following simple transformations can be used while loading data through the COPY command?
Options are :
- Pivot
- Truncate
(Correct)
- Re-order Columns
(Correct)
- Omit Columns
(Correct)
- Transpose
- Cast
(Correct)
Answer :Truncate
Re-order Columns
Omit Columns
Cast
Micro partitioning can be disabled for tables if needed.
Options are :
Answer :FALSE
A share must have at least one consumer added to it
Options are :
Answer :FALSE
When loading a file through the COPY command, there is no way to partially load a file if errors are encountered. Either the whole file is loaded or nothing is loaded if errors are encountered.
Options are :
Answer :False
Please select the correct options that can be used to bring semi structured data into Snowflake.
Options are :
- Load the data as you would load a CSV file, Snowflake will make sense of the unstructured data itself.
- Transform the data while using the COPY command.
(Correct)
- Load semi structured data into a VARIANT column.
(Correct)
Answer :Transform the data while using the COPY command.
Load semi structured data into a VARIANT column.
In the Snowflake staged release process for new releases, which account types are applied updates AHEAD of every one else?
Options are :
- Enterprise & Higher Accounts
- Trial Accounts
- Designated accounts opting for early access
(Correct)
- Standard & Premier Accounts
Answer :Designated accounts opting for early access
A cloned object doesn't contribute to the over all storage unless..
Options are :
- New populated tables are created in one of the cloned schemas
(Correct)
- The configuration CREATE_COPY is set to true while cloning data
- Operations that modify data are performed on the cloned table e.g. update, insert or delete data
(Correct)
- The cloning is performed by a role which doesn?t have privileges on the source objects
Answer :New populated tables are created in one of the cloned schemas
Operations that modify data are performed on the cloned table e.g. update, insert or delete data
Snowflake COPY command provides the capability to validate the data inside a file, without actually loading it.
Options are :
Answer :True
What happens when a multi cluster virtual warehouse is set to auto scale? Select all that apply
Options are :
- If the number of concurrent users and queries increase on the virtual warehouse, additional clusters are started, up to the defined maximum cluster value
(Correct)
- Snowflake starts all clusters in the multi-cluster virtual warehouse
- If the demand is decreased the number of clusters are gradually shutdown, up to the defined minimum cluster value
(Correct)
- Snowflake starts minimum required clusters in the multi-cluster virtual warehouse that can accommodate the number of users & number of queries
(Correct)
Answer :If the number of concurrent users and queries increase on the virtual warehouse, additional clusters are started, up to the defined maximum cluster value
If the demand is decreased the number of clusters are gradually shutdown, up to the defined minimum cluster value
Snowflake starts minimum required clusters in the multi-cluster virtual warehouse that can accommodate the number of users & number of queries
On the WebUI which button on the top bar should you select to run queries?
Options are :
- Databases
- Worksheets
(Correct)
- Shares
- History
- Account
- Virtual Warehouses
Answer :Worksheets
A snowflake share can only have one consumer account added to it.
Options are :
Answer :FALSE
What happens when a virtual warehouse is resized to a LARGER size?
Select all that apply
Options are :
- the already executing queries are suspended, moved to the new server(s) and then resume executing
- the new server(s) will execute queries that are in queue
(Correct)
- the already executing queries are not shifted to the new server(s)
(Correct)
Answer :the new server(s) will execute queries that are in queue
the already executing queries are not shifted to the new server(s)
When a new user is created, multi factor authentication (MFA) is automatically enabled for that user by default
Options are :
Answer :FALSE
Snowflake database is based on the traditional shared disk architecture used by RDBMS like MySQL, Postgres.
Options are :
Answer :No
Multi cluster virtual warehouses are designed to handle ... Select all that apply
Options are :
- Queuing issues
(Correct)
- Large number of concurrent queries
(Correct)
- Large Complex Queries
- Large number of concurrent users
(Correct)
Answer :Queuing issues
Large number of concurrent queries
Large number of concurrent users
If retrieval of data from fail safe is required, you must
Options are :
- use SQL to retrieve the data yourself
- contact Snowflake support team to facilitate the retrieval
(Correct)
Answer :contact Snowflake support team to facilitate the retrieval
Which of the following will contribute to your account level storage usage?
Options are :
- User Defined Functions
- Database (and the tables in it)
(Correct)
- Snowflake Internal Stage
(Correct)
- Snowflake External Stages
- Views
Answer :Database (and the tables in it)
Snowflake Internal Stage
It is not possible to suspend a specific cluster in a multi-cluster virtual warehouse but rather the whole virtual warehouse is suspended.
Options are :
Answer :True
On the WebUI which button on the top bar should you select to see the query history?
Options are :
- Account
- Worksheets
- Virtual Warehouses
- Databases
- History
(Correct)
- Shares
Answer :History
What are the resources that a virtual warehouse provides? Select all that apply.
Options are :
- Temporary Storage
(Correct)
- User Management
- Memory
(Correct)
- CPU
(Correct)
Answer :Temporary Storage
Memory
CPU
For a multi cluster virtual warehouse the administrator set the minimum cluster count and the maximum cluster count to different values. This can be best described as ?
Options are :
- Scaling up
- Auto Scaling
(Correct)
Answer :Auto Scaling
A virtual warehouse must be running in order to process SQL queries. For which type of queries results may be produced without requiring a running virtual warehouse?
Select All that Apply
Options are :
- for queries for which results can be fulfilled from the metadata cache
(Correct)
- for queries that have previously run and their results are stored in the result cache
(Correct)
- for queries that make use of clustering keys
- for queries that process less then 10 MB of data
Answer :for queries for which results can be fulfilled from the metadata cache
for queries that have previously run and their results are stored in the result cache
The size of your Snowflake based data warehouse is virtually unlimited because it uses cloud storage as the underlying storage mechanism.
Options are :
Answer :Yes
Under the Download section in Snowflake Web UI, what are the connectors & programs that can be downloaded? Select All that apply
Options are :
- Unload Connector
- Redshift connector
- Spark Connector
(Correct)
- Node.js driver
(Correct)
- Python Components
(Correct)
Answer :Spark Connector
Node.js driver
Python Components
A virtual warehouse can be resized any time, regardless if it is in suspended state or active and executing queries.
Options are :
Answer :TRUE
Queries that have the following characteristics will benefit from clustering.
Select all that apply
Options are :
- Select all columns in the table
- Select all rows in the table
- Join on the columns which are part of the cluster key
(Correct)
- Filter on the columns which are part of the cluster key
(Correct)
- Sort on the columns which are part of the cluster key
(Correct)
- Group on the columns which are part of the cluster key
(Correct)
Answer :Join on the columns which are part of the cluster key
Filter on the columns which are part of the cluster key
Sort on the columns which are part of the cluster key
Group on the columns which are part of the cluster key
If you have an Enterprise Edition of Snowflake, you can designate it for early access for new Snowflake releases.
Options are :
Answer :TRUE
A share has been granted to a consumer. If a new object is added to the share it will?
Options are :
- require re-creation of the shared database
- become accessible to the consumer immediately
(Correct)
Answer :become accessible to the consumer immediately
The provider of data can add multiple databases in a Share definition.
Options are :
Answer :FALSE
What is a benefit of a multi cluster virtual warehouse?
Options are :
- It removes the need to manually start & stop virtual warehouses to accommodate fluctuating workloads
(Correct)
- It is cheaper to run your queries on a multi cluster virtual warehouse
- A multi cluster virtual warehouse can accommodate increased number of users without performance degradation
(Correct)
- A multi cluster virtual warehouse will execute more queries for the same amount of Snowflake credit usage
Answer :It removes the need to manually start & stop virtual warehouses to accommodate fluctuating workloads
A multi cluster virtual warehouse can accommodate increased number of users without performance degradation
What are the types of Snowflake queries that a virtual warehouse can execute. Select all that apply
Options are :
- SELECT
(Correct)
- INSERT
(Correct)
- SNOWPIPE
- COPY INTO
(Correct)
Answer :SELECT
INSERT
COPY INTO
You are the performance DBA at a large airlines company with a Snowflake Data warehouse. There is a large table (>5TB) containing telemetry data generated by airplane sensors.
The table is usually accessed by the "event_date" on which the data was generated, but often there are queries which access the table through the column "airplane_id".
How can you optimize table so that queries which use either event_date or the airplane_id in the WHERE clause run faster.
Options are :
- Concatenate the two columns and generate a new column in the table. Cluster the table on that column
- Increase the size of the virtual warehouse so that queries run faster.
- Introduce a cluster key on the combination of the two columns i.e.
CLUSTER BY(event_date,airplane_id)
(Correct)
- Do nothing, Snowflake will take care of ensuring efficiency of querying it self.
Answer :Introduce a cluster key on the combination of the two columns i.e.
CLUSTER BY(event_date,airplane_id)
Data protected by Failsafe can be recovered by?
Options are :
- The Snowflake support
(Correct)
- The Snowflake customer
- Both the snowflake customer & the snowflake support
Answer :The Snowflake support
Is this statement correct? Snowflake is based on existing database technology, which has been retrofitted to run on the cloud.
Options are :
Answer :No
Clustering keys for a table can contain only a single column.
Options are :
Answer :False
A snowflake user can see the query results of a query executed by another user.
Options are :
Answer :False
Snowflake stores data for each table in a proprietary columnar format.
Options are :
Answer :Yes
The query result cache is purged after 24 hours unless..
Options are :
- The value for query result cache purge setting is set a different number then 24
- Another query is executed within the 24 hours which makes use of the query result cache
(Correct)
Answer :Another query is executed within the 24 hours which makes use of the query result cache
What best describes Snowflake architecture?
Options are :
- Multiple Clusters Shared Data
(Correct)
- Single Cluster Shared Data
- Multiple Clusters Distributed Data
Answer :Multiple Clusters Shared Data
A Small virtual warehouse (comprising of 2 servers) executing for 2 hours will consume same number of credits as a Medium virtual warehouse (comprising of 4 servers) executing for 1 hour.
Options are :
Answer :TRUE
When a virtual warehouse is resized all queries that are in queue will use the resized instance?
Options are :
Answer :TRUE
Snowflake stores the following metadata about rows in a micro-partition. Select all that apply
Options are :
- The range of values for each of the column in the micro partition
(Correct)
- The number of distinct value
(Correct)
- Additional properties for optimization and efficient processing
(Correct)
Answer :The range of values for each of the column in the micro partition
The number of distinct value
Additional properties for optimization and efficient processing
The reader account belongs to ?
Options are :
- The consumer
- Shared ownership
- The producer
(Correct)
- Neither
Answer :The producer
The COPY command can load data from which of the following?
Options are :
- Internal stage
(Correct)
- External Stage i.e. Cloud Storage
(Correct)
- Detachable hard disks
- Tape drives
Answer :Internal stage
External Stage i.e. Cloud Storage
