Snowflake Virtual Warehouses ||Snowflake virtual warehouses || Snowflake storage and Protection Flashcards by Billie Hurley

how to choose the right size of the warehouse to achieve the best results based on the Query processing?

a) Execute a variety of queries in same warehouse to achieve the best result
b) execute relatively homogenous queries on the same warehouse

b) execute relatively homogenous queries on the same warehouse

How well did you know this?

Not at all

Perfectly

increasing the size of a warehouse always improves data loading performance

TRUE or FALSE

FALSE

How well did you know this?

Not at all

Perfectly

what is the maximum time-travel retention period standard edition?

a) 0 days
b) 90 days
c) 1 days
d) 7 days

c) 1 days

How well did you know this?

Not at all

Perfectly

John has table T1 with the Time-Travel retention period set to 20 days. He increased the retention period from 10 days to make it 30 days. What impacts will happen on Table data? please select 2

a) no impact on any data that is 20 days older and has already moved into fail-safe
b) data that have moved to fail-safe after 20 days will now be available in time travel for additional 10 days
c) data that would have been removed after 20 days is now retained for an additional 10 days before moving into fail-safe
d) changes will ONLY effective for new data coming to time-travel
e) no impact on existing data which moved from table to time-travel before the increases of time-travel retention period

a) no impact on any data that is 20 days older and has already moved into fail-safe
c) data that would have been removed after 20 days is now retained for an additional 10 days before moving into fail-safe

How well did you know this?

Not at all

Perfectly

john wants to create a warehouse which can auto spend in 10 minutes. how should he configure the warehouse?

AUTO_SUSPEND = 600

How well did you know this?

Not at all

Perfectly

what is the best use of a multi-cluster warehouse?

a) best utilized for scaling resources to improve the performance of slow-running queries
b) best utilized for scaling resources to improve concurrency for users/queries

b) best utilized for scaling resources to improve concurrency for users/queries

How well did you know this?

Not at all

Perfectly

which SQL command will give the list of all warehouses in an account?

a) DISPLAY WAREHOUSE;
b) LIST WAREHOUSES;
c) SHOW WAREHOUSE;
d) SHOW WAREHOUSES;
e) LIST WAREHOUSE;

d) SHOW WAREHOUSES;

How well did you know this?

Not at all

Perfectly

which SQL statement will suspend a running warehouse MY_WAREHOUSE?

a) ALTER WAREHOUSE MY_WAREHOUSE SUSPEND;
b) DROP WAREHOUSE MY_WAREHOUSE;
c) SUSPEND WAREHOUSE MY_WAREHOUSE:
d) ALTER WAREHOUSE MY_WAREHOUSE SET AUTO_SUSPEND =’TRUE’;

a) ALTER WAREHOUSE MY_WAREHOUSE SUSPEND;

How well did you know this?

Not at all

Perfectly

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?

a) Monica should contact Salesforce support to get it done
b) Monica can execute UNDROP TABLE T1 command after setting up the right context for Database and schema
c) Monica can use the UI> ACCOUNT menu to recover the table T1
d) Monica can not recover it from TIME-TRAVEL as the table T1 moved to fail-safe

b) Monica can execute UNDROP TABLE T1 command after setting up the right context for Database and schema

How well did you know this?

Not at all

Perfectly

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

a) Restore tables, schemas but not databases that have been dropped
b) Query data in the past
c) restores tables, schemas and databases that have been dropped
d) create clones of tables, schema and databases

b) Query data in the past
c) restores tables, schemas and databases that have been dropped
d) create clones of tables, schema and databases

How well did you know this?

Not at all

Perfectly

you want a list of all warehouses with name starting from DEMO. select the correct SQL statement.

a) SHOW WAREHOUSES LIKE ‘%DEMO’;
b) SHOW WAREHOUSES LIKE ‘DEMO%’;
c) LSIT WAREHOUSES LIKE ‘%DEMO’;
d) SHOW WAREHOUSE LIKE ‘%DEMO’;

b) SHOW WAREHOUSES LIKE ‘DEMO%’;

How well did you know this?

Not at all

Perfectly

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

TRUE or FALSE

TRUE

How well did you know this?

Not at all

Perfectly

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

TRUE or FALSE

TRUE

How well did you know this?

Not at all

Perfectly

who owns and manages the cloud storage layer hosted on cloud providers?

