Snowflake MCQ (Multiple Choice Questions), Snowflake Online Quiz

1 .

When was snowflake founded?

A)

2005

B)

2009

C)

2012

D)

2015

Correct Answer : 2012

Explanation : Snowflake Inc. is a cloud computing–based data cloud company based in Bozeman, Montana. It was founded in July 2012 and was publicly launched in October 2014 after two years in stealth mode. The firm offers a cloud-based data storage and analytics service, generally termed "data-as-a-service".

2 .

Which is NOT featured essential in Snowflake

A)

Kaggle

B)

Optimization

C)

Authentication

D)

Data Protection

Correct Answer : Kaggle

3 .

Database designer should consider using Clustering Keys when _______

A)

The tables is very large (multi TB)

B)

Table is large enough to reside on many micro-partitions

C)

Columns in the table can provide sufficient filtering to select a subset of these micro-partitions

D)

All of the above

Correct Answer : All of the above

4 .

The use case and audience drives the selection of the proven data modeling techniques?

A)

True

B)

False

C)

Can not say

D)

--

Correct Answer : True

5 .

Data Sharing Consumers will have to________

A)

Incur the cost of Compute (virtual warehouse)

B)

Must create a database based on the share using the ACCOUNTADMIN role

C)

Can query shared objects in the same query that they query their own objects

D)

All of the above

Correct Answer : All of the above

6 .

select the cloud services provider supported by Snowflake architecture

A)

Dialogflow

B)

AWS

C)

Cloud Foundry

D)

HP Virtual Private Cloud

Correct Answer : AWS

7 .

The larger the warehouse, the more servers in the cluster

A)

True

B)

False

C)

Can not say

D)

--

Correct Answer : True

8 .

2X LARGE is default for warehouse created in the web interface

A)

True

B)

False

C)

Can not say

D)

--

Correct Answer : False

9 .

Snowflake Architecture: Cloud Services _____ of the service

A)

Myrna

B)

Layer

C)

Brain

D)

Data Manipulation

Correct Answer : Brain

10 .

Snowflake is a _____ product.

A)

DAAS

B)

IAAS

C)

SAAS

D)

PAAS

Correct Answer : SAAS

11 .

Which role in Snowflake allows a user to administer users and manage all database objects?

A)

ROOT

B)

SYSADMIN

C)

SECURITYADMIN

D)

ACCOUNTADMIN

Correct Answer : ACCOUNTADMIN

12 .

Snowflake automatically partitions the data so that the user does not need to define partition scheme?

A)

True

B)

False

C)

Can not say

D)

--

Correct Answer : True

13 .

Virtual Warehouse Types: Standard cannot "scale out"

A)

True

B)

False

C)

Neither False or True

D)

Can not say

Correct Answer : True

14 .

Which is "NOT" in the workload of segmentation

A)

ETL

B)

IBM WATSON

C)

DATA SCIENCE

D)

BI/DASHBOARDS

Correct Answer : IBM WATSON

15 .

Table are unique database objects in Snowflake?

A)

True

B)

False

C)

Can not say

D)

--

Correct Answer : False

16 .

Snowflake replicates the following layer(s) across availability zones

A)

Warehouse Layer

B)

Data Sharing Layer

C)

Cloud Services Layer

D)

Cloud Agnostic Layer

Correct Answer : Cloud Services Layer

17 .

When a multi-cluster warehouse is suspended, which of the following Snowflake cache will be purged?

A)

Local disk cache

B)

Metadata cache

C)

Remote disk cache (Resultset cache)

D)

All of the above

Correct Answer : Local disk cache

Explanation :

* When a multi-cluster warehouse (or a single cluster warehouse) is suspended, only the local disk cache is dropped. This cache is also known as warehouse cache. This is because this cache is essentially the fast SSD of the warehouse. So when the warehouse is gone, this cache is also gone with it.

* Metadata cache contains Snowflake account object information and statistics. It is always on and it is never dropped.

* Remote disk cache (resultset cache) caches exact query results including aggregations etc. and it persists the exact resultset for 24-hours after the query is executed irrespective of the state of the warehouse.

18 .

What are the minimum and the maximum number of clusters in a multi-cluster warehouse?

A)

Minimum: 1, Maximum: unlimited

B)

Minimum: 1, Maximum: 100

C)

Minimum: 1, Maximum: 99

D)

