A BOOLEAN data type in Snowflake can represent
1.TRUE
2.FALSE
3.NULL
4.BOOLEAN datatype is not supported
A materialize view in Snowflake will add more storage cost to the customer bill
1. True
2. False
3. Can not sat
4.--
A share can't be cloned by a consumer account, but the share data CAN be copied into a table?
1. True
2.False
3. Can not say
4.--
Data Sharing Consumers will have to :
1.Incur the cost of Compute (virtual warehouse)
2.Must create a database based on the share using the ACCOUNTADMIN role
3.Must create a database based on the share using the ACCOUNTADMIN role
4.All of the above
Data Sharing is only supported between accounts in the same Snowflake region?
1. True
2. False
3.Can not say
4. --
Following are the key reasons that make Snowflake a "True SaaS" product.
1.Snowflake completely runs on cloud infrastructure and is accessible over the internet
2. There’s no hardware or software to install, configure, maintain or upgrade at the user’s end
3. Snowflake supports key properties of as-a-service offering such as on-demand and instance elasticity, unlimited scalability of compute and storage and pay-per-use
4. Snowflake supports key properties of as-a-service offering such as on-demand and instance elasticity, unlimited scalability of compute and storage and pay-per-use
Following are the key reasons that make Snowflake a ‘‘True SaaS’’ product.
1. Snowflake completely runs on cloud infrastructure and is accessible over the internet
2.There’s no hardware or software to install, configure, maintain or upgrade at the user’s end
3.Snowflake supports key properties of as-a-service offering such as on-demand and instance elasticity, unlimited scalability of compute and storage and pay-per-use
4.All of the above
Following are the key reasons that make Snowflake a ‘‘True SaaS’’ product.
1. Snowflake completely runs on cloud infrastructure and is accessible over the internet
2.There’s no hardware or software to install, configure, maintain or upgrade at the user’s end
3.Snowflake supports key properties of as-a-service offering such as on-demand and instance elasticity, unlimited scalability of compute and storage and pay-per-use
4.All of the above
Following are the two modes in which you can run a multi-cluster virtual warehouse in Snowflake.
1. Dynamic
2.Maximized
3.Auto-Scale
4.Multi-threaded
Following programming languages/drivers, support is available out-of-the-box (natively) in Snowflake
1.JDBC/ODBC driver
2.Google Flutter
3.Go, Node.js driver
4.Scala connector
From the given options, select the cloud services provider supported by Snowflake architecture.
1.Amazon Web Services (AWS)
2.Google (GCP)
3.Cloud Foundry
4.Microsoft Azure
From the statements given below, select the statements which are TRUE for reader accounts.
1.A reader account facilitates data sharing with consumers that do not have a Snowflake account
2.One reader account can be used to access multiple shares provided by different provider accounts
3.One reader account can be used to access multiple shares provided by different provider accounts
4.A reader account has the same access to Snowflake support as the provider account
History tab in the Snowflake Web Interface supports viewing of user queries submitted in the past _______ day(s)
1. 1 day
2. 7 days
3.14 days
4.90 days
History’ tab in the Snowflake Web Interface supports viewing of user queries submitted in the past….. day(s)
1.24 hours or 1 day
2.7 days
3.14 days
4.90 days
If the Credit Quota of a Resource Monitor is reached, suspended warehouses can not be resumed until one of the conditions is met____
1. A new billing cycle starts
2.Credit quota of the monitor is increased
3. The monitor is no longer assigned to the warehouse
4.All of the above
In the case of a Snowflake account created on AWS,……….. is responsible for the management of Availability Zones?
1.Customer
2.Snowflake
3.Cloud Provider
4.It is a shared responsibility
Informatica, Matillion, Azure data factory are examples of ……. partners of the Snowflake partner ecosystem.
1.Data Management
2.Business Intelligence
3.Data Integration
4.Data Science
Namespace in Snowflake is comprised of:
1.Database and schema
2.Account, database, and schema
3.Database, schema, and table
4.Warehouse, database, and schema
Namespace in Snowflake is comprised of______
1.Database, schema, and table
2. Account, database, and schema
3. Database and schema
4. Warehouse, database, and schema
Non-native values such as dates and timestamps are stored as strings when loaded into a VARIANT column so which statements are true:
1.Operations on these values could be slower
2.These columns would consume more space than when stored in a relational column with the corresponding data type
3.Both (A) and (B)
4. Neither A or B are true
Once the time-travel period has expired, it is possible to request Snowflake support to retrieve historical data for a period of
1.Day
2.Days
3.It depends on the Snowflake edition
4. It is user-configurable
Selecting the right clustering key can dramatically improve query performance. Following are the good yardsticks to choose an appropriate clustering key:
1.Use columns that are most frequently found in WHERE clause
2.A date column is usually a not a good candidate to be in the clustering key
3.A join column can be considered as clustering key
4.Using expressions in the clustering key may help reduce cardinality.
Semi-structured data strings are stored in a column with a Snowflake data type of ________
1. Variant
2.Object
3. Varchar
4.Character
Snowflake deploys into a customer VPC or VNET?
1. True
2. False
3.Can not say
4. --
Snowflake includes administration settings for resource consumption in order to:
1.Maintain availability
2. Help control costs associated with unexpected credit usage of warehouses
3. Manage access to data warehouse for specified users
4. All of the above
Snowflake provides the following types of internal stages to load data.
1.Table Stage
2.Data Stage
3.User Stage
4.Named Stage
Snowflake replicates the following layer(s) across availability zones
1.Cloud Services Layer
2.Warehouse Layer
3.Storage Layer
4.Cloud Agnostic Layer
The following object in Snowflake is also known as the ‘data dictionary’ of a database.
1.PUBLIC schema
2.Data Catalog
3.INFORMATION_SCHEMA schema
4.None of the above
To execute a query in Snowflake, you need to provide context. The context consists of the following.
1.Virtual Warehouse (VW)
2.Database
3.Schema
4.Role
User can query a STAGE object?
1. True
2. False
3.Can not say
4. --
What are the key considerations for choosing a specific region for your Snowflake account?
1.Cost
2.Proximity to the end-users
3.Data sovereignty
4.Regulatory requirements
What are the minimum and the maximum number of clusters in a multi-cluster warehouse?
1.Minimum: 1, Maximum: 99
2.Minimum: 1, Maximum: 100
3.Minimum: 1, Maximum: 10
4.Minimum: 1, Maximum: unlimited
What is the frequency for Snowflake to apply software patches to the code base?
1. Semi-annually
2. Semi-annually
3. Weekly
4. Daily
What is the optimal file sizing recommendation for loading data into Snowflake?
1.10 MB to 100 MB, uncompressed
2.100 MB to 250 MB, compressed
3.100 MB to 250 MB, uncompressed
4.10 GB to 100 GB, compressed
What technique does Snowflake use to limit the number of micro-partitions scanned by each query?
1. B-Tree
2. Pruning
3. Indexing
4.Map Reduce
When a multi-cluster warehouse is suspended, which of the following Snowflake cache will be purged?
1.Metadata cache
2.Remote disk cache (Resultset cache)
3.Local disk cache
4.All of the above
When scaling up a Snowflake warehouse, what is the scaling factor when moving between T-shirt sizes?
1.2
2.4
3.8
4. User Specified
Which cache does the query optimizer refer to first? Second? And Third?
1.Which cache does the query optimizer refer to first? Second? And Third?
2.First: warehouse Cache. Second: metadata Cache. Third: results cache
3.First: metadata Cache. Second: results Cache. Third: warehouse cache
4.D. First: metadata Cache. Second: warehouse Cache. Third: results cache
Which is not a characteristic of Time Travel?
1. Protection from accidental data operations
2.Previous versions of data automatically retained
3.Recover data with the cost of running backups
4.Retention period selected by customers (up to 90 days for Enterprise edition)
Which layer contains virtual warehouses for data access?
1. Cloud Services
2. Database Storage
3. Both (A) and (B)
4. Query Processing
Which of the following data types are supported in Snowflake for semi-structured data?
1.VARIANT
2.OBJECT
3.TEXT
4.CLOB
Which of the following is not a characteristic of "automatic micro-partitions" in Snowflake?
1. Avoids skews between partitions
2. New partitions are created on logical properties
3. Partitioning is automatically completed on the natural ingestion order of the data
4. The natural ingestion order maintains correlations between columns which could be useful for pruning
Which of the following programming languages are supported in Snowflake to write user-defined functions (UDFs)?
1.SQL
2.Java
3.JavaScript
4.Python
Which of the following statements are TRUE concerning a stream object in Snowflake?
1.A stream object provides a record of DML changes (inserts, updates, deletes) made to a table at row level.
2.A stream object can keep track of DML changes for the entire life of a table.
3.Streams on materialized views are not supported.
4.Streams on external tables are not supported.
Which of the following statements will you use to change the warehouse for workload processing to a warehouse named ‘COMPUTE_WH_XL’?
1.SET CURRENT_WAREHOUSE = COMPUTE_WH_XL
2.USE WAREHOUSE COMPUTE_WH_XL;
3.USE WAREHOUSE COMPUTE_WH_XL;
4.SET CURRENT_WAREHOUSE = COMPUTE_WH, SIZE = XL;
Which of the following techniques can be used in Snowflake to improve query performance?
1. Query Hints
2. Index definition
3. Distribution keys
4.Cluster Keys/Reclustering
Which Snowflake edition supports Search Optimization Service to improve performance of point lookup queries?
1.All editions
2.Enterprise edition and above
3.Business Critical edition and Above
4.All except Virtual Private Snowflake (VPS) edition
Which Snowflake edition supports transmitting data in encrypted form over the network between VPCs (virtual private cloud)?
1.All editions
2.Enterprise edition and above
3.Business Critical edition and Above
4.All except for the Virtual Private Snowflake (VPS) edition
While loading data into Snowflake, which of the following transformations are supported?
1.Column reordering
2.Column omission
3.Derived columns
4.Cast operation
You are the owner of a table T1 which is in schema S1. The schema is in database D1. In order to grant read-only permissions of this table to a newly created role R1, you will need to…(select all that apply)
1.Grant ‘USAGE’ on database D1
2.Grant ‘USAGE’ on schema S1
3.Grant ‘SELECT’ on schema S1
4. Grant ‘SELECT’ on table T1