a) snowflake
b) customer
c) cloud provider

a) snowflake

How well did you know this?

Not at all

Perfectly

how does snowflake provide continuous availability?

a) snowflake synchronizes data across availability zones
b) time travel storage
c) fail safe storage
d) customer has to back up the data locally out of the cloud

a) snowflake synchronizes data across availability zones
b) time travel storage
c) fail safe storage

How well did you know this?

Not at all

Perfectly

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?

a) he should contact snowflake support to get it created
b) he can create the warehouse using SQL command with AUTO_SUSPEND =180
c) he should select size as X-SMALL and then he will be able to set AUTO_SUSPEND to 3 minutes
d) it is not possible to create a warehouse with AUTO_SUSPEND less than 5 mintues

b) he can create the warehouse using SQL command with AUTO_SUSPEND =180

How well did you know this?

Not at all

Perfectly

how much is the Time-Travel retention period of a temporary table?

a) 1 day
b) 7 days
c) 90 days
d) 0 days

a) 1 day

How well did you know this?

Not at all

Perfectly

scaling a warehouse OUT will increase the number of clusters
TRUE or FALSE

TRUE

How well did you know this?

Not at all

Perfectly

the compute resource used by snowflake for data loading jibs can be provided by:

a) snowflake managed services
b) user-managed virtual warehouse
c) hardware provisioned by user directly from cloud providers

a) snowflake managed services

b) user-managed virtual warehouse

How well did you know this?

Not at all

Perfectly

you have a large sized warehouse ‘MY_WAREHOUSE’. you want to change the size to SMALL. which statement will help you to change the size of warehouse?

a) ALTER WAREHOUSE MY_WAREHOUSE SET SIZE = “SMALL”;
b) ALTER WAREHOUSE MY_WAREHOUSE SET WAREHOUSE_SIZE = “SMALL”;
c) UPDATE MY_WAREHOUSE SET SIZE = “SMALL”;
d) ALTER MY_WAREHOUSE SET SIXE = “SMALL”;

b) ALTER WAREHOUSE MY_WAREHOUSE SET WAREHOUSE_SIZE = “SMALL”;

How well did you know this?

Not at all

Perfectly

the column in the query history include the QueryID, the SQL Text, the warehouse name, the Warehouse size, the session ID and other. which column is a good indicator of whether a warehouse was used (and compute cost incurred) by a query?

a) query ID
b) warehouse name
c) session ID
d) size

d) size

How well did you know this?

Not at all

Perfectly

generally, what is the size of a micro-partition in compresses format?

a) 500 MB
b) 16 MB
c) 16 GB
d) 50 MB

b) 16 MB

How well did you know this?

Not at all

Perfectly

what types of infrastruture security are avilable to ensure customer data is secured?

a) cloud provider’s redundancy
b) cloud provider’s physical security
c) customer admin takes the backup of the data into local data disk
d) regional data centers

a) cloud provider’s redundancy
b) cloud provider’s physical security
d) regional data centers

How well did you know this?

Not at all

Perfectly

Which if the correct syntax to disable fail safe on a table?

a) by default, fail safe is disabled on a table
b) ALTER TABLE DROP FAIL SAFE;
c) ALTER TABLE SET ENABLE_FAILSAFE = FALSE;
d) ALTER TABLE SET FAILSAFE_DAYS = 0;
e) FAILSAFE can not be disabled on a tables;

e) FAILSAFE can not be disabled on a tables;

How well did you know this?

Not at all

Perfectly

zero copying 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? a) clone is a "point in time version" of the tables data as of the time the clone was made b) any new record in the parent table gets available in the cloned table c) the clone is a pointer to the original table data d) cloning is an efficient and cost effective approach for code migration for agile

a) clone is a "point in time version" of the tables data as of the time the clone was made c) the clone is a pointer to the original table data d) cloning is an efficient and cost effective approach for code migration for agile

what is the best use of SCALING OUT? a) better performance b) better concurrency

b) better concurrency

micro-partitions are IMMUTABLE. what are features that make micro-partitions IMMUTABLE? a) when new data gets ingested snowflake tries to insert data in existing micro-partitions to save the storage b) micro-partitions are not edited c) snowflake craetes new micro-partitons every time there is new data change d) snowflake purges the micro-partitions as soon as you delete any record from the table