Minimum: 1, Maximum: 10

Correct Answer : Minimum: 1, Maximum: 10

Explanation : In a multi-cluster warehouse, the minimum number of clusters can be 1 and the maximum number of clusters can be 10.

19 .

Data Sharing Providers will have to __________

A)

Incur the cost of the data storage - normal rates apply

B)

May share a data set with an unlimited number of accounts

C)

May set up and manage "Reader Accounts" for consumers who are not already Snowflake customers

D)

All of the above

Correct Answer : All of the above

20 .

Informatica, Matillion, Azure data factory are examples of â€¦â€¦â€¦â€¦â€¦â€¦â€¦.. partners of the Snowflake partner ecosystem.

A)

Data Science

B)

Data Integration

C)

Data Management

D)

Business Intelligence

Correct Answer : Data Integration

Explanation :

Informatica, Matillion, and Talend are data integration partners that provide the following functionalities :

Extract : Exporting data from the data source.

Transform : Modifying data according to business rules.

Load : Loading data into Snowflake.

21 .

Which Snowflake cache does the user/administrator have control over?

A)

Data cache

B)

Results cache

C)

Metadata cache

D)

None of the above

Correct Answer : Metadata cache

22 .

Which of the following are options when creating a Virtual Warehouse?

A)

Auto-suspend

B)

Auto-resume

C)

Both (A) and (B)

D)

Storage size

Correct Answer : Both (A) and (B)

23 .

Which of the following programming languages are supported in Snowflake to write user-defined functions (UDFs)?

A)

SQL

B)

Java

C)

JavaScript

D)

SQL and Javascript

Correct Answer : SQL and Javascript

Explanation :

User-defined functions (UDFs) can be used in Snowflake to write custom business logic which is hard to encapsulate within individual SQL statements. UDFs (together with Stored Procedures) enable database-level programming in Snowflake.

At present, Snowflake supports two programming languages to write UDFs : Javascript UDFs and SQL UDFs.

24 .

Multi-Cluster Warehouses support high concurrency?

A)

True

B)

False

C)

Can not say

D)

--

Correct Answer : True

25 .

Federated authentication in Snowflake is complaint with SAML 2.0?

A)

True

B)

False

C)

Can not Say

D)

--

Correct Answer : True

26 .

Snowflake is currently available on the following Cloud Providers:

A)

AWS

B)

Google Cloud

C)

Microsoft's Azure

D)

All of the above

Correct Answer : All of the above

27 .

Which of the following terms best describes Snowflake's database architecture?

A)

Shared disk

B)

Multi-cluster shared data

C)

Columnar shared nothing

D)

Cloud-native shared memory

Correct Answer : Multi-cluster shared data

28 .

Data can be shared Read-Only across Snowflake accounts and can also be cloned?

A)

True

B)

False

C)

Can not say

D)

--

Correct Answer : False

29 .

MFA (Multi-factor Authentication) is automatically enabled for your account and available for all users to self-enroll?

A)

True

B)

False

C)

Can not say

D)

--

Correct Answer : True

30 .

Which Snowflake edition supports transmitting data in encrypted form over the network between VPCs (virtual private cloud)?

A)

All editions

B)

Enterprise edition and above

C)

Business Critical edition and Above

D)

All except for the Virtual Private Snowflake (VPS) edition

Correct Answer : Business Critical edition and Above

Explanation : A Snowflake account on AWS (or Azure) is implemented as a VPC. There are two ways to establish communication between your Snowflake VPC and other VPCs (e.g. your organization’s VPC).

One is to transmit the traffic over the public internet. Other (and safer) option is to establish an exclusive, highly secure network between your Snowflake account and your other AWS VPCs (in the same AWS region), fully protected from unauthorized access.

To implement this secure channel of communication between VPCs, AWS supports a feature called AWS PrivateLink (Azure also supports a similar feature called Azure PrivateLink). Snowflake offers support for AWS PrivateLink (and Azure PrivateLink) based communication in Business Critical Edition and above.

31 .

Which of the following statements will you use to change the warehouse for workload processing to a warehouse named 'COMPUTE_WH_XL'?

A)

SET CURRENT_WAREHOUSE = COMPUTE_WH_XL

B)

USE WAREHOUSE COMPUTE_WH_XL;

C)

USE CURRENT_WAREHOUSE(â€˜COMPUTE_WH_XLâ€™);

