Snowflake Test-10

Welcome to your Snowflake Test-10

Name

Phone

Q1. John wants to create a warehouse which should not start immediately. Which property will him to create a warehouse in suspended mode.

Select 1 option(s):

AUTO_SUSPEND = INITIAL

AUTO_START = FALSE

INITIALLY_SUSPENDED = TRUE

INITIATE = FALSE

Q2. Which are the types of Virtual Warehouses in Snowflake?

Select 2 option(s):

Premier

Standard

Multi-Cluster

Enterprise

Q3. Auto-suspend and auto-resume apply only to the entire warehouse and not to the individual clusters in the warehouse.

Select 1 option(s):

TRUE

FALSE

Q4. Scaling up can be configured as automated process.

Select 1 option(s):

TRUE

FALSE

Q5. When configuring a Warehouse using a Snowflake edition that has Elastic Data Warehousing enabled, what facets or components will you need to configure that are not needed in accounts where Elastic Data Warehousing is not enabled. (Choose two)

Select 2 option(s):

Minimum and Maximum Servers

Scaling Policy

Auto-Suspend

Minimum and Maximum Clusters

Q6. Select the Snowflake edition that automatic encryptions all the data.?

Select 1 option(s):

Enterprise

Business Critical

All the editions

VPS

Standard

Q7. John created a Database and set the DATA_RETENTION_TIME_IN_DAYS as 30 days, but he did not set the DATA_RETENTION_TIME_IN_DAYS in one of the table ‘T1‘. After 5 days, he accidently dropped table ‘T1‘. Will he able to recover the table T1?

Select 1 option(s):

John should call Snowflake Support to recover the table from Fail-Safe.

No, John cant recover the dropped table T1 because he didn‘t set DATA_RETENTION_TIME_IN_DAYS for Table T1

John can recover the table T1 after 30 days

Yes, as the retention period is specified at database level

Q8. When a warehouse is resized, which queries make use of the new size?

Select 1 option(s):

Both current and subsequent queries

Only subsequent queries

Only currently running queries

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

Select 1 option(s):

TRUE

FALSE

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

Select 1 option(s):

MONITOR

USAGE

MODIFY

OPERATE

Q11. How to choose the right size of warehouse to achieve the best results based on the Query processing?

Select 1 option(s):

Execute varieties of queries on same warehouse to achieve the best result

Execute relatively homogenous queries on the same warehouse

Q12. Which Snowflake editions have maximum 90 days of Time-Travel retention period?

Select 3 option(s):

All the editions

Standard

Business Critical

VPS

Enterprise

Q13. Select the right SQL statement which creates a Large Sized Warehouse and can spin new clusters if needed up to 5 and auto suspend in 10 minutes if not in use.

Select 1 option(s):

CREATE WAREHOUSE MY_WAREHOUSE WITH WAREHOUSE_SIZE = ‘XLARGE‘ WAREHOUSE_TYPE = ‘STANDARD‘ AUTO_SUSPEND = 600 AUTO_RESUME = TRUE MIN_CLUSTER_COUNT = 1 MAX_CLUSTER_COUNT = 5 SCALING_POLICY = ‘STANDARD‘;

CREATE WAREHOUSE MY_WAREHOUSE WITH WAREHOUSE_SIZE = ‘LARGE‘ WAREHOUSE_TYPE = ‘STANDARD‘ AUTO_SUSPEND = NULL AUTO_RESUME = TRUE MIN_CLUSTER_COUNT = 1 MAX_CLUSTER_COUNT = 5 SCALING_POLICY = ‘STANDARD‘;

CREATE WAREHOUSE MY_WAREHOUSE WITH WAREHOUSE_SIZE = ‘LARGE‘ WAREHOUSE_TYPE = ‘STANDARD‘ AUTO_SUSPEND = 600 AUTO_RESUME = TRUE MIN_CLUSTER_COUNT = 1 MAX_CLUSTER_COUNT = 5 SCALING_POLICY = ‘STANDARD‘;

CREATE WAREHOUSE MY_WAREHOUSE WITH WAREHOUSE_SIZE = ‘LARGE‘ WAREHOUSE_TYPE = ‘STANDARD‘ AUTO_SUSPEND = 10 AUTO_RESUME = TRUE MIN_CLUSTER_COUNT = 1 MAX_CLUSTER_COUNT = 5 SCALING_POLICY = ‘STANDARD‘;

Q14. Which is the correct syntax to disable fail safe on a table?

Select 1 option(s):

By default, fail safe is disabled on a table.

ALTER TABLE SET FAILSAFE_DAYS = 0;

ALTER TABLE SET ENABLE_FAILSAFE = FALSE;

Fail safe can not be disabled on a table.

ALTER TABLE DROP FAILSAFE;

Q15. Scaling Out is an automated process (e.g., Min clusters to max clusters)

Select 1 option(s):

FALSE

