Snowflake MCQ (Multiple Choice Questions), Snowflake Online Quiz

1 .

When was snowflake founded?

A)

2005

B)

2009

C)

2012

D)

2015

Correct Answer : Option (C) : 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 : Option (A) : 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 : Option (D) : 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 : Option (A) : 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 : Option (D) : 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 : Option (B) : AWS

7 .

The larger the warehouse, the more servers in the cluster

A)

True

B)

False

C)

Can not say

D)

--

Correct Answer : Option (A) : True

8 .

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

A)

True

B)

False

C)

Can not say

D)

--

Correct Answer : Option (B) : False

9 .

Snowflake Architecture: Cloud Services _____ of the service

A)

Myrna

B)

Layer

C)

Brain

D)

Data Manipulation

Correct Answer : Option (C) : Brain

10 .

Snowflake is a _____ product.

A)

DAAS

B)

IAAS

C)

SAAS

D)

PAAS

Correct Answer : Option (C) : SAAS