Snowflake Practice Quiz: 65 Technical Interview Questions

Welcome to your Snowflake Test-11

Name

Phone

Q1. If a server in warehouse cluster runs for 64 seconds, shuts down, and then restarts and runs for less than 60 seconds, for how many seconds it will be billed?

Select 1 option(s):

64 Seconds

120 Seconds

4 Seconds

124 Seconds

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

Q3. Which SQL statement will not consume Warehouse credit?

Select 4 option(s):

SHOW WAREHOUSES;

ALTER WAREHOUSE MY_WAREHOUSE SET WAREHOUSE_SIZE = “SMALL“;

SHOW WAREHOUSE LIKE ‘MO‘;

DROP WAREHOUSE MY_WAREHOUSE;

Unattempted

Q4. Snowflake data storage costs are calculated based on: (Select 2)

Select 2 option(s):

Uncompressed Size

Amount Stored on First Day of Month

Compressed Size

Amount Stored on Last Day of Month

Amount Stored - Daily Average

Q5. If you are ACCOUNTADMIN, you can query and recover data from Fail-safe without the help of Snowflake support. (TRUE/FALSE)

Select 1 option(s):

TRUE

FALSE

Q6. A multi-cluster virtual warehouse is Auto-Scale when

Select 2 option(s):

MIN_CLUSTER_COUNT = 1 MAX_CLUSTER_COUNT = 4

MIN_CLUSTER_COUNT = 3 MAX_CLUSTER_COUNT = 3

Minimum number of clusters and Maximum number of clusters are same and must be specified with a value of more than 1.

Minimum and Maximum number of clusters are specified differently.

Q7. Two Virtual Warehouses can access the same data at the same time without causing contention issues.

Select 1 option(s):

TRUE

FALSE

Q8. Who owns and manages the cloud storage layer hosted on Cloud Providers?

Select 1 option(s):

Customer

Cloud Provider

Snowflake

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

Size

Warehouse Name

Session ID

Q10. John has table T1 with Time-Travel retention time period set to 20 days. He decreases the retention period by 15 days to make it 5 days. What impacts will happen on Table data. Please select 2.

Select 2 option(s):

The data which was in Time Travel for more than 5 days will move to Fail-safe by Snowflake by background process

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

No impact to existing Time Travel data. That will still complete the longer period of 20 days before going to Fail-safe

The data that is currently in Time Travel and if the data is still within the new shorter period, it remains in Time Travel

Q11. Monica is an admin and wants to see the usage of Fail-Safe. How can she get details on Fail-Safe usage?

Select 1 option(s):

Fail Safe usage details are never available to customer

None of these

Monica should contact Snowflake support

Admins can view Fail-safe use in the Snowflake Web UI under Account > Billing & Usage

Q12. Which Snowflake Object is a named wrapper around a cluster of servers with CPU, memory, and disk

Select 1 option(s):

Virtual Warehouse

Storage

Schema

Database

Q13. How to change the current warehouse of a session

Select 1 option(s):?

Execute SET WAREHOUSE command

Execute SELECT WAREHOUSE command

Execute USE WAREHOUSE command

None of these

Q14. Micro-partitioning is automatically performed on all the Snowflake tables.

Select 1 option(s):

TRUE

FALSE

Q15. Which SQL statements can work on a cloned Table?

Select 1 option(s):

All of these

DROP table command

SELECT command

SHOW command

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

Select 1 option(s):

TRUE

FALSE

Q17. John wants to create a Warehouse which can auto suspend in 10 minutes. How should he configure the warehouse?

Select 1 option(s):

AUTO_SUSPEND = 10

AUTO_RESUME = TRUE

AUTO_SUSPEND = 600

AUTO_SUSPEND = TRUE

Q18. Snowflake data storage costs include which types of data?

Select 2 option(s):

Persistent data stored in permanent tables

Data retained to enable data recovery (time travel and fail-safe)

Metadata

Cached Results

Semi-Structured data - additional fees

Q19. How many virtual warehouses can be created in a Snowflake Account?

Select 1 option(s):

As many as needed

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

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

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

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

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

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

Q21. Scaling up is intended for handling concurrency issues dure to more users or more queries

Select 1 option(s):

FASE

TRUE

Q22. As an ACCOUNTADMIN, how can you find the credit usage of a warehouse?

Select 3 option(s):

Using Web interface > Account > Usage

Run SQL query on WAREHOUSE_METERING_HISTORY view under ACCOUNT_USAGE Schema

Run SQL query on ACCOUNT_USAGE table under Snowflake Database

Run SQL query on METERING_HISTORY view under ACCOUNT_USAGE Schema

Q23. How much is the Time-Travel retention period of Temporary Table?

Select 1 option(s):

90 days

0 days

7 days

1 day

Q24. What is the best use of Multi-Cluster Warehouse?

Select 1 option(s):

