Snowflake Certification Practice Test: 65 Essential Questions

Welcome to your Snowflake Test-16

Name

Phone

Q1. Which stage is allocated to a user?

Select 1 option(s):

External names stage

Internal user stage

Internal named stage

Internal table stage

Q2. Which query will require compute (Virtual Warehouse)? Consider table created as – CREATE or replace TABLE T1 ( ID number(2), Name varchar(20), ID number (11,2) );

Select 3 option(s):

Q3. Resizing a warehouse can be completed at any time, even when running

Select 1 option(s):

TRUE

FALSE

Q4. When there is new load of data in Snowflake, Snowflake automatically analyzes and compresses data into table.

Select 1 option(s):

TRUE

FALSE

Q5. What is default size of unload file?

Select 1 option(s):

16 MB

100 MB

10 MB

32 MB

Q6. Snowflake black list some certain IPs by default to ensure that customer is getting highest level of Network security. (TRUE / FALSE)

Select 1 option(s):

TRUE

FALSE

Q7. What are the three Snowflake Stage types? (Select 3)

Select 3 option(s):

Secure

User

Permanent

Named

Table

Materialized

Q8. Virtual Warehouse in Snowflake refers to

Select 1 option(s):

Virtual Storage

Database

Compute Engine

Data Warehouse

Q9. MFA is automatically enabled for all the users. Please select the true statement.

Select 1 option(s):

MFA is available for all the users by default.

MFA is only enabled for ACCOUNTADMIN by default. ACCOUNTADMIN can enable it for other users.

Q10. Semi Structured data can be accessed: (Select 3)

Select 3 option(s):

In files on an AWS EC2 server

In a permanent table using the variant data type

In files in an external stage

In files in an on-prem file server

In files in a internal stage

Q11. Snowflake offers rich set of drivers and connectors to connect with external applications. Select the Connectors from the list. (Choose 3)

Select 3 option(s):

Node.js

Spark

Python

JDBC

Kafka

Q12. Snowflake follows the Staged release process for new releases. How many days it take to normally to complete all the stages of the staged release.

Select 1 option(s):

3 days

1 day

2 days

7 days

Q13. Which statements accurately describes the Snowflake Data Sharing?

Select 3 option(s):

A share can‘t be cloned by Consumer

A share can contain more than one database

When creating views in a share, secured views are required

Data sharing is only supported between accounts in the same snowflake region

Q14. Decreasing the size of a running warehouse removes servers from the warehouse. When the servers are removed, the cache associated with the servers is dropped.

Select 1 option(s):

TRUE

FALSE

Q15. John has table T1 with Time-Travel retention time period set to 20 days. He increases the retention period by 10 days to make it 30 days. What impacts will happen on Table data. Please select 2.

Select 2 option(s):

Changes will be ONLY effective for new data coming to Time-Travel

No impact on any data that is 20 days older and has already moved into Fail-safe

Data that have moved to Fail-safe after 20 days will now be available in Time-Travel for additional 10 days

No impact on existing data which moved from table to Time-Travel before the increase of Time-Travel retention period

Data that would have been removed after 20 days is now retained for an additional 10 days before moving into Fail-safe

Q16. The Cloning feature in Snowflake requires less storage because:

Select 1 option(s):

Only metadata is copied; no physical data is copied

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

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

Q17. FORCE option is used to load all files, ignoring load metadata if it exists. (TRUE / FALSE)

Select 1 option(s):

TRUE

FALSE

Q18. Which types of stages are automatically available in Snowflake and do not need to be created or configured?

Select 2 option(s):

Table

Named Internal

User

Named External

Q19. Which SQL statement will suspend a running Warehouse MY_WAREHOUSE?

Select 1 option(s):

SUSPEND WAREHOUSE MY_WAREHOUSE;

DROP WAREHOUSE MY_WAREHOUSE;

ALTER WAREHOUSE MY_WAREHOUSE SUSPEND;

ALTER WAREHOUSE MY_WAREHOUSE SET AUTO_SUSPEND = ‘TRUE‘;

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

Select 1 option(s):

FALSE

TRUE

Q21. Scaling a Warehouse OUT will increase the number of clusters (e.g., Min to Max)

Select 1 option(s):

FALSE

TRUE

Q22. What all commands will you use to unload data from your Snowflake table to your local file systems?

Select 1 option(s):

COPY INTO followed by PUT command

COPY INTO command followed by GET command

Only COPY INTO command