b) micro-partitions are not edited | c) snowflake craetes new micro-partitons every time there is new data change

snowflake storage layer is a cloud storage layer. it depends on which cloud provider you are using. select the current available cloud providers a) Azure Cloud b) IBM cloud c) GCP d) oracle cloud e) AWS CLOUD

a) Azure Cloud c) GCP e) AWS CLOUD

Monica has a EMPLOYEE_DATA table. Monica wants to create another table EMPLOYEE_DATA_OTHER which should be the same as EMPLOYEE_DATA tables with the same data. what is the best option for Monica? a) Create the table with the same data with SQL command as follows - CREATE TABLE EMPLOYEE_DATA_OTHER AS SELECT*FrOM EMPLOYEE_DATA; b) clone the table with the same data with SQL command as follows - CREATE TABLE EMPLOYEE_DATA_OTHER CLONE EMPLYEE_DATA c) CREATE SHARE EMPLYEE_DATA; d) create the table with LIKE SQL command as follows - CREATE TABLE EMPLOYEE_DATA_OTHER LIKE EMPLOYEE_DATA;

b) clone the table with the same data with SQL command as follows - CREATE TABLE EMPLOYEE_DATA_OTHER CLONE EMPLYEE_DATA

multi-cluster warehouse credit billing is based on which factors? a) number of queries it processes per hours b) number of servers per cluster c) number of users d) number of clusters

b) number of servers per cluster | d) number of clusters

which are the types of virtual warehouses in snowflake? a) Premier b) multi-cluster c) enterprise d) standard

b) multi-cluster | d) standard

which are the types of virtual warehouses in snowflake? a) Premier b) multi-cluster c) enterprise d) standard

b) multi-cluster | d) standard

the data stored as part of fail-safe is part of storage costs charged customers. TRUE or FALSE

TRUE

scaling warehouse DOWN will decrease the number of servers TRUE or FALSE

TRUE

scailing out is an automated process TRUE or FASLE

TRUE

please choose correct statements about micro-partitions a) snowflake automatically determines the most efficient compression algorithm for the columns in each micro-partition b) snowflake micro-partition are derived automatically c) micro-partitons can't overlap in their range of values d) micro-partitions are small in size (50 to 500 MB, after compression)

a) snowflake automatically determines the most efficient compression algorithm for the columns in each micro-partition b) snowflake micro-partition are derived automatically

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 a) the data that is currently in time travel and if the data is still within the new shorter period, it remains in time travel b) changes will be only effective for new data coming to time travel c) the data which was in time travel for more than 5 days will move to fail-safe by snowflake by background process d) no impact to existing time travel data. that will still complete the longer period of 20 days before going to fail-safe

a) the data that is currently in time travel and if the data is still within the new shorter period, it remains in time travel c) the data which was in time travel for more than 5 days will move to fail-safe by snowflake by background process

which of the following is a common case for cloning in snowflake ( select all that apply) a) "point in time" snapshot b) data encryption protection c) agile release and development d) data life cycle management

a) "point in time" snapshot c) agile release and development d) data life cycle management

how much data does each of the mico-partitions contain in uncompressed form? a) 16 MB b) between 10 MB to 40 MB c) between 50 MB to 500 MB d) 1 GB

c) between 50 MB to 500 MB

how much is the time travel retention period of transient table?

0 days

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? a) snowflake takes care of this automatically so, John does to have to worry about it b) set the scaling policy as standard c) configure as scale-max as that the warehouse is always using maximum number of specified clusters d) set the scaling policy as economy

d) set the scaling policy as economy

Monica is an ACCOUNTADMIN and wants to change the time travel retention period of table T1 of database DB1 to 15 days. which option will help her to set the new time travel retention period? a) Monica should contact Salesforce support to get it done b) execute SQL command - ALTER TABLE T1 SET DATA_RETENTION_TIME_IN_DAYS =75; c) execute SQL command - ALTER TABLE T1 SET DATA_RETENTION_TIME_IN_DAYS = 15; d) Monica can change the relationship period through account tab on UI

c) execute SQL command - ALTER TABLE T1 SET DATA_RETENTION_TIME_IN_DAYS = 15;

fail-safe is a relaible way to create DEV/TEST?QA and other environments TRUE or FALSE

FALSE

how many virtual warehouse can be created in a snowflake account? a) 8 b) 16 c) as many as needed d) 4

c) as amany as needed

