Snowflake Virtual Warehouses ||Snowflake virtual warehouses || Snowflake storage and Protection Flashcards

1
Q

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

A

b) execute relatively homogenous queries on the same warehouse

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

increasing the size of a warehouse always improves data loading performance

TRUE or FALSE

A

FALSE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

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

A

c) 1 days

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

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?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

A

AUTO_SUSPEND = 600

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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;

A

d) SHOW WAREHOUSES;

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

a) ALTER WAREHOUSE MY_WAREHOUSE SUSPEND;

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A

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?
1
Not at all
2
3
4
5
Perfectly
11
Q

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’;

A

b) SHOW WAREHOUSES LIKE ‘DEMO%’;

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

TRUE or FALSE

A

TRUE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A

TRUE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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

a) snowflake
b) customer
c) cloud provider

A

a) snowflake

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

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

a) 1 day

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

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

A

TRUE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

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

a) snowflake managed services

b) user-managed virtual warehouse

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

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”;

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

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

A

d) size

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

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

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

A

b) 16 MB

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

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

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

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;

A

e) FAILSAFE can not be disabled on a tables;

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

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

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

what is the best use of SCALING OUT?

a) better performance
b) better concurrency

A

b) better concurrency

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

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

A

b) micro-partitions are not edited

c) snowflake craetes new micro-partitons every time there is new data change

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

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

a) Azure Cloud
c) GCP
e) AWS CLOUD

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

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;

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

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

A

b) number of servers per cluster

d) number of clusters

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

which are the types of virtual warehouses in snowflake?

a) Premier
b) multi-cluster
c) enterprise
d) standard

A

b) multi-cluster

d) standard

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

which are the types of virtual warehouses in snowflake?

a) Premier
b) multi-cluster
c) enterprise
d) standard

A

b) multi-cluster

d) standard

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

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

TRUE or FALSE

A

TRUE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

scaling warehouse DOWN will decrease the number of servers

TRUE or FALSE

A

TRUE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q

scailing out is an automated process

TRUE or FASLE

A

TRUE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
36
Q

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

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
37
Q

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

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
38
Q

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

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
39
Q

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

A

c) between 50 MB to 500 MB

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
40
Q

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

A

0 days

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
41
Q

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

A

d) set the scaling policy as economy

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
42
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
43
Q

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

TRUE or FALSE

A

FALSE

44
Q

how many virtual warehouse can be created in a snowflake account?

a) 8
b) 16
c) as many as needed
d) 4

A

c) as amany as needed

45
Q

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

TRUE or FALSE

A

FALSE

46
Q

scaling up can be configured as automated process

TRUE or FALSE

A

FALSE

47
Q

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

A

c) virtual warehouse

48
Q

which snowflake editions have maximum 90 days of time-travel retention period?

a) all editions
b) VPS
c) enterprise
d) standard
e) business critical

A

b) VPS
c) enterprise
e) business critical

49
Q

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

a) using UI, selecting never against aUTO SUSPEND

d) specifying NULL in SQL

50
Q

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

a) SHOW WAREHOUSES;
b) SHOW WAREHOUSE LIKE ‘%DEMO’;
c) DROP WAREHOUSE MY_WAREHOUSE;
d) ALTER WAREHOUSE MY_WAREHOUSE SET WAREHOUSE_SIZE =”SMALL”;

51
Q

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

TRUE or FALSE

A

FALSE

52
Q

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

TRUE or FLASE

A

FALSE

53
Q

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

A

c) INITIALLY_SUSPEND = TRUE

54
Q

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

A

b) the sizes of sunning warehouses

c) the amount of time warehouses have to run

55
Q

select the snowflake edition that automatic encryptions all the data?

a) enterprise
b) standard
c) all the editions
d) VPS
e) business critical

A

c) all the editions

56
Q

what is the minimum billing charge for provisioning a warehouse?

a) 60 minutes
b) 1 minute
c) 1 second
d) no charge

A

b) 1 mintue

57
Q

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

A

e) internal named stages

58
Q

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

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

59
Q

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

A

c) suspending the warehouse

60
Q

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

A

d) 124 seconds

61
Q

what are the correct SQL extension used in querying data from time travel ?

a) BEFORE
b) AFTER
c) INITAL
d) AT

A

a) BEFORE

d) AT

62
Q

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

A

c) only subsequent queries

63
Q

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

A

b) AUTO_RESUME = TRUE

64
Q

which of the following database objects can be cloned in snowflake?

a) schemas
b) databases
c) tables
d) all the editions
e) file formats

A

d) all the editions

65
Q

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

A

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

66
Q

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

A

c) MIN_CLUSTER_COUNT = 1, MAX_CLUSTER_COUNT = 4

d) minimum and maximum number of clusters are specified differently

67
Q

which SQL statements can work on a cloned table?

a) DROP table command
b) SELCT command
c) SHOW command
d) All of these

A

d) all of these

68
Q

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

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

69
Q

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

TRUE or FALSE

A

TRUE

70
Q

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

A

TRUE

71
Q

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.

A

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

72
Q

a virtual warehouse can’t access data loaded in the table using different warehouse

TRUE or FALSE

A

FALSE

73
Q

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

TRUE or FALSE

A

TRUE

74
Q

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

A

b) John should not set AUTO_SUSPEND

75
Q

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

TRUE or FALSE

A

TRUE

76
Q

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

A

LIFO(“LAST IN, FIRST OUT”)

77
Q

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

A

d) 256

78
Q

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

A

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

79
Q

which type of table has 7 days fail-safe period

a) permant
b) temporary
c) external
d) transient

A

a) permant

80
Q

Micro-partitioning is automatically perfrmed on all the snowflake tables

TRUE or FALSE

A

TRUE

81
Q

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

A

c) scaling policy

d) minimum and maximum clusters

82
Q

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

A

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

83
Q

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

a) MODIFY
b) MONITOR
c) USAGE
d) OPERATE

A

b) MONITOR

84
Q

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

A

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

85
Q

Time travel cannot be disabled for an account

TRUE or FALSE

A

TRUE

86
Q

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

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

87
Q

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

A

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

88
Q

what is the default time-travel retention periof of enterprise edition?

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

A

b) 90 days

89
Q

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

A

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

90
Q

only snowflake employee can recover data from fail-safe storage

TRUE or FALSE

A

TRUE

91
Q

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

A

c) 6 minutes

92
Q

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

TRUE or FALSE

A

FALSE

93
Q

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

A

b) compressed size

c) amount stored - daily average

94
Q

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

A

FALSE

95
Q

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.

A
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';
96
Q

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

a) you have a heavy, steady workload for the warehouse

c) you require the warehouse to be available with no delay or lag time

97
Q

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

YES or NO

A

NO

98
Q

virtual warehouse in snowflake refers to

a) database
b) data warehouse
c) virtual storage
d) compute engine

A

d) compute engine

99
Q

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

TRUE or FALSE

A

TRUE

100
Q

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

TRUE or FALSE

A

TRUE

101
Q

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

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

102
Q

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

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

103
Q

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

A

d) 1 day

104
Q

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

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

105
Q

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

A

d) execute use warehouse command