Snowflake Certification Practice Test: Data Engineering Skills Assessment

Welcome to your Snowflake Test-1

Name

Email

Phone

Q1. Data from Fail-Safe can only be accessed / restored by Snowflake Employees.

Select 1 option(s):

TRUE

FALSE

Q2. True or False: You cannot share a share.

Select 1 option(s):

False

True

Q3. If a table is cloned without COPY GRANTS option specified, then the clone object does not inherits any explicit access privileges granted on the original table, but does inherit any future grants defined for the table in the schema.

Select 1 option(s):

TRUE

FALSE

Q4. When data is loaded into Snowflake, Snowflake reorganizes that data into its internal optimized, compressed, columnar format.

Select 1 option(s):

TRUE

FALSE

Q5. The Cloning feature in Snowflake requires less storage because

Select 1 option(s):

The cloned data is constantly updated to synchronize with original table data

Only metadata is copied; no physical data is copied

Data is replicated to ensure integrity of data in the original table data

Q6. While cloning the entire database, the Internal (Snowflake) stages inside that database are also cloned

Select 1 option(s):

TRUE

FALSE

Q7. Snowflake Stages can be defined as either External or Internal.

Select 1 option(s):

TRUE

FALSE

Q8. Cloud storage providers must be linked to internal stage objects

Select 1 option(s):

TRUE

FALSE

Q9. Time travel is available for which table types?

Select 3 option(s):

Temporary

External

Transient

Permanent

Q10. Select all of the answers that describe Snowflake micro-partitions. Micro-partitions:

Select 1 option(s):

Will be updated as their row & column values are updated

Are the physical data files that comprise Snowflakes logical tables

Are written to a customer configured cloud storage location

Enable horizontal and vertical query pruning

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

Select 1 option(s):

Index definition

Cluster Keys/Reclustering

Distribution keys

Query Hints

Q12. Query execution is performed by which layers of Snowflake architecture

Select 1 option(s):

Storage Layer

Cloud Services Layer

Query Processing Layer

Q13. External Tokenization is not supported on which Cloud Platforms.

Select 1 option(s):

Above all cloud provide the required facility

Azure

AWS

GCP

Q14. True or false: You can point Snowflake at any S3 bucket to directly query the files in that bucket as long as the files are in Parquet or ORC format.

Select 1 option(s):

FALSE

TRUE

Q15. How often does Snowflake release new features?

Select 1 option(s):

Weekly

Yearly

Never

Monthly

Bi-Annually

Q16. Which file format option should be enabled while loading a JSON file to remove the outer most array structure and load the records in separate table rows

Select 1 option(s):

REMOVE_OUTER_ARRAY

ELIMINATE_OUTER_ARRAY

STRIP_OUTER_ARRAY

READ_INNER_ARRAY

Q17. Snowflake cannot be run on private cloud infrastructures (on-premises or hosted)

Select 1 option(s):

TRUE

FALSE

Q18. Snowflake compute costs depend on which of the following?

Select 2 option(s):

The number of rows returned in queries.

The amount of time warehouses have run.

The sizes of running warehouses.

The total number of warehouses in the account

Q19. Snowflake has which type of architecture

Select 1 option(s):

Shared Disk

Shared Data & Multi Cluster

None of the above

Shared Nothing

Q20. Snowflake data warehouse is built on top of Hadoop Big Data Software Platform

Select 1 option(s):

TRUE

FALSE

Q21. Cloning the table does not include the load history of the source table, and hence the data files that were loaded in source table can be loaded again into its clone tables

Select 1 option(s):

FALSE

TRUE

Q22. The FLATTEN command will parse nested objects into separate rows. One version of the FLATTEN command uses a join and the other uses an object keyword. Select the two words that represent the options used with the FLATTEN command

Select 2 option(s):

SIDEWAYS

TABLE

LATERAL

SCHEMATA

Q23. Cloud Services layer of Snowflake provide which all functionalities

Select 3 option(s):

Infra Management

Authentication

Database Storage