temporary and trasinet tables has 1 day of fail-safe available TRUE or FALSE

FALSE

scaling up can be configured as automated process TRUE or FALSE

FALSE

which snowflake object is a named wrapper around a cluster of servers with CPU, memory and disk a) storage b) database c) virtual warehouse d) schema

c) virtual warehouse

which snowflake editions have maximum 90 days of time-travel retention period? a) all editions b) VPS c) enterprise d) standard e) business critical

b) VPS c) enterprise e) business critical

how can you disable auto-suspend for a warehouse? a) using UI, selecting never against aUTO SUSPEND b) you can not disable auto suspend in standard warehouse c) you can not disable auto suspend in multi-cluster warehouse d) specifying NULL in SQL

a) using UI, selecting never against aUTO SUSPEND | d) specifying NULL in SQL

which SQL statement will not consume warehouse credit? a) SHOW WAREHOUSES; b) SHOW WAREHOUSE LIKE '%DEMO'; c) DROP WAREHOUSE MY_WAREHOUSE; d) ALTER WAREHOUSE MY_WAREHOUSE SET WAREHOUSE_SIZE ="SMALL";

a) SHOW WAREHOUSES; b) SHOW WAREHOUSE LIKE '%DEMO'; c) DROP WAREHOUSE MY_WAREHOUSE; d) ALTER WAREHOUSE MY_WAREHOUSE SET WAREHOUSE_SIZE ="SMALL";

scaling out is an automated process. it automatically scale out during peak times and scale back slow times TRUE or FALSE

FALSE

if you are ACCOUNTADMIN, you can query and recover data from fail-safe without the help of snowflake support TRUE or FLASE

FALSE

John wants to create a warehouse which should not start immediately. which property will he create a warehouse in suspend mode a) AUTO_SUSPEND = INITAL b) AUTO_START = FALSE c) INITIALLY_SUSPEND = TRUE d) INITIATE = FALSE

c) INITIALLY_SUSPEND = TRUE

snowflake compute costs depend on whihc of the following? a) the number of rows returned in queries b) the sizes of sunning warehouses c) the amount of time warehouses have to run d) the total number of warehouses in the account

b) the sizes of sunning warehouses | c) the amount of time warehouses have to run

select the snowflake edition that automatic encryptions all the data? a) enterprise b) standard c) all the editions d) VPS e) business critical

c) all the editions

what is the minimum billing charge for provisioning a warehouse? a) 60 minutes b) 1 minute c) 1 second d) no charge

b) 1 mintue

when a database or schema is cloned. what object is not cloned? a) internal stages b) stored procedures c) pipes d) sequences e) internal named stages

e) internal named stages

Which Snowflake editions have elastic data warehousing. Check all the snowflake editions that have elastic data warehousing enabled. a) Virtual Private snowflake b) Premium c) Enterprise d) Standard e) business critical edition

a) Virtual Private snowflake c) Enterprise e) business critical edition

What action causes a warehouse's cache to be purged? a) the passing of 24 hours b) resuming the warehouse c) suspending the warehouse d) a change to the metadata cache size

c) suspending the warehouse

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? a) 120 seconds b) 64 seconds c) 4 seconds d) 124 seconds

d) 124 seconds

what are the correct SQL extension used in querying data from time travel ? a) BEFORE b) AFTER c) INITAL d) AT

a) BEFORE | d) AT

when a warehouse is resized, which queries make use of the new size? a) only currently running queries b) both current and subsequent queries c) only subsequent queries

c) only subsequent queries

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? a) AUTO_RESUME = 1 b) AUTO_RESUME = TRUE c) AUTO_SUSPEND = TRUE d) it is always manual and can't be automated

b) AUTO_RESUME = TRUE

which of the following database objects can be cloned in snowflake? a) schemas b) databases c) tables d) all the editions e) file formats

d) all the editions

what is clustering depth? a) the bigger the average depth, the better clustered the table b) the depth of the overlapping micro-partitions c) it is the total nu,ber of micro-partions that comprise the table d) it can be used to determine whether a large table would benefit from explicitly defining a clsuterinig key

b) the depth of the overlapping micro-partitions | d) it can be used to determine whether a large table would benefit from explicitly defining a clsuterinig key

