Snowflake Virtual Warehouses ||Snowflake virtual warehouses || Snowflake storage and Protection Flashcards
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
increasing the size of a warehouse always improves data loading performance
TRUE or FALSE
FALSE
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
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
john wants to create a warehouse which can auto spend in 10 minutes. how should he configure the warehouse?
AUTO_SUSPEND = 600
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
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;
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;
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
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
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%’;
compute can be scaled up, down, out or in and there is no effect on storage used
TRUE or FALSE
TRUE
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
who owns and manages the cloud storage layer hosted on cloud providers?
a) snowflake
b) customer
c) cloud provider
a) snowflake
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
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 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
scaling a warehouse OUT will increase the number of clusters
TRUE or FALSE
TRUE
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
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”;
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
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
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
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;
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;