Metadata Management

Query Processing

Q24. The new feature data market place and Preview App is available for GCP accounts as well.

Select 1 option(s):

FALSE

TRUE

Q25. Which security feature is supported in Snowflake?

Select 1 option(s):

All of the above

Multi-Factor Authentication

Tri-Secret Secure Encryption

Role-Based Access Control

Q26. Which of the following database objects can be cloned in Snowflake?

Select 1 option(s):

All of the above

Schemas

Tables

Databases

Q27. Snowflake is supported on which cloud providers

Select 3 option(s):

GCP

AWS

Alibaba Cloud

IBM Cloud

Azure

Q28. Not all Snowflake Editions have Elastic Data Warehousing. Check all Snowflake editions that have Elastic Data Warehousing enabled

Select 3 option(s):

Enterprise Edition

Virtual Private Snowflake

Standard Edition

Premium Edition

Business Critical Edition (formerly Enterprise for Sensitive Data)

Q29. What makes a Partner Connect Partner different from other partners?

Select 4 option(s):

Includes automated role, user and staging database set up

Requires Enterprise Edition

Can be connected from within the WebUI

Includes a streamlined Partner Trial Account Signup

Can be connected to Snowflake using a streamlined wizard

Q30. When data is staged to an internal stage using PUT command, the data is encrypted on client machine

Select 1 option(s):

FALSE

TRUE

Q31. Scaling down is a automated process. (e.g. X-Large to Large)

Select 1 option(s):

FALSE

TRUE

Q32. The number of load operations that run in parallel cannot exceed the number of data files to be loaded

Select 1 option(s):

FALSE

TRUE

Q33. Different editions of snowflake Instances require separate accounts

Select 1 option(s):

FALSE

TRUE

Q34. True or false: The Query Profiler view is only available for completed queries.

Select 1 option(s):

FALSE

TRUE

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

Select 1 option(s):

Indexing

B-Tree

Map Reduce

Pruning

Q36. Which out of below you do not specify while setting up a snowflake account

Select 1 option(s):

Snowflake Edition

Availability Zone

Cloud Infrastructure Provider

Geographic Deployment Region

Q37. Providers can list data on the Marketplace without contacting Snowflake

Select 1 option(s):

TRUE

FALSE

Q38. Which of the following conditions are required for sharing data in Snowflake?

Note – Here Data Sharing being referred is not via Data Replication.

Select 2 option(s):

Data providers with ACCOUNTADMIN role can set up shares

Each data share must contain a single database

Secure views are not required when query performance is priority

Consumer accounts must be in same Snowflake region as the provider account

Q39. To configure an External Stage you need to define the stage object in Snowflake. You also need two additional components. What are they?

Select 2 option(s):

Stage Admin Password

Cloud storage location (e.g. S3 Bucket)

Stage Admin Username

Cloud access credentials (e.g. IAM User and Policy)

Snowflake External Stage Password Authentication Certificate

Q40. Out of below four options, which options require a running warehouse when retrieving data from them?

Select 1 option(s):

Results Cache

Local Disk Cache

Warehouse Cache

Metadata Cache

Q41. Check all true statements about Fail-safe:

Select 2 option(s):

The data stored as part of fail-safe is part of storage costs charged to customers

Fail-safe is not available for tables that have Time Travel.

Fail-safe is a reliable way to create Dev/Test/QA and other environments

Only a Snowflake employee can recover data from fail-safe storage

Q42. Scaling out is an automated process (e.g. Min clusters to max clusters)

Select 1 option(s):

TRUE

FALSE

Q43. With Snowflake, the customer needs to perform hardware maintenance, upgrades or regular patches

Select 1 option(s):

TRUE

FALSE

Q44. Which of these are Snowflake table types?

Select 4 option(s):

External

Temporary

Permanent

Materialized

Transient

Secure

Q45. What command (partial) is used to convert a SECURE VIEW to a “regular“ VIEW?

Select 1 option(s):

UNSET SECURE

SET View_Type=Regular