a multi-cluster virtual warehouse is auto-scale when a) minimum number of clusters and maximum number of clusters are same and must be specified with a value of more than 1 b) MIN_CLUSTER_COUNT = 3, MAX_CLUSTER_COUNT = 3 c) MIN_CLUSTER_COUNT = 1, MAX_CLUSTER_COUNT = 4 d) minimum and maximum number of clusters are specified differently

c) MIN_CLUSTER_COUNT = 1, MAX_CLUSTER_COUNT = 4 | d) minimum and maximum number of clusters are specified differently

which SQL statements can work on a cloned table? a) DROP table command b) SELCT command c) SHOW command d) All of these

d) all of these

Monica is an admin and wants to see the usage of fail-safe. how can che get details on fail-safe usage? a) admins can view fail-safe use in snowflake web UI under account > billing and usage b) fail safe usage details are never available to customer c) Monica should contact snowflake support d) none of these

a) admins can view fail-safe use in snowflake web UI under account > billing and usage

Auto-suspend and auto-resume apply only to the entire warehouse and not to the individual cluster in the warehouse TRUE or FALSE

TRUE

when creating a table, schema or database the account default can be overridden using the DATA_RETENTION_TIME_IN_DAYS parameter in the command TRUE or FALSE

TRUE

Monica is a new snowflake user with ACCOUNTADMIN role. Shw 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? a) she should use SQL command to create the warehouse with minimum and maximum clusters b) she doesn't have enough privilege to create a warehouse c) she should ALTER any existing warehouse to set the Maximum and minimum clusters d) she is using STANDARD snowflake edditions. Multi-clsuter is not available in STANDARD edition.

d) she is using STANDARD snowflake edditions. Multi-clsuter is not available in STANDARD edition.

a virtual warehouse can't access data loaded in the table using different warehouse TRUE or FALSE

FALSE

two virtual warehouse can access the same data at the same time without causing contention issues TRUE or FALSE

TRUE

John has a same query which runs for around 40 minutes every hour. most of the time the data in the table remains the same. what could be best option for John to keep warehouse running or AUTO_SUSPEND? a) John should set AUTO_SUSPEND to 10 minutes b) John should not set AUTO_SUSPEND c) John doesn't have to set AUTO_SUSPEND. Snowflake will take care of suspension as needed d) John should set AUTO_SUSPEND to 40 mintues

b) John should not set AUTO_SUSPEND

where there is new load of data in Snowflake, snowflake automatically analyzes and compresses data in table TRUE or FALSE

TRUE

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

LIFO("LAST IN, FIRST OUT")

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? a) 512 b) 212 c) 128 d) 256

d) 256

The Cloning feature in snowflake requires less storage because; a) the cloined data is constantly updates=d to synchronize with original table data b) data is replicated to ensure integrity of data in the original table data c) only metadata is copied; no physical data is copied

c) only metadata is copied; no physical data is copied

which type of table has 7 days fail-safe period a) permant b) temporary c) external d) transient

a) permant

Micro-partitioning is automatically perfrmed on all the snowflake tables TRUE or FALSE

TRUE

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 warehouseing is not enabled. a) auto-suspend b) minimum and maximum servers c) scaling policy d) minimum and maximum clusters

c) scaling policy | d) minimum and maximum clusters

snowflake data storage costs include which types of data? a) semi-structured data - additional fees b) metadata c) cached results d) data retained to enable data recovery (time travel and fail safe) e) Persistent data stored in permanent tables

d) data retained to enable data recovery (time travel and fail safe) e) Persistent data stored in permanent tables

Which privilege is needed to be able to monitor a warehouse? a) MODIFY b) MONITOR c) USAGE d) OPERATE

b) MONITOR

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 be able to recover the table T1? a) john can receiver the table T1 after 30 days b) yes, as the retention period is specified at database level c) John should call snowflake support to recover the table from fail-safe d) No. John can't recover the dropped table T1 because he didn't set DATA_RETENTION_TIME_IN_DAYS for table T1

b) yes, as the retention period is specified at database level

Time travel cannot be disabled for an account TRUE or FALSE

TRUE

which are the correct statements for a virtual warehouse? a) size determines the number of servers that comprise each cluster in a warehouse b) warehouse are sized in "t-shirt" sizing c) each larger size is double the preceding in both VMs in the cluster and in snowflake credits consumed d) standard virtual warehouse can scale-out