D)

SET CURRENT_WAREHOUSE = COMPUTE_WH, SIZE = XL;

Correct Answer : USE WAREHOUSE COMPUTE_WH_XL;

Explanation :

A session context in Snowflake consists of 4 objects:

* Role

* Warehouse

* Database

* Schema

You can set appropriate session context using a set of SQL statements given below. These statements specify the role, warehouse, database, or schema to use for the current session:

Use warehouse <<warehouse-name>>

Use role <<role-name>>

Use database <<database-name>>

Use schema <<schema-name>>

So the correct answer of this question is:

Use warehouse COMPUTE_WH_XL;

32 .

Semi-structured data can be queried using SQL while incorporating JSON path notation?

A)

True

B)

False

C)

Can not say

D)

--

Correct Answer : True

33 .

Drop Role can be granted within a Snowflake account by the administrator?

A)

True

B)

False

C)

Can not Say

D)

--

Correct Answer : True

34 .

Snowflake supports data in VARIANTs up to a maximum size of_________

A)

4 MB uncompressed

B)

8 MB uncompressed

C)

16 MB compressed

D)

32 MB compressed

Correct Answer : 16 MB compressed

35 .

The process of co-locates column data with same values in the same micro-partition, if possible, is called ___________?

A)

Partitioning

B)

Re-Clustering

C)

Both (A) and (B)

D)

Natural Clustering

Correct Answer : Natural Clustering

36 .

A defined data set can be shared with customers outside the Snowflake account is?

A)

Snowflake's Cloning

B)

Snowflakes's Data Sharing

C)

Both (A) and (B)

D)

None of the above

Correct Answer : Snowflakes's Data Sharing

37 .

_____________ is used to analyze the execution details of a query?

A)

Metadata

B)

Statistics

C)

Query Plan

D)

Query Profile

Correct Answer : Query Profile

38 .

Snowflake's architecture includes advance capabilities in the cloud services layer that delivers query optimization?

A)

True

B)

False

C)

Can not say

D)

--

Correct Answer : True

39 .

This type of cache lives on the Cloud Services layer?

A)

Server

B)

Results

C)

Metadata

D)

Warehouse

Correct Answer : Metadata

40 .

Once the time-travel period has expired, it is possible to request Snowflake support to retrieve historical data for a period of

A)

Day

B)

Days

C)

It is user-configurable

D)

It depends on the Snowflake edition

Correct Answer : Days

Explanation :

After the time travel data retention period is over, you can use Snowflake’s fail-safe feature to recover your data. The duration of the fail-safe period is 7 days (Answer B is correct). This is a fixed duration and cannot be changed.

Only Snowflake support personnel can help recover data during the fail-safe period. The fail-safe feature is available to all customers irrespective of the Snowflake edition.

The below diagram succinctly summarizes key differences between Snowflake’s two important data protection features – time-travel and fail-safe.

41 .

What technique does Snowflake use to limit the number of micro-partitions scanned by each query?

A)

B-Tree

B)

Pruning

C)

Indexing

D)

Map Reduce

Correct Answer : Pruning

42 .

Data Sharing Consumers will have to :

A)

Incur the cost of Compute (virtual warehouse)

B)

Must create a database based on the share using the ACCOUNTADMIN role

C)

Can query shared objects in the same query that they query their own objects

D)

All of the above

Correct Answer : All of the above

43 .

What is the frequency for Snowflake to apply software patches to the code base?

A)

Semi-annually

B)

Monthly

C)

Weekly

D)

Daily

Correct Answer : Weekly

44 .

If the Credit Quota of a Resource Monitor is reached, suspended warehouses can not be resumed until one of the conditions is met________

A)

A new billing cycle starts

B)

Credit quota of the monitor is increased

C)

The monitor is no longer assigned to the warehouse

D)

All of the above

Correct Answer : All of the above

45 .

Data Sharing is only supported between accounts in the same Snowflake region?

A)

True

B)

False

C)

Can not say

D)

--

Correct Answer : True

46 .

User can query a STAGE object?

A)

True

B)

False

C)

Can not say

D)

--

Correct Answer : True

47 .

Which of the following is not a characteristic of "automatic micro-partitions" in Snowflake?

A)

Avoids skews between partitions

B)

New partitions are created on logical properties

C)

Partitioning is automatically completed on the natural ingestion order of the data

D)