Best utilized for scaling resources to improve performance of slow-running queries.

Best utilized for scaling resources to improve concurrency for users/queries.

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

Select 1 option(s):

FALSE

TRUE

Q26. Monica mistakenly dropped a table T1 last week. The database has Time-Travel retention period set to 90 days. How can Monica recover the table which she dropped last week.

Select 1 option(s):

Q27. John wants to create a multi-cluster warehouse and wants to make sure that whenever new queries are queued, additional clusters should start immediately. How should he configure the Warehouse?

Select 1 option(s):

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

Set the SCALING POLICY as ECONOMY

Set the SCALING POLICY as STANDARD

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

Q28. SNOWPIPE (REST) method only works with Internal Stages. (TRUE/FALSE)

Select 1 option(s):

TRUE

FALSE

Q29. Which vendors do support Snowflake natively for federated authentication and SSO?

Select 2 option(s):

Okta

Microsoft ADFS

Google G Suite

Onelogin

Microsoft Azure Active Directory

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

Select 1 option(s):

User

Named Internal

Table

Named External

Q31. Which are the correct statements about STREAMS?

Select 2 option(s):

STREAMS is used to scheduled SQL execution

it can not be used with TASKS

It is used for Change Data Capture (CDC)

Streams is used to identify and act on changed table records

Q32. What actions can be performed when an error is encountered while loading data from a file?

Select 4 option(s):

Continue loading the file.

Abort the load operation

Skip file

skip file when the number of errors in the file is equal to 10

Unattempted

Q33. Snowflake provides standard and powerful features that ensure the highest levels of security for your account and users if used properly. Which are the true statements about Snowflake Security?

Select 2 option(s):

Snowflake supports user-based access control

Tri-secret requires that customers manage their own keys

Federated authentication in Snowflake is compliant with SAML 2.0

Q34. Monica has a EMPLOYEE_DATA table. Monica wants to create another table EMPLOYEE_DATA_OTHER which should be same as EMPLOYEE_DATA table with same data. What is the best option for Monica?

Select 1 option(s):

Clone the table with same data with SQL command as follows - CREATE TABLE EMPLOYEE_DATA_OTHER CLONE EMPLOYEE_DATA;

Create the table with same data with SQL command as follows - CREATE TABLE EMPLOYEE_DATA_OTHER AS SELECT * FROM EMPLOYEE_DATA;

CREATE SHARE EMPLOYEE_DATA;

Create the table with LIKE SQL command as follows - CREATE TABLE EMPLOYEE_DATA_OTHER LIKE EMPLOYEE_DATA;

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

Select 1 option(s):

ALTER WAREHOUSE MY_WAREHOUSE SET AUTO_SUSPEND = ‘TRUE‘;

SUSPEND WAREHOUSE MY_WAREHOUSE;

DROP WAREHOUSE MY_WAREHOUSE;

ALTER WAREHOUSE MY_WAREHOUSE SUSPEND;

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

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

Select 1 option(s):

TRUE

FALSE

Q38. Which type of Tables has 7 days Fail-Safe period.

Select 1 option(s):

Permanent

Temporary

External

Transient

Q39. Scaling a Warehouse DOWN will decrease the number of servers (e.g., Large to Medium).

Select 1 option(s):

TRUE

FALSE

Q40. Please choose the correct statements about Micro-Partitions (Select 2)

Select 2 option(s):

Snowflake automatically determines the most efficient compression algorithm for the columns in each micro-partition.

Snowflake micro-partitions are derived automatically

Micro-partitions are small in size (50 to 500 MB, after compression)

Micro-partitions can‘t overlap in their range of values

Q41. Which Snowflake Editions have Elastic Data Warehousing. Check all the Snowflake editions that have Elastic Data Warehousing enabled.

Select 3 option(s):

Premium

Standard

Enterprise

Virtual Private Snowflake

Business Critical Edition

Q42. Scaling Out is an automated process. It automatically scale out during peak times and scale back during slow times

Select 1 option(s):

TRUE

FALSE

Q43. How can you disable auto-suspend for a warehouse?

Select 2 option(s):

Using UI, selecting NEVER against AUTO SUSPEND

Specifying NULL in SQL

You can not disable AUTO SUSPEND in standard warehouse

You can not disable AUTO SUSPEND in multi-cluster warehouse

Q44. Monica is an ACCOUNTADMIN and wants to change the Time Travel retention period of table T1 of database DB1 to 15 days. Which options will help her to set the new Time Travel retention period?

Select 1 option(s):

Execute SQL Command - ALTER TABLE T1 SET DATA_RETENTION_TIME_IN_DAYS = 15;

Monica can change the retention period through ACCOUNT tab on UI

Monica should contact Salesforce support to get it done

Execute SQL Command - ALTER TABLE T1 SET DATA_RETENTION_TIME_IN_DAYS = 75;