a) size determines the number of servers that comprise each cluster in a warehouse b) warehouse are sized in "t-shirt" sizing c) each larger size is double the preceding in both VMs in the cluster and in snowflake credits consumed

A multi-cluster virtual warehouse is maximized when a) minimum and maximum number if clusters are specified differently b) minimum number of clusters and maximum number of clusters are same and must be specified with a value of more than 1 c) MIN_CLUSTER_COUNT = 1, MAX_CLUSTER_COUNT = 1 d) MIN_CLUSTER_COUNT = 3, MAX_CLUSTER_COUNT = 3

b) minimum number of clusters and maximum number of clusters are same and must be specified with a value of more than 1 d) MIN_CLUSTER_COUNT = 3, MAX_CLUSTER_COUNT = 3

what is the default time-travel retention periof of enterprise edition? a) 7 days b) 90 days c) 1 day d) 0 days

b) 90 days

some compute occurs in the cloud services layer. when customer is charged for compute which occurred in the cloud services layer? a) customer are charged for cloud computing that exceeds 10% of total storage costs for the account b) there is no charge to customer cloud services layer c) customer are charged for cloud computing that exceeds 50% of total compute costs for the account d) customers are charged for cloud computing that exceeds 10& of total compute costs for the account

d)customers are charged for cloud computing that exceeds 10& of total compute costs for the account

only snowflake employee can recover data from fail-safe storage TRUE or FALSE

TRUE

a multi-cluster warehouse is using ECONOMY scaling policy, how long will queries back up in the queue before another cluster is started? a) 8 minutes b) it will start immediately c) 6 minutes d) 2 minutes e) 1 minute

c) 6 minutes

scaling up is intended for handling concurrency issues indure to more users or more queries TRUE or FALSE

FALSE

snowlfake data storage costs are calculated based on: a) uncompressed size b) compressed size c) amount stored - daily average d) amount stored on last day of Month e) Amount stored on first day of month

b) compressed size | c) amount stored - daily average

snowflake does not begin executing SQL statements submitted to a warehouse until all 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. TRUE or FALSE

FALSE

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.

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

when should you avoid enabling AUTO-SUSPEND? a) you have a heavy, steady workload for the warehouse b) you should always enable AUTO_SUSPEND to save the compute costs c) you require the warehouse to be available with no delay or lag time

a) you have a heavy, steady workload for the warehouse | c) you require the warehouse to be available with no delay or lag time

is there any cost benefit of suspending a warehouse in less than 60 seconds? YES or NO

virtual warehouse in snowflake refers to a) database b) data warehouse c) virtual storage d) compute engine

d) compute engine

resizing a warehouse can be completed at any time, even when running TRUE or FALSE

TRUE

normally a warehouse begins to consume credits once all the servers are provisioned for the warehouse TRUE or FALSE

TRUE

what are the key considerations for using warehouse effectively and efficiently? a) experiment with different types of queries and different warehouse sizes to determine the combinations that best meet your specific query needs and workloads b) start with smallest warehouse always and scale up if the performance is poor c) don't focus on warehouse size. snowflake utilizes per-second billing, so you can run larger warehouses and simply suspend them when not in use d) snowflake utilizes per-hour billing so, customer doesn't have to worry about the warehouse size

a) experiment with different types of queries and different warehouse sizes to determine the combinations that best meet your specific query needs and workloads c) don't focus on warehouse size. snowflake utilizes per-second billing, so you can run larger warehouses and simply suspend them when not in use

which are the correct statements about snowflake data storage? a) automatic micro-partitioning b) natural data clustering and optimization c) hybrid columnar storage d) encryption on demand

a) automatic micro-partitioning b) natural data clustering and optimization c) hybrid columnar storage

how much is the time-travel retention period of permanent table standard edition? a) 0 days b) 7 days c) 90 days d) 1 day

d) 1 day

as an ACCOUNTADMIN, how can you find the credit usage of a warehouse? a) using web interface > account > usage b) run SQL query on metering_history view under account_usage schema c) run SQL query in warehouse_metering_history view under account_usage schema d) run SQL query on account_usage table under snowflake database

a) using web interface > account > usage b) run SQL query on metering_history view under account_usage schema c) run SQL query in warehouse_metering_history view under account_usage schema

how to change the current warehouse of a session? a) none of these b) execute set warehouse command c) execute select warehouse command d) execute use warehouse command

d) execute use warehouse command