Only GET command

Q23. Which are the different ways a user can get permissions to a database object?

Select 3 option(s):

The user is granted a role that inherits another role with permission to the object

Grant the role with the permissions on the database object to the user

Grant the user permissions to the object

The user creates the objects and the current role becomes the owner of the object

Q24. Which of the following is a common case for Cloning in Snowflake? (Select all that apply)

Select 3 option(s):

Agile Release and Development

“Point in Time“ Snapshot

Data Encryption Protection

Data Life Cycle Management

Q25. How many files each server in a cluster can process in parallel?

Select 1 option(s):

4 Files

Depends on how large is the file. If file is 32 MB in size, the server can process 4 such files in parallel

1 File

16 Files

8 Files

Q26. Please choose all the securable objects from the given options.

Select 5 option(s):

EXTERNAL TABLE

STORED PROCEDURE

SCHEMA

DATABASE

UDF

Unattempted

Q27. Which objects are securable objects in Snowflake?

Select 4 option(s):

Table

Warehouse

Database

File Format

Unattempted

Q28. Time Travel cannot be disabled for an account. (True / false)

Select 1 option(s):

TRUE

FALSE

Q29. Can you share data with multiple consumers with row based access control?

Select 1 option(s):

YES

Q30. SQL Clause which helps defining the clustering key:

Select 1 option(s):

CLUSTER BY

CLUSTER ON

CLUSTERING BY

CLUSERTING ON

Q31. What type of Privilege Data Consumer should have to administer shares

Select 1 option(s):

SHOW SHARE

IMPORT SHARES

EXPORT SHARE

LIST SHARE

Q32. At what places can you specify File Format?

Select 3 option(s):

As part of Internal Table stage

All of these

As part of a table definition

As part of a named stage or pipe definition

In the COPY INTO command

Q33. Which role at least should have MFA configured?

Select 1 option(s):

PUBLIC

SECURITYADMIN

SYSADMIN

ACCOUNTADMIN

Q34. What are the security layers that Snowflake takes care of?

Select 4 option(s):

Data Protection

Authentication

Access

Infrastructure

Authorization

Q35. Snowflake decouples Storage and Compute. In case of increase in Compute usages, Storage usage also increases..

Select 1 option(s):

TRUE

FALSE

Q36. Objects that are dropped from a shared database and then recreated with the same name are not immediately available in the share; you must execute grant usage on the objects to make them available

Select 1 option(s):

FALSE

TRUE

Q37. Which of the following are unique objects introduced by Snowflake?

Select 3 option(s):

STAGE

TABLE

PIPE

Q38. Which command will help you the current permissions on a Schema?

Select 1 option(s):

SHOW GRANTS ON SCHEMA .;

SHOW ALL PREIVILEGE ON SCHEMA .;

SHOW ROLES ON SCHEMA .;

SHOW GRANTS OF SCHEMA .;

Q39. Which parameter does help in loading files whose metadata has expired?

Select 1 option(s):

set LAST_MODIFIED_DATE to within 64 days

set LOAD_UNCERTAIN_FILES to TRUE

Set LAST_MODIFIED_DATE to more than 64 days

set LOAD_EXPIRED_FILES to TRUE

Q40. When should you avoid enabling AUTO_SUSPEND?

Select 2 option(s):

You have a heavy, steady workload for the warehouse.

You should always enable AUTO_SUSPEND to save the compute costs.

You require the warehouse to be available with no delay or lag time

Q41. You have a LARGE sized warehouse ‘MY_WAREHOUSE‘. You want to change the size to SMALL. Which SQL statement will help you to change the size of warehouse?

Select 1 option(s):

Q42. When a database or schema is cloned. What object is not cloned?

Select 1 option(s):

Stored Procedures

Internal Stages

Pipes

Sequences

Internal Named Stages

Q43. Which key concepts should be considered when loading data into Snowflake?

Select 1 option(s):

Transformation and error validation

File Format

All of these

Stage Object

Q44. What are the types of Caches? (Select 2)

Select 2 option(s):

Metadata Cache

History Cache

Results Cache

Storage Cache

Q45. Which role is inherited to every other role in the account?

Select 1 option(s):

PUBLIC ROLE

PREFERED ROLE

CONTROL ROLE

DEFAULT ROLE

STANDARD ROLE

Q46. Which SQL statements will need a running Warehouse and consume credit? Consider table created as – CREATE OR REPLACE TABLE T1 ( ID number(2), Name varchar(20), Salary number (11,2) );