The natural ingestion order maintains correlations between columns which could be useful for pruning

Correct Answer : New partitions are created on logical properties

48 .

When scaling up a Snowflake warehouse, what is the scaling factor when moving between T-shirt sizes?

A)

2

B)

4

C)

8

D)

User Specified

Correct Answer : 2

49 .

Snowflake deploys into a customer VPC or VNET?

A)

True

B)

False

C)

Can not say

D)

--

Correct Answer : False

50 .

Which layer contains virtual warehouses for data access?

A)

Cloud Services

B)

Database Storage

C)

Both (A) and (B)

D)

Query Processing

Correct Answer : Query Processing

51 .

Which Snowflake edition supports Search Optimization Service to improve performance of point lookup queries?

A)

All editions

B)

Enterprise edition and above

C)

Business Critical edition and Above

D)

All except Virtual Private Snowflake (VPS) edition

Correct Answer : Enterprise edition and above

Explanation : Search Optimization Service in Snowflake is a background service that is designed to improve the performance of point lookup queries. A point lookup query is essentially a SELECT statement that returns only a small number of distinct rows from a large dataset. The service runs transparently from an end-user’s standpoint. Only the Enterprise edition and above provide this feature.

52 .

History tab in the Snowflake Web Interface supports viewing of user queries submitted in the past _______ day(s)

A)

1 day

B)

7 days

C)

14 days

D)

90 days

Correct Answer : 14 days

Explanation : ‘Query History’ view in Snowflake Web UI stores queries executed and query profile information for all queries, executed by all users, using any interface (e.g., Web UI, SnowSQL, Business Application… or any other interface) for a period of 14 days

53 .

Semi-structured data strings are stored in a column with a Snowflake data type of __________________?

A)

Variant

B)

Object

C)

Varchar

D)

Character

Correct Answer : Variant

54 .

Which of the following techniques can be used in Snowflake to improve query performance?

A)

Query Hints

B)

Index definition

C)

Distribution keys

D)

Cluster Keys/Reclustering

Correct Answer : Cluster Keys/Reclustering

55 .

MFA (Multi-factor Authentication) is an integrated feature powered by Duo Security service?

A)

True

B)

False

C)

Can not say

D)

--

Correct Answer : True

56 .

In order to query a table in Snowflake, the user must be granted which privileges at a minimum (select all that apply):

A)

Grant Select on <table>

B)

Grant USAGE on <schema>

C)

Grant USAGE on <database>

D)

All of the above

Correct Answer : All of the above

57 .

Which is not a characteristic of Time Travel?

A)

Protection from accidental data operations

B)

Previous versions of data automatically retained

C)

Recover data with the cost of running backups

D)

Retention period selected by customers (up to 90 days for Enterprise edition)

Correct Answer : Recover data with the cost of running backups

58 .

A share can't be cloned by a consumer account, but the share data CAN be copied into a table?

A)

True

B)

False

C)

Can not say

D)

--

Correct Answer : True

59 .

What is the optimal file sizing recommendation for loading data into Snowflake?

A)

10 MB to 100 MB, uncompressed

B)

100 MB to 250 MB, compressed

C)

100 MB to 512 MB, uncompressed

D)

10 GB to 100 GB, compressed

Correct Answer : 100 MB to 250 MB, compressed

Explanation :

Snowflake recommends that to optimize the number of parallel operations for a load, data files should roughly be 100-250 MB in size, compressed.

In case input data files are smaller than this, it is better to aggregate multiple input files. On the other hand, if the input data files are larger than this, it is better to split them into smaller files to match this guidance.

Snowflake also recommends against loading very large files (e.g., 100 GB+ sizes) without splitting them as splitting of files will take advantage of parallelism.

Practical Info – The recommendation applies to both modes of data loading – bulk load using SnowSQL (COPY INTO) and continuous/micro-batch using Snowpipe.

60 .

Which cache does the query optimizer refer to first? Second? And Third?

A)

First: metadata Cache. Second: warehouse Cache. Third: results cache

B)

First: warehouse cache. Second: results cache. Third: metadata cache

C)

First: warehouse Cache. Second: metadata Cache. Third: results cache

D)

First: metadata Cache. Second: results Cache. Third: warehouse cache

Correct Answer : First: metadata Cache. Second: results Cache. Third: warehouse cache

61 .

Following are the key reasons that make Snowflake a "True SaaS" product.