TRUE

Q16. Is there any cost benefit of suspending a warehouse in less than 60 seconds?

Select 1 option(s):

YES

Q17. What is the minimum billing charge for provisioning a warehouse?

Select 1 option(s):

1 Second

60 Minutes

1 Minute

No charge

Q18. Virtual Warehouse in Snowflake refers to

Select 1 option(s):

Database

Virtual Storage

Data Warehouse

Compute Engine

Q19. Generally, what is the size of a micro-partition in compresses format?

Select 1 option(s):

500 MB

16 MB

16 GB

50 MB

Q20. Which all actions can you perform in a defined period of time using Time Travel?

Select 3 option(s):

Restores tables, schemas and databases that have been dropped

Create clones of tables, schemas and databases

Query data in the past

Restore tables, schemas but not databases that have been dropped

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

Select 1 option(s):

FALSE

TRUE

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

Select 1 option(s):

Tables

File Formats

Databases

All the editions

Schemas

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

Select 1 option(s):

TRUE

FALSE

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

Data Life Cycle Management

Data Encryption Protection

“Point in Time“ Snapshot

Q25. Which SQL command will give the list of all the warehouses in an account?

Select 1 option(s):

SHOW WAREHOUSE;

LIST WAREHOUSE;

SHOW WAREHOUSES;

DISPLAY WAREHOUSE;

LIST WAREHOUSES;

Q26. Increasing the size of a warehouse always improves data loading performance.

Select 1 option(s):

FALSE

TRUE

Q27. What are the key considerations for using warehouse effectively and efficiently?

Select 2 option(s):

Experiment with different types of queries and different warehouse sizes to determine the combinations that best meet your specific query needs and workload.

Start with smallest warehouse always and Scale up if the performance is poor

Snowflake utilizes per-hour billing so, customer doesn‘t have to worry about the warehouse size.

Dont focus on warehouse size. Snowflake utilizes per-second billing, so you can run larger warehouses (Large, X-Large, 2X-Large, etc.) and simply suspend them when not in use

Q28. 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

User managed virtual warehouse

Snowflake managed service

Q29. 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 ECONOMY

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

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

Set the SCALING POLICY as STANDARD

Q30. You want a list of all the warehouses with name starting from DEMO. Select the correct SQL statement.

Select 1 option(s):

LIST WAREHOUSES LIKE ‘MO‘;

SHOW WAREHOUSES LIKE ‘DEMO%‘;

SHOW WAREHOUSE LIKE ‘MO‘;

SHOW WAREHOUSES LIKE ‘MO‘;

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

Select 1 option(s):

TRUE

FALSE

Q32. John wants to create a Warehouse which can auto resume whenever there is a new load / query to execute. How should he configure the warehouse?

Select 1 option(s):

AUTO_SUSPEND = TRUE

AUTO_RESUME = 1

AUTO_RESUME = TRUE

It is always manual and cant be automated.

Q33. 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

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

Only metadata is copied; no physical data is copied

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

Select 1 option(s):

Provider

Consumer

Q35. A user can connect Snowflake in multiple ways. Please select

Select 4 option(s):

Command line clients (e.g. SnowSQL)

Any client application connected via JDBC or ODBC

Any 3rd-party partner that can connect to Snowflake

Browser-based web interface

Unattempted

Q36. A Snowflake customer is responsible for all the maintenance and services.

Select 1 option(s):

TRUE

FALSE

Q37. Which of the following are performed by the Cloud Services layer? (Select 4)

Select 4 option(s):

Availability Zone Management

Metadata Management

Metadata Storage

Data Security

User Authentication

Q38. Which of these must return a value?

Select 1 option(s):

Both

User-Defined Function

Stored Procedure

Q39. Can you have a database overlap across two Snowflake account?

Select 1 option(s):

Yes

Q40. Choose the right hierarchy of Snowflake objects from the given options.

Select 1 option(s):

ACCOUNT > SCHEMA > DATABASE > TABLE

ACCOUNT > DATABASE > SCHEMA > TABLE

ACCOUNT > STAGE > DATABASE > SCHEMA > TABLE

ACCOUNT > DATABASE > STAGE > SCHEMA

Q41. Snowflake is best suited for OLAP solutions.

Select 1 option(s):

TRUE

FALSE

Q42. The best method to assist pruning on a large table is to:

Select 1 option(s):

Define a HASH TABLE for the table

Define a PARTITIONING KEY on the table

Define a CLUSTER KEY for the table

Create a CLUSTERED INDEX on the table

Create a DENSE INDEX on the table

Q43. 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

Use SYSTEM$CLUSTERING_INFORMATION. Check the average_overlaps

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

Use SYSTEM$CLUSTERING_INFORMATION. Check the total_constant_partition_count

Q44. Which command will return information about the current database?

Select 1 option(s):