Select 1 option(s):

Q47. How does Snowflake provide continuous availability?

Select 3 option(s):

Customer has to backup the data locally out of cloud

Fail Safe Storage

Time Travel Storage

Snowflake synchronizes data across availability zones

Q48. How is the most effective way to test if clustering a table helped performance?

Select 1 option(s):

Use SYSTEM$CLUSTERING_INFORMATION. Check the average_depth

Use the SYSTEM$CLUSTERING_DEPTH and check the depth of each column

Run a sample query before clustering and after to compare the results

Use SYSTEM$CLUSTERING_INFORMATION. Check the average_overlaps

Use SYSTEM$CLUSTERING_INFORMATION. Check the total_constant_partition_count

Q49. Snowflake is a packaged software offering that can be installed by a user.

Select 1 option(s):

FALSE

TRUE

Q50. John wants to create a multi-cluster warehouse and wants to make sure that the virtual warehouse starts the additional clusters only if the system estimates there‘s enough query load to keep the cluster busy for at least 6 minutes. How should he configure the Warehouse?

Select 1 option(s):

Set the SCALING POLICY as STANDARD

Snowflake takes care of this automatically so, John does not have to worry about it

Set the SCALING POLICY as ECONOMY

Configure as SCALE-MAX so that the warehouse is always using maximum number of specified clusters

Q51. The compute resource used by Snowflake for data loading jobs can be provided by:

Select 2 option(s):

Hardware provisioned by user directly from cloud providers

Snowflake managed service

User managed virtual warehouse

Q52. Which are the correct statements about TASKS?

Select 3 option(s):

it can be used with STREAMS

It is used for Change Data Capture (CDC)

TASKS is used to scheduled SQL execution

Can not be triggered manually

TASKS is used to identify and act on changed table records

Q53. Each share contains a single database, and all other objects included in the share must be from this same database.

Select 1 option(s):

TRUE

FALSE

Q54. If you find a data-related tool that is not listed as part of the Snowflake ecosystem, what industry standard options could you check for as a way to easily connect to Snowflake? (Select 2)

Select 2 option(s):

Check to see if there is a petition in the community to create a driver

Check to see if the tool can connect to other solutions via ODBC

Check to see if you can develop a driver and put it on GitHub

Check to see if the tool can connect to other solutions via JDBC

Q55. When choosing a geographic deployment region, what factors might an enrollee consider?

Select 2 option(s):

End-user perceptions of glamorous or trendy geographic locations

Proximity to the point of service

Number of availability zones within a region

Additional fees charged for regions with geo-political unrest

Q56. A Virtual Warehouse can‘t access data loaded in the table using different warehouse.

Select 1 option(s):

TRUE

FALSE

Q57. Which privilege is needed to be able to monitor a warehouse?

Select 1 option(s):

USAGE

MODIFY

MONITOR

OPERATE

Q58. SQL Clause which helps defining the clustering key:

Select 1 option(s):

CLUSTER ON

CLUSTER BY

CLUSTERING BY

CLUSERTING ON

Q59. Once the Snowflake Account is provisioned, user can access Snowflake using following methods:

Select 4 option(s):

Any client application connected via JDBC or ODBC

Any 3rd-party partner that can connect to Snowflake

SnowSQL, the Snowflake command line client

Browser-based web interface

Unattempted

Q60. Who pays for the compute usage of the Reader account?

Select 1 option(s):

Consumer

Provider

Q61. Which of these can access database objects and issue SQL statements

Select 1 option(s):

User-Defined Function

Both

Stored Procedure

Q62. New or modified data in tables in a share are immediately not available to all consumers who have created a database from a share

Select 1 option(s):

FALSE

TRUE

Q63. How can you create a “Super-User“ or “Super-Role“ in Snowflake who can bypass all the authorization checks?

Select 1 option(s):

There is no concept of SUPER-ROLE or SUPER-USER in Snowflake

Contact Snowflake personnel to create a Super-Role or Super-User for your account

ACCOUNTADMIN role is same as Super-Role

CREATE ROLE SUPER_ROLE;

Q64. If you click on “History“ in the ribbon, how far back in time are you able to view history?

Select 1 option(s):

365 days

7days

30 days

24 hours

14 days

Q65. How can you create a user in Snowflake without password?

Select 1 option(s):

Using SQL Command - CREATE USER

Using Salesforce Web interface

User creation without password is not possible