A)

Snowflake completely runs on cloud infrastructure and is accessible over the internet

B)

Thereâ€™s no hardware or software to install, configure, maintain or upgrade at the userâ€™s end

C)

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

D)

All of the above

Correct Answer : All of the above

Explanation :

Snowflake is fully managed, cloud-native, on-demand software offered as a service (SaaS – software as a service) over the internet. It is built from the ground up for the cloud. It is fully hosted on public cloud infrastructure and uses cloud resources for compute and storage. At the user’s end, there’s no hardware or software installation required.

There are no patches or upgrades to be done by the user. New releases are rolled out transparently and don’t require user intervention. The software is available on-demand over the internet. You can log on to snowflake.com, open an account, and you are ready to use Snowflake in your organization.

Snowflake offers unlimited and instant scalability of compute and storage resources. You can scale up and down on-demand based on your need. You need to only pay for the Snowflake resources that you use. Owing to these unique design elements, Snowflake is currently the most popular cloud data warehouse solution for enterprises worldwide.

62 .

Namespace in Snowflake is comprised of______

A)

Database, schema, and table

B)

Account, database, and schema

C)

Database and schema

D)

Warehouse, database, and schema

Correct Answer : Database and schema

Explanation : When you want to perform any operation (e.g., DDL or DML) on Snowflake’s database objects, you need to specify the namespace. Namespace in Snowflake consists of the name of the database and the schema’s name within that database.

63 .

Following are the two modes in which you can run a multi-cluster virtual warehouse in Snowflake.

A)

Dynamic

B)

Maximized

C)

Auto-Scale

D)

Both (B) and (C)

Correct Answer : Both (B) and (C)

Explanation :

A multi-cluster virtual warehouse consists of a group of compute clusters provisioned either based on the user/query load. There are two modes in which you can create a multi-cluster warehouse. These modes govern the way compute Snowflake provisions clusters.

Maximized – In this mode, Snowflake starts all compute clusters within the warehouse when the warehouse is started. This mode is enabled by setting the same value for Min. and Max. clusters

Auto-Scale – In this mode, Snowflake starts the warehouse with Min. number of clusters and spins up new clusters incrementally and automatically as and when the user/query load increases. The maximum number of clusters Snowflake can add is governed by the value given in Max. clusters. This mode is enabled by setting different values for Min. and Max. clusters.

64 .

Snowflake includes administration settings for resource consumption in order to:

A)

Maintain availability

B)

Help control costs associated with unexpected credit usage of warehouses

C)

Manage access to data warehouse for specified users

D)

All of the above

Correct Answer : Help control costs associated with unexpected credit usage of warehouses

65 .

A materialize view in Snowflake will add more storage cost to the customer bill

A)

True

B)

False

C)

Can not sat

D)

--

Correct Answer : True

66 .

Non-native values such as dates and timestamps are stored as strings when loaded into a VARIANT column so which statements are true:

A)

Operations on these values could be slower

B)

These columns would consume more space than when stored in a relational column with the corresponding data type

C)

Both (A) and (B)

D)

Neither A or B are true

Correct Answer : Both (A) and (B)

67 .

It is a best practice to have the majority of objects owned by SYSADMIN?

A)

True

B)

False

C)

Can not say

D)

--

Correct Answer : True

68 .

The PUT and GET commands can be executed via the Snowflake UI?

A)

True

B)

False

C)

Can not say

D)

--

Correct Answer : False

69 .

A defined data set is a point in time snapshot and can be updated by customers is?

A)

Snowflake's Cloning

B)

Snowflakes's Data Sharing

C)

Both (A) and (B)

D)

None of the above

Correct Answer : Snowflake's Cloning

70 .

Snowflake utilizes per _______________ billing.

A)

Millisecond

B)

Second

C)

Minute

D)

Hour

Correct Answer : Second

71 .

Select the best description of Zero-Copy Cloning_______

A)

Metadata-only operation

B)

No replication of data

C)

Unmodified data stored once; modified data stored as new blocks

D)

All of the above

Correct Answer : All of the above

72 .

Micro-partitions are immutable?

A)

True

B)

False

C)

Can not say

D)

--

Correct Answer : True

73 .

To recluster a table, an admin would execute the RECLUSTER command?

A)

True

B)

False

C)

Can not say

D)

--

Correct Answer : False

74 .