Q45. Snowflake Resource Monitor allows administrators to set thresholds and triggers to track credit usage. What methods are most effective for resource monitoring? (Check all that apply).

Select 3 option(s):

Setting quota thresholds for trigger actions and notifications

Tracking consumption on an hourly basis

Tracking and controlling credit consumption on a monthly basis

Control global monthly credit usage for an account

Q46. Which type of view is most like a table?

Select 1 option(s):

Secure

Materialized

External

Standard

Q47. The BI group is complaining about their queries taking too long to run. Checking the virtual warehouse information shows the queued time is pretty high. What is the best way to fix this issue?

Select 1 option(s):

Provide a virtual warehouse for every user in the group

STATEMENT_QUEUED_TIMEOUT_IN_SECONDS parameter to a low value to cancel those queries if they get in the queue

Increase the virtual warehouse MAXCONCURRENCY_LEVEL parameter

Increase the virtual warehouse MAX_CLUSTER_COUNT property

Increase the size of the virtual warehouse

Determine which users have the high priority queries and set the other users

Q48. 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):

Q49. SQL Clause which helps defining the clustering key:

Select 1 option(s):

CLUSTER ON

CLUSTER BY

CLUSERTING ON

CLUSTERING BY

Q50. Which layer is responsible for Data Security and Authentication?

Select 1 option(s):

Compute Layer

Storage Layer

Cloud Agnostic Layer

Cloud Services

Q51. Who can create shares?

Select 2 option(s):

ROLE with CREATE SHARES global Privilege

ACCOUNTADMIN

Unattempted

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

Select 1 option(s):

30 days

14 days

24 hours

365 days

7days

Q53. Multi-cluster warehouse credit billing is based on which factors? (Select 2)

Select 2 option(s):

Number of servers per cluster

Number of Clusters

Number of users

Number of queries it processes per hours

Q54. What is the maximum Time-Travel retention period of Standard Edition?

Select 1 option(s):

1 day

0 days

90 days

7 days

Q55. Zero Copy Cloning allows users to have multiple copies of your data without the additional cost of storage usually associated with replicating data. Which other statements about the Cloning features in Snowflake are True?

Select 3 option(s):

Clone is a point in time version of the table data as of the time the clone was made

The clone is a pointer to the original table data

Cloning is an efficient and cost effective approach for code migration for Agile Release Management

Any new record in the parent table gets available in the cloned table

Q56. When should you avoid enabling AUTO_SUSPEND?

Select 2 option(s):

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

You have a heavy, steady workload for the warehouse.

You should always enable AUTO_SUSPEND to save the compute costs.

Q57. John has a same query which runs for around 40 minutes every hour. Most of the time the data in the table remain same. What could be best option for John to keep warehouse running or AUTO_SUSPEND?

Select 1 option(s):

John should set AUTO_SUSPEND to 40 minutes

John doesn‘t have to set AUTO_SUSPEND. Snowflake will take care of suspension as needed.

John should not set AUTO_SUSPEND

John should set AUTO_SUSPEND to 10 minutes

Q58. Which are the correct statements for a Virtual Warehouse?

Select 3 option(s):

Standard Virtual Warehouse can Scale-Out

Warehouse are Sized in “t-shirt“ sizing

Each larger size is double the preceding, in both VMs in the cluster and in Snowflake credits consumed

Size determines the number of servers that comprise each cluster in a ware

Q59. How much is the Time-Travel retention period of Transient Table?

Select 1 option(s):

1 day

0 days

7 days

90 days

Q60. Which are the correct statements about Snowflake data Storage?

Select 3 option(s):

Automatic Micro-partitioning

Hybrid Columnar Storage

Encryption on demand

Natural data clustering and optimization

Q61. Compute can be scaled up, down, out, or in and there is no effect on storage used.

Select 1 option(s):

TRUE

FALSE

Q62. Monica is a new Snowflake user with ACCOUNTADMIN role. She wants to create a warehouse which can scale out if needed. She tried to create the warehouse using UI but she is not able to find the options to set Minimum and Maximum Clusters. What could be the issue?

Select 1 option(s):

She doesn‘t have enough privilege to create a warehouse

She should use SQL command to create the Warehouse with Minimum and Maximum clusters

She should ALTER any existing warehouse to set the Maximum and Minimum clusters

She is using STANDARD Snowflake edition. Multi-Cluster is not available in STANDARD edition.

Q63. A multi-cluster warehouse is using an ECONOMY scaling policy, how long will queries back up in the queue before another cluster is started?

Select 1 option(s):

1 minute

It will start immediately

8 Minutes

6 Minutes

2 Minutes

Q64. What action causes a Warehouse‘s cache to be purged?

Select 1 option(s):

Suspending the warehouse.

A change to the Metadata Cache size.

The passing of 24 hours.

Resuming the warehouse.

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

Select 1 option(s):

Internal Named Stages

Sequences

Stored Procedures

Pipes

Internal Stages