Q.1 How does Snowflake store data internally?
a. In CSV format
b. In JSON format
c. In a proprietary format
Ans: c. proprietary format
Q.2 Snowflake has tightly coupled storage and compute
a. False b. True
Ans: a. False
Q.3 The physical storage structure, compression and statistics of data is handled by DBAs?
a. True b. False
Ans: b. False (Snowflake handles them automatically)
Q.4 Which of the following are features of Snowflake?
a. ACID
b. ANSI compliant
c. No proprietary hardware
d. All the options
Ans: d. All the options
Q.5 which of the following are modes for multi-clustering?
a. Maximized and Softscale
b. Maximized and minimized
c. Maximized and Auto-scale
d. minimized and Auto-scale
Ans: c. Maximized and Auto-scale
Q.6 Snowflake uses __ architecture
a. Shared disk
b. Shared-nothing
c. Shared data
Ans: c. Shared data
Q.7 Each compute cluster share resources with other clusters.
a. True b. False
Ans: b. False
Q.8 Snowflake provides which of the following auto-scaling policies (Also determines the credits consumed by a multi-cluster warehouse running in auto-scale mode)?
a. Standard and performance intensive
b. standard and economy
c. normal and performance intensive
d. normal and economy
Ans: b. standard and economy
Q.9 Total number of servers in a warehouse is calculated by?
a. adding the warehouse size with maximum number of clusters
b. subtracting the warehouse size from the maximum number of clusters
c. dividing the warehouse size by the maximum number of clusters
d. multiplying the warehouse size by the maximum number of clusters
Ans: d. multiplying the warehouse size by the maximum number of clusters
Q.10 Snowflake is a data warehouse service offered as __
a. PaaS
b. SaaS
c. IaaS
d. XaaS
Ans: b. SaaS
Q.11 A __ is defined as an entity to which privileges can be granted or revoked.
a. Privilege
b. Role
c. User
d. Object
Ans: b. Role
Q.12 Which feature can be used to copy data quickly from Prod to Dev?
a. Snowpipe
b. Zero-copy cloning
c. Export-import
d. Time Travel
Ans: b. Zero-copy cloning
Q.13 A user can be assigned multiple roles.
a. False
b. True
Ans: b. True
Q.14 Data in Snowflake is organized by using?
a. Database
b. Schemas
c. Tables
d. All the options
Ans: d. All
Q.15 Access control in Snowflake combines aspects of which of the following models?
a. DAC and Super User Access control
b. Super User and Role-based Access control
c. Discretionary and Role-based Access control
d. Admin-based Access control
Ans: c. (abbr. as DAC and RAC)
Q.16 Each Snowflake account can be hosted on a different cloud platform.
a. True
b. False
Ans: a. True
Q.17 How can Tableau connect to Snowflake?
a. Using command-line clients
b. Using web-based UI
c. Using third-party connectors
d. Using ODBC and JDBC drivers
Ans: d. Using ODBC and JDBC drivers (ref: snowflake documentation)
Q.18 Which data load technique does Snowflake support?
a. Bulk load
b. Continuous load
c. Both of the above
Ans: c. Snowflake supports both
Q.19 Data from files staged in which of the following cloud platform can be loaded to a Snowflake account on Amazon?
a. Goodle Cloud storage
b. Snowflake Internal stages
c. Amazon S3
d. Microsoft Azure Blob storage
e. All the above
Ans: e. All options
Q.20 How can you use Snowflake across multiple regions?
a. Using multiple accounts located in a single region
b. Using multiple accounts located in multiple regions
c. Using a single account located in multiple regions
d. Using a single account located in a single region
Ans: b.
Q.21 Snowflake data warehouse is built on Big Data software platform ‘Hadoop’.
a. True
b. False
Ans: b. False
Q.22 Snowflake data warehouse can be run on which of the following?
a. public cloud infrastructure
b. Hybrid Cloud infrastructure
c. Private cloud infrastructure
Ans: a.
Q.23 Snowflake architecture is a __.
a. hybrid of shared-disk database architecture and shared-nothing database architecture
b. shared-nothing database architecture
c. shared-disk database architecture
Ans: a.
Q.24 The cloud services layer of Snowflake provides which of the following services?
a. Infrastructure Management
b. Authentication and Access Control
c. Query parsing and Optimization
d. All the above options
Ans: d
Q.25 Snowflake supports secure data sharing with other Snowflake accounts.
a. True
b. False
Ans: a
Q.26 Event notifications can be used to trigger Snowpipe data loads automatically in GCP.
a. True
b. False
Ans: b
Q.27 Snowflake software can be installed by a user in his system
a. True
b. False
Ans: b
Q.28 How does query processing happen in Snowflake?
a. Using virtual warehouse
b. In memory
c. On Cloud
d. All the above
Ans: a
Q.29 How does Snowflake handle database failover?
a. By replicating databases between Snowflake accounts
b. By synchronizing the database objects and stored data
c. By configuring database failover to one or more Snowflake accounts
d. None of the above
Ans: c