There are cases where separate accounts are required such as different editions or regions?

A)

True

B)

False

C)

Can not say

D)

--

Correct Answer : True

75 .

To help control the usage of credits in Auto-scale mode, Snowflake provides a property, _________, that determines the scaling policy to use when automatically starting or shutting down additional clusters. Select the property:

A)

Auto_Scale

B)

Maximum_number_of_server_clusters

C)

Scaling_policy

D)

Minimum_number of server clusters

Correct Answer : Scaling_policy

76 .

The Snowflake UI is divided into for basic areas. Which of the following areas is not part of the UI:

A)

History

B)

Warehouse

C)

Databases

D)

Query

Correct Answer : Query

77 .

Which layer provides centralized services for the data warehouse?

A)

Database Storage

B)

Query Processing

C)

Cloud Services

D)

None of the above

Correct Answer : Cloud Services

78 .

Snowflake supports landing data into bring your own device?

A)

True

B)

False

C)

Can not say

D)

--

Correct Answer : False

79 .

The commands for loading data into Snowflake are_______

A)

COPY & INSERT

B)

COPY & PUT

C)

INSERT & PUT

D)

None of the above

Correct Answer : COPY & INSERT

80 .

When dealing with a large complex query, the user must_________

A)

Rewrite the query

B)

Scale up the cluster

C)

Scale out the cluster

D)

All of the above

Correct Answer : Scale up the cluster

81 .

The following object in Snowflake is also known as the 'data dictionary' of a database.

A)

Data Catalog

B)

PUBLIC schema

C)

INFORMATION_SCHEMA schema

D)

None of the above

Correct Answer : INFORMATION_SCHEMA schema

Explanation :

When you create a database in Snowflake, two schemas get automatically created within the database. 1. INFORMATION_SCHEMA schema and 2. PUBLIC schema.

INFORMATION_SCHEMA is a read-only schema. It contains only views. The views have all meta-data information about the database objects e.g., all tables of that database, all columns, all stages, all sequences etc. These views can be queried to retrieve meta-data information about the database. Hence, the INFORMATION_SCHEMA schema is also known as the data dictionary of a database.

82 .

One benefit of client-side encryption is the storage service layer only contains encrypted version of the data?

A)

True

B)

False

C)

Can not say

D)

--

Correct Answer : True

83 .

MFA (Multi-factor Authentication) can be used for connecting to Snowflake via the Snowflake JDBC driver?

A)

True

B)

False

C)

Can not say

D)

--

Correct Answer : True

84 .

Stages are unique database objects in Snowflake?

A)

True

B)

False

C)

Can not say

D)

--

Correct Answer : True

85 .

This type of cache lives on the Compute instance?

A)

Server

B)

Results

C)

Metadata

D)

Warehouse

Correct Answer : Warehouse

86 .

Zero-copy cloning operation is supported for the following objects in Snowflake.

A)

A temporary Table

B)

A transient Table

C)

A permanent Table

D)

Both (B) and (C)

Correct Answer : Both (B) and (C)

87 .

A resource monitor can be created by________

A)

SYSADMIN role

B)

ACCOUNTADMIN role

C)

USERADMIN role

D)

Any of the above

Correct Answer : ACCOUNTADMIN role

88 .

Which of the following statements are true about multi-cluster Warehouses in Snowflake? (Select all that apply).

A)

Multi-cluster warehouses support all properties of a single-cluster warehouse

B)

Increasing the number of compute resources in a multi-cluster warehouse is an example of scaling up

C)

A single cluster warehouse can be reconfigured to turn into a multi-cluster warehouse but vice-versa is not true

D)

None of the above

Correct Answer : Multi-cluster warehouses support all properties of a single-cluster warehouse

Explanation :

Multi-cluster warehouses support all the same properties and actions as single warehouses, including:

* Specifying warehouse size ( e.g. XS, S, M, L…)

* Resizing a warehouse at any time.

* Auto-suspending a running warehouse due to inactivity;

* Auto-resuming a suspended warehouse when new queries are submitted.

Answer choice-B is incorrect. Increasing the number of compute resources in a multi-cluster warehouse is an example of scaling out. Increasing the size of compute clusters is an example of scaling up.

Answer choice-C is incorrect. A single cluster warehouse can be reconfigured to turn into a multi-cluster warehouse. To do this, you will have to set the max_cluster_count to a value greater than 1 as shown in the example below:

ALTER WAREHOUSE “COMPUTE_WH” SET MAX_CLUSTER_COUNT = 3;

Similarly, a multi-cluster warehouse can be reconfigured to turn into a single cluster warehouse. To do this, you will have to set the max_cluster_count to a value equal to 1 as shown in the example below:

ALTER WAREHOUSE “COMPUTE_WH” SET MAX_CLUSTER_COUNT = 1;

89 .

What is the recommended approached for making a variant column accessible in a BI tool?

A)

A view

B)

A pre-defined mapping

C)

Leveraging a JSON parser

D)

There is no way to do this

Correct Answer : A view

90 .

How many resource monitors can you have at the account level?

A)

0

B)

1

C)

2

D)

up to 5

Correct Answer : 1

91 .

Snowflake users with support contracts that have a Severity-1 issue should contact Snowflake in these ways except :

A)

844-SNOWFLAKE

B)

Snowflake Lodge - set appropriate severity (1-4)

C)

Send email

D)

None of the above

Correct Answer : Send email

92 .

Snowflake's architecture includes advance capabilities in the cloud services layer that delivers metadata service?

A)

True

B)

False

C)

Can not say

D)

--

Correct Answer : True

93 .

Which approach would result in improved performance through linear scaling of data ingestion workload:

A)

Resize virtual warehouse

B)

Consider the practice of organizing data by granular path

C)

Consider the practice of splitting input file batch within the recommended range of 10MB and 100MB

D)

All of the above

Correct Answer : All of the above

94 .

Snowflake's Resource Monitors have the following capabilities_____

A)

Can only be created by an ACCOUNTADMIN

B)

Trigger actions (i.e. like suspending) when the limit is reached

C)

impose limits on the number of credits that a warehouse can consume

D)

All of the above

Correct Answer : All of the above

95 .

Which of the following is not a layer in Snowflake's Architecture?

A)

Storage

B)

Data Catalog

C)

Cloud Services

D)

Virtual Warehouses

Correct Answer : Data Catalog

96 .

An enterprise view of data is useful because_______

A)

Data sets can be shared securely

B)

A data set can be stored once and shared multiple times

C)

Data set provisioning is assigned to the owner of the data set

D)

All of the above

Correct Answer : All of the above

97 .

What is data skew is when partitions in database become disproportionately-sized?

A)

True

B)

False

C)

Can not say

D)

--

Correct Answer : True

98 .

Which of the following best describes Snowflake's processing engine?

A)

Based on Map Reduce

B)

A derivative of Presto

C)

Native SQL

D)

Leverages Apache Spark

Correct Answer : Native SQL

99 .

Query statement encryption is supported on ___________ accounts?

A)

Standard

B)

Business Critical

C)

Enterprise

D)

Virtual Private Snowflake (VPS)

Correct Answer : Business Critical

100 .

Snowflake optimizes the storage for semi-structured data based on the repeating elements within the semi-structured strings?

A)

True

B)

False

C)

Can not say

D)

--

Correct Answer : True

101 .

Which layer does Snowflake store the various statistics for databases, tables, columns, and files?

A)

Compute

B)

Storage

C)

Cloud Services

D)

Snowflake does not store statistics

Correct Answer : Cloud Services

102 .

All interactions with data are initialized through the services layer?

A)

True

B)

False

C)

Can not say

D)

--

Correct Answer : True

103 .

What is the best practice for handling semi-structured data with 3rd party BI tools?

A)

Use the BI tool to create a metadata object to view the column

B)

ETL the column with other columns that are part of the query into a structured table

C)

Create a Snowflake view that parse the semi-structured column into structure columns for the BI tool to retrieve

D)

All of the above

Correct Answer : Create a Snowflake view that parse the semi-structured column into structure columns for the BI tool to retrieve

104 .

Which of the following are security best practices for Snowflake?

A)

All objects owned by SYSADMIN

B)

Grant all of your roles back to SYSADMIN

C)

All roles and users are own by SECURITYADMIN

D)

All of the above

Correct Answer : All of the above

105 .

How many cluster keys can reside on a Snowflake table?

A)

0

B)

1

C)

3

D)

4

Correct Answer : 1

106 .

One benefit of client-side encryption is that it provides a secure system for managing data in cloud storage?

A)

True

B)

False

C)

Can not say

D)

--

Correct Answer : True