SET SECURE=False

SET INSECURE

Q46. Each Snowflake account comes with two shared databases. One is a set of sample data and the other contains Account Usage information. Check all true statements about these shared databases.

Select 3 option(s):

SNOWFLAKE_SAMPLE_DATA contains a schema called ACCOUNT_USAGE

SNOWFLAKE contains a schema called ACCOUNT_USAGE

ACCOUNT USAGE is a schema filled with secure views

SNOWFLAKE contains a table called ACCOUNT_USAGE

ACCOUNT_USAGE is a schema filled with external tables

SNOWFLAKE_SAMPLE_DATA contains several schemas from TPC (tpc.org)

Q47. Snowflake on GCP is not available in which region currently (as of Year 2020)

Select 1 option(s):

North America

Asia Pacific

Europe

Q48. When adding Consumers to Outbound Shares, what types of Consumer Accounts can be selected?

Select 2 option(s):

Full

GCP

Azure

AWS

Reader

Q49. For databases, schemas, and tables, a clone does not contribute to the overall data storage until operations are performed on the clone that modify existing data or add new data

Select 1 option(s):

TRUE

FALSE

Q50. Which of the following terms are associated with the Cloud Services Layer?

Select 3 option(s):

Query Processing

Query Design

Query Planning

Query Compilation

Query Optimization

Q51. Which of the below is role is automatically granted to every user and role in the account

Select 1 option(s):

Sysadmin

Developer

Useradmin

Public

Q52. Which of the following are types of caching use by Snowflake? Select all that apply

Select 3 option(s):

Warehouse caching

Index Caching

Metadata caching

Query result caching

Q53. With Time Travel, a Snowflake administrator can, analyze data manipulation over specified periods of time

Select 1 option(s):

TRUE

FALSE

Q54. Scaling up is a manual process. (e.g. Small to Medium)

Select 1 option(s):

FALSE

TRUE

Q55. Providers can prep data for the Marketplace but will need Snowflake‘s guidance and approval at some point

Select 1 option(s):

FALSE

TRUE

Q56. The columns in the query history include the QueryID, the SQL Text, the Warehouse name, the Warehouse Size, the Session ID and others. Which column is a good indicator of whether a Warehouse was used (and Compute costs incurred) by a query?

Select 1 option(s):

QueryID

Warehouse Size

Warehouse Name

Session ID

SQL Text

Q57. True or false: Snowflake caches are automatically invalidated if the underlying data changes.

Select 1 option(s):

FALSE

TRUE

Q58. If a table is cloned with COPY GRANTS option specified, then the clone object inherits any explicit access privileges granted on the original table, but does not inherit any future grants defined for the table in the schema

Select 1 option(s):

FALSE

TRUE

Q59. Scaling a warehouse OUT will increase the number of servers. (e.g. Min to Max)

Select 1 option(s):

TRUE

FALSE

Q60. PUT Command can be executed from Snowflake Web UI

Select 1 option(s):

FALSE

TRUE

Q61. What is the maximum number of consumer accounts that can be added to a Share object?

Select 1 option(s):

One

Unlimited

100

10

Q62. Which of the following statements are true about Snowflake Data sharing? Select all that apply.

Select 2 option(s):

Data Sharing is integrated with role-based access controls

You don‘t need a Snowflake Virtual Warehouse to query shared data

Consumers can query shared tables in the same query as their own tables

Producers can share data to other databases such as Postgres and MySQL

Q63. Data can be shared READ-ONLY across Snowflake accounts and Shared Data can also be cloned

Select 1 option(s):

FALSE

TRUE

Q64. To be listed on the Marketplace, data must meet few criteria. Check all the options that are applicable –

Select 3 option(s):

Real (i.e. not sample data)

Compliant according to PCI, HIPPA and other standards

If sample data, over 2GBs

Legally Distributable

Q65. The following performance optimizing query methods are supported by Snowflake:

Select 2 option(s):

Retrieving results of previous query from cache

B-tree type indexes

Caching techniques