Q45. Some compute occurs in the cloud services layer. When customer is charged for compute which occurred in the cloud services layer?

Select 1 option(s):

There is no charge to customer for cloud services layer

Customers are charged for cloud computing that exceeds 50% of total compute costs for the account

Customers are charged for cloud computing that exceeds 10% of total storage costs for the account

Customers are charged for cloud computing that exceeds 10% of total compute costs for the account

Q46. How much data each of the micro-partition contain in uncompressed form? Select the

Select 1 option(s):

1 GB

16 MB

Between 50 MB to 500 MB

Between 10 MB to 40 MB

Q47. When creating a table, schema, or database, the account default can be overridden using the DATA_RETENTION_TIME_IN_DAYS parameter in the command.

Select 1 option(s):

TRUE

FALSE

Q48. Snowflake compute costs depend on which of the following? (Select 2)

Select 2 option(s):

The number of rows returned in queries.

The sizes of running warehouses.

The amount of time warehouses have run.

The total number of warehouses in the account.

Q49. Micro-partitions are IMMUTABLE. What are features make micro-partitions IMMUTABLE?

Select 2 option(s):

Snowflake purges the micro-partitions as soon as you delete any record from table.

Snowflake creates new micro-partitions every time there is data change.

Micro-Partitions are not editable.

When new data gets ingested Snowflake tries to insert data in existing micro-partition to save the storage.

Q50. What is Clustering Depth?

Select 2 option(s):

It is the total number of micro-partitions that comprise the table

The bigger the average depth, the better clustered the table

It can be used to determine whether a large table would benefit from explicitly defining a clustering key

The depth of the overlapping micro-partitions

Q51. Snowflake does not begin executing SQL statements submitted to a warehouse until all of the servers for the warehouse are successfully provisioned. If any server fails to provision, Snowflake attempts to repair the failed server. The warehouse starts processing statement once 100% of the requested servers are successfully provisioned.

Select 1 option(s):

TRUE

FALSE

Q52. In what order servers are removed when a warehouse is suspended or resized?

Select 1 option(s):

LILO (“LAST IN, LAST OUT“)

LIFO (“LAST IN, FIRST OUT“)

FILO (“FIRST IN, LAST OUT“)

FIFO (“FIRST IN, FIRST OUT“)

Q53. Snowflake Storage layer is a Cloud Storage layer. It depends on which cloud provider you are using. Select the current available cloud providers.

Select 3 option(s):

IBM Cloud

AWS Cloud

Azure Cloud

Oracle Cloud

GCP

Q53. Normally a warehouse begins to consume credits once all the servers are provisioned for the warehouse.

Select 1 option(s):

FALSE

TRUE

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

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

Select 1 option(s):

FALSE

TRUE

Q57. Temporary and Transient Tables has 1 day of Fail-safe available. (True/False)

Select 1 option(s):

FALSE

TRUE

Q58. John wants to create a Warehouse which can AUTO_SUSPEND in 3 Minutes. There is no option in UI where he can select 3 Minutes. What will you suggest him to do?

Select 1 option(s):

He should contact Snowflake Support to get it created

It is not possible to create a warehouse with AUTO_SUSPEND less than 5 Minutes

He should select Size as X-SMALL and then he will be able to set AUTO_SUSPEND to 3 Minutes

He can create the Warehouse using SQL command with AUTO_SUSPEND = 180

Q59. How much is the Time-Travel retention period of Permanent Table (Standard Edition)?

Select 1 option(s):

1 day

7 days

90 days

0 days

Q60. What is the default Time-Travel retention period of Enterprise Edition?

Select 1 option(s):

7 days

1 day

0 days

90 days

Q61. What types of Infrastructure Security are available to ensure customer data is secured?

Select 3 option(s):

Cloud provider‘s redundancy

Regional data centers

Customer Admin takes the backup of data into local data disk

Cloud Provider‘s physical security

Q62. A multi-cluster virtual warehouse is Maximized when

Select 2 option(s):

Minimum and Maximum number of clusters are specified differently.

MIN_CLUSTER_COUNT = 1 MAX_CLUSTER_COUNT = 1

MIN_CLUSTER_COUNT = 3 MAX_CLUSTER_COUNT = 3

Minimum number of clusters and Maximum number of clusters are same and must be specified with a value of more than 1.

Q63. What is the best use of SCALING OUT?

Select 1 option(s):

Better Performance

Better Concurrency

Q64. What are the correct SQL extensions used in querying data from Time Travel? Select 2.

Select 2 option(s):

INITIAL

AFTER

BEFORE

Q65. A 3X-LARGE cluster contains 64 Servers. if a 3X-Large multi-cluster warehouse runs 1 cluster for one full hour and then runs 3 clusters for the next full hour. How many credits will be billed?

Select 1 option(s):

128

512

256

212