Snowflake Overview and Architecture | Performance and Tuning Flashcards
1
Q
which of the following have driver/connectors ( or information about where to find them) available via Help->downloads in the snowflake WebUI?
a) Kafka
b) spark
c) node.js
d) JDBC
e) Go
f) C
A
b) spark
c) node.js
d) JDBC
e) Go
2
Q
if you click on “History” in the ribbon, how far back in time are you able to view history?
A
14 days
3
Q
Snowflake offers the early access of staged release to designated standard edition customer. true or false?
A
FALSE
4
Q
To change the warehouse that will be used to run a SQL command within a specific worksheet ( for example, changing the worksheet so that it uses large), what two options are available?
a) update the warehouse field in the context menu located above the worksheet
b) go to the worksheet properties page and set the warehouse field to LARGE_WH
c) run a SQL command like “SET WAREHOUSE CONTEXT=LARGE_WH”
d) run a SQL command like “USE WAREHOUSE LARGE_WH”
A
a) update the warehouse field in the context menu located above the worksheet
d) run a SQL command like “USE WAREHOUSE LARGE_WH”
5
Q
what are the types of caches?
a) metadata cache
b) history cache
c) result cache
d) storage cache
A
a) metadata cache
c) result cache
6
Q
each time the persisted result for query is reused, snowflake resets the 24-hour retention period for the result, up to maximum of 31 days from the date and time that the query was first executed. True or False?
A
TRUE
7
Q
John ran a query which took around 30 minutes. He referred to query profiler, and found the ‘Bytes spilled to local storage has big number. what could the issue be?
a) John is using very large warehouse
b) John is using a comparatively smaller warehouse
c) warehouse-size has no impact n bytes spilling
d) John should contact snowflake personnel
A
b) John is using a comparatively smaller warehouse
8
Q
John wants to share a VIEW with Monica but John wants to hide view definition and details from Monica. What type of view John should create and share with Moncia?
a) materialized
b) None
c) Secured
d) Standard
A
c) Secured
9
Q
Please choose the correct table type from the given access
a) external
b) permanent
c) transient
d) temporary
e) internal
A
a) external
b) permanent
c) transient
d) temporary
10
Q
if you find a date-related tool that is not listed as part of the snowflake ecosystem, what industry standard options could you check for a way to easily connect to snowflake?
a) check to see if the tool can connect to other solutions via JDBC
b) check to see if there is a petition in the community to create driver
c) check to see if you can develop a driver and put it on GitHub
d) check to see if the tool can connect to other solutions via ODBC
A
a) check to see if the tool can connect to other solutions via JDBC
d) check to see if the tool can connect to other solutions via ODBC
11
Q
Which of the following are valid context functions?
a) CURRENT_CLOUD_INFRASTRUCTURE()
b) CURRENT_REGION()
c) CURRENT_SESSION()
d) CUURENT_WORKSHEET()
e) CURRENT_CLIENT()
A
b) CURRENT_REGION()
c) CURRENT_SESSION()
e) CURRENT_CLIENT()
12
Q
which approach would result in improved performance through linear scaling of data ingestion workload?
a) resize virtual warehouse
b) consider the practice of splitting input file batch within the recommended range of 10MB to 100MB
c) all of these
d) consider the practice of organizing data by granular path
A
c) all of these
13
Q
you create a sequence in snowflake with an initial value of 3 and an interval of 2. what are the series of numbers you would be expected to see?
A
3, 5, 7, 9, 11
14
Q
which of the following snowflake editions automatically store data in an encrypted state?
a) enterprise
b) business-critical
c) standard
A
a) enterprise
b) business critical
c) standard
15
Q
which cache stores object definitions and statics?
a) warehouse cache
b) results cache
c) metadata cache
A
c) metadata
16
Q
a snowflake customer is responsible for all the maintenance and services. TRUE or FALSE
A
FALSE
17
Q
how often does snowflake release new features?
A
weekly
18
Q
which statement accurately describes the snowflake cloud services layer?
a) a collection of tightly coupled database management features
b) a collection of independent, scalable, and stateless services providing crucial data management capabilities
c) a set of cloud providers’ general services made available to users via the internet
d) managed and scaled by the user
A
b) a collection of independent, scalable, and stateless services providing crucial data management capabilities
19
Q
which is not the security function of the cloud services layer?
a) access control for users and roles
b) authentication
c) access control for shares
d) encryption and key management
e) pruning using metadata about micro-partitions
A
e) pruning using metadata about micro-partitions
20
Q
New or modified data in tables in a share are immediately not available to all consumers who have created a database from a share
TRUE or FLASE
A
FALSE
21
Q
snowflake offers rich set of drivers and connectors to connect with external applications. select the connectors from the list
a) python
b) spark
c) node.js
d) JDBC
e) Kafka
A
a) python
b) spark
e) Kafka
22
Q
which view behaves like a table and gets auto-refreshed?
a) standard
b) secured
c) none
d) materialized
A
d) materialised
23
Q
snowflake is a cloud data platform delivered as a service. TRUE or FALSE
A
TRUE
24
Q
stored procedure supports
a) python
b) go
c) javascript
d) java (using snowpark)
e) SQL
A
c) javascript
d) java (using snowpark)
25
if a query is slow, how can the query be changed to improve the query?
a) reorder the list of tables in the query to change the order the tables are read in the query
b) use an order by on the query to order the data before it's searched
c) provide a hint to the optimizer
d) change the order of where clause to force the optimizer to consider the most effective filter first
e) if possible, use the table's defined cluster key in the query
e) if possible, use the table's defined cluster key in the query
26
which of these values must return a value?
a) both
b) stored procedure
c) user-defined function
c) user-defined function
27
which tables type disappers after the close of the session and therefore has no-fail safe, and no time travel options after the close of the session?
temporary
28
which type of view is most like a table?
a) standard
b) materialsed
c) secure
d) external
b) materialsed
29
which is not the function of optimization activities of cloud services layer?
a) handles queries that can be processes completely from metadata
b) pruning using metadata about micro-partitions
c) automatic JOIN order optimization
d) automatic statistic gathering
a) handles queries that can be processes completely from metadata
30
which command will return infrmation about the current database?
a) RETURN current_database();
b) SELECT current_database();
c) USE current_database();
d) QUERY current_database();
b) SELECT current_database();
31
can you have a database overlap across two snowflake account?
Yes or No
No
32
which of the following snowflake editions encrypt all data transmitted over the network within a virtual private cloud (VPC)?
a) business-critical
b) standard
c) enterprise
a) business ciritical
33
which of the following are performed by the cloud services layer? (select 4)
a) user authentication
b) data security
c) availability zone management
d) metadata storage
e) metadata management
a) user authentication
b) data security
d) metadata storage
e) metadata management
34
please choose all the securable objects from the given options
a) schema
b) udf
c) database
d) external table
e) stored procedure
a) schema
b) udf
c) database
d) external table
e) stored procedure
35
which is not the function under metadata management of cloud service layer?
a) used for time travel and cloning
b) handles queries that can be processes completely from metadata
c) used for storing physical micro partition
d) stores metadata as data is loaded into the system
c) used for storing physical micro partition
36
which cache type runs on a 24 hour clock?
results cache
37
objects that are dropped from a shared database and then recreated with the same name are not immediately available in the share; you must execute grant usage on the objects to make them available. TRUE or FALSE
TRUE
38
a snowflake account can be hosted on any of the many cloud platforms. please select all the correct answers.
a) azure
b) AWS
c) oracle cloud
d) GCP
e) dropbox
a) azure
b) AWS
d) GCP
39
when choosing a geographic deployment region, what factors might an enrollee consider?
a) number of availability zones within a region
b) additional fees charged for regions with geo-political unrest
c) end-user perceptions of glamorous or trendy geographic locations
d) promimity to the point of service
a) number of availability zones within a region
| d) promimity to the point of service
40
you have a dashboard that connects to Snowflake via JDBC. the dashboard is refreshed hundreds of times per day. The data is very stable, only changing once or twice per day. the query run by the dashboard connector user never changes. How will snowflake amange changing and non-chnagin data? mark all true statements?
a) snowflake will spin up a warehouse only if the underlying data has changed
b) snowflake will spin up a warehouse each time the dashboard is refreshed
c) snowflake will compile results cache data from all users results so no warehouse is needed
d) snowflake will show the most up-to-date data each time the dashboard is refreshed
e) snowflake will re-use data from the results cache as long as it is still the most up-to-date data available
a) snowflake will spin up a warehouse only if the underlying data has changed
d) snowflake will show the most up-to-date data each time the dashboard is refreshed
e) snowflake will re-use data from the results cache as long as it is still the most up-to-date data available
41
who can create shares?
a) ROLE with CREATE SHARES global privilege
b) ACCOUNTADMIN
a) ROLE with CREATE SHARES global privilege
| b) ACCOUNTADMIN
42
how is the most effective way to test if clustering a table helped performance?
a) USE SYSTEM$CLUSTERING_INFORMATION. check the total_constant_partition_count
b) Use the SYSTEM$CLUSTERING_DEPTH and check the depth of each column
c) Use SYSTEM$CLUSTERING_DEPTH and check the average overlaps
d) run a sample query before clustering and after to compare the results
e) Use SYSTEM$CLUSERTING_INFORMATION, check the average_depth
d) run a sample query before clustering and after to compare the results
43
the best method to assit pruning on a large table is to:
a) create a clustered index on the table
b) define a cluster key for the table
c) create a dense index on the table
e) define a partitioning key on table
f) define a hash table for the table
b) define a cluster key for the table
44
# choose the right hierarchy of snowflake objects from the given options
a) ACCOUNT> DATABASE > SCHEMA> TABLE
b) ACCOUNT> STAGE> DATABASE> SCHEMA> TABLE
c) ACCOUNT> SCHEMA> DATABASE> TABLE
d) ACCOUNT> DATABASE> STAGE> SCHEMA
a) ACCOUNT> DATABASE > SCHEMA> TABLE
45
which SQL statement will need a running warehouse and consumer credit? consider table created as - CREATE OR REPLACE TABLE T1 (ID NUMBER(2), Name varchar(20), salary number (11,2));
a) SELECT COUNT(*) FROM T1;
b) SELECT AVG(ID) FROM T1;
c) SELECT MIN(ID) FROM T1;
d) SELECT MAX(ID) FROM T1;
b) SELECT AVG(ID) FROM T1;
46
which are the options available for SECUIRTYADMIN in snowflake UI ribbon? (choose all applicable)
a) history
b) account
c) data exchange
d) warehouses
e) notifications
a) history
b) account
d) warehouses
47
which type of view has an extra layer of protection to hide the SQL code from unauthorised viewing?
a) standard
b) permanent
c) secure
d) materialized
c) secure
48
no need to grant usage on new objects created a database in a share in order for them to be available to consumers. TRUE or FALSE
FALSE
49
whcih statements accuratley describe the snowflake data sharing?
a) when creating views in a share, secured views are required
b) a share can contain more than one database
c) data sharing is only supported between accounts in the same snowflake region
d) a share can't be cloned by consumer
a) when creating views in a share, secured views are required
c) data sharing is only supported between accounts in the same snowflake region
d) a share can't be cloned by consumer
50
how many maximum columns (or expressions) are recommended fo a cluster key?
a) 7 to 8
b) 3 to 4
c) higher the number of columns (or expressions) in the key, better will be performance
d) 12 to 16
b) 3 to 4
51
A CAST command (symbol) will force a value to be output as a certain datatype. which of the following code samples will result in the "employeename" being output using the VARCHAR datatypes?
a) SELECT VARCHAR(employeename)
b) SELECT employeename AS VARCHAR
c) SELECT employeename||VARCHAR
d) SELECT employeenmae::VARCHAR
d) SELECT employeenmae::VARCHAR
52
Snowflake datawarehouse is not built on an existing database or "big data" software platform such as Hadoop. TRUE or FALSE
True
53
who pays for the compute usage of the reader account?
Consumer or Provider
provider
54
the following SQL statement will require a running warehouse
'CREATE TABLE T1 (NAME(VARCHAR20), ADDRESS VARCHAR (50));
TRUE or FLASE
FALSE
55
what are the best practices for JOIN on unique keys?
a) avoid MANY-TO-MANY join
b) avoid intentional cross join
c) use distinct keys
a) avoid MANY-TO-MANY join
b) avoid intentional cross join
c) use distinct keys
56
what type of privelege data consumer should have to adminster shares?
a) show share
b) export share
c) list share
d) import shares
d) import shares
57
which of the following are snowflake view types? (select 3)
a) secure
b) materialized
c) permanent
d) trainsent
e) standard
a) secure
b) materialized
e) standard
58
whihc of the following terms or phrases can also be used to describe snowflake? (select 4)
a) Hadoop-compliant
b) build from the ground up for the cloud
c) Native SQL
d) Multi-cluster
e) hybrid Consumer
b) build from the ground up for the cloud
c) Native SQL
d) Multi-cluster
e) hybrid Consumer
59
snowflake pffers mutliple editions. which ones is not an offering from snowflake
a) business critical
b) enterprise
c) premium
d) standard
c) premium
60
each snowflake account comes with two shared databases. one is set of sample data and the other contains account usage information. check all true statements about these shared databases.
a) SNOWFLAKE conatsin a table called ACCOUNT_USAGE
b) SNOWFLAKE_SMAPEL_DATA contains a schema called ACCOUTN_USAGE
c) ACCOUNT_USAGE is a schema filled with external tables
d) SNOWFLAKE contains a schema called ACCOUNT_USAGE
e) ACCOUNT USAGE is a schema filled with secure views
d) SNOWFLAKE contains a schema called ACCOUNT_USAGE
| e) ACCOUNT USAGE is a schema filled with secure views
61
Snowflake calculates usage of data stored in the syetem for:
a) database tables, including historical data for time travel
b) cloud storage used in external stage
c) files staged for bulk data loading/unloading
d) fail-safe for database tables
e) clones of database tables that reference data deleted in the tables that owns the clones
a) database tables, including historical data for time travel
c) files staged for bulk data loading/unloading
d) fail-safe for database tables
e) clones of database tables that reference data deleted in the tables that owns the clones
62
Snowflake resousce and monitor allows adminstrators to set thresholds and triggers to track credit usage. what methods are most effective for resourcing monitoring?
a) setting quota thresholds for trigger actions and notifications
b) tracking and controlling credit consumption on a monthly basis
c) tracking consumption on an hourly basis
d) control global monthly credit usage for an account
a) setting quota thresholds for trigger actions and notifications
b) tracking and controlling credit consumption on a monthly basis
d) control global monthly credit usage for an account
63
two virtual warehhouses can access the same data at the same time without causing contention issues. TRUE or FALSE
TRUE
64
once the snowflake account is provisioned, user can access snowflake using the following methods:
a) any 3rd party partner that can connect to snowflake
b) snowSQL, the snowflake command line client
c) broswer-based web interface
d) any client application connected via JDBC or ODBC
a) any 3rd party partner that can connect to snowflake
b) snowSQL, the snowflake command line client
c) broswer-based web interface
d) any client application connected via JDBC or ODBC
65
if you are defining a multi-column clustering key of a table, the order in which the columns are specided in the cluster by clauses is important. as general rule, snowflake recommends:
a) order doesn't matter
b) ordering the columns from lowest cardinality to highest cardinality
c) ordering the columns from highest cardinality to lowest cradinality
b) ordering the columns from lowest cardinality to highest cardinality
66
John created a table EMPLOYEE in worksheet 1 (session 1) but when he ran SELECT*WHERE FROM EMPLOYEE in worksheet 2(session2) after setting up the correct role, database and schema, he received error' Table doesn't exist' what could be the reason?
a) EMPLOYEE is temporary table
b) XYZ is transient table
c) XYZ was created as external table
d) XYZ is a permanent table
a) EMPLOYEE is temporary table
67
you craetea new worksheet in the WebUI. you want to set the role, warehouse, database and schema context that will be used when running the SQL code. which of the following options listed here are valid?
a) use fully qualified references to the role and warehouse in each select statement
b) run four " USE" commands, setting each context with a separate statement
c) use the context drop menu in the upper right corner of the worksheet
d) run the SET_CONTEXT(role, warehouse, database, schema) command
b) run four " USE" commands, setting each context with a separate statement
c) use the context drop menu in the upper right corner of the worksheet
68
snowflake is best suited for OLAP solutions
TRUE or FASLE
TRUE
69
if you want to view query history older than 14 days, where can you go to view it? choose one path and one term commonly used.
a) history-> profiler -> account_usage
b) the usage sharing monitor
c) the account usage share
d) SNOWFLAKE (Database) -> ACCOUNT_USAGE (schema) -> Query_History(secure view)
e) account -> usage -> history
c) the account usage share
| d) SNOWFLAKE (Database) -> ACCOUNT_USAGE (schema) -> Query_History(secure view)
70
which of the following options would result in a column named first name being sandwiched between to percentage signs?
a) MERGEDSTRING('%',FIRST_NAME,'%')
b) CONCATN('%',FRIST_NAME,'%')
c) CONCAT('%',CONCAT(FIRST_NAME,'%'))
d) '%'||FIRST_NAME||'%'
c) CONCAT('%',CONCAT(FIRST_NAME,'%'))
| d) '%'||FIRST_NAME||'%'
71
which layer is responsible for data secuirty and authentication?
a) storage layer
b) cloud services
c) cloud agnostic layer
d) compute layer
d) cloud services
72
a query you initiated is taking too long. you've gone into the history area to check whether this query (which usually runs every hour) is supposed to take a long time.
a) if you decided to end the query, you must return to the worksheet to abort the query
b) information in the history area can be filtered to show a single session
c) information in the history area can be filtered to show a single warehouse
d) information in the history area can be filtered to show a single user
e) information in the history area can help you visually compare query times
b) information in the history area can be filtered to show a single session
e) information in the history area can help you visually compare query times
73
in the history page, a query shows bytes scanned having assigned partitions: 110, scanned partitions 58, and original partitions 110. why did the optimizer show fewer partitions scanned than assigned?
a) one of the tables in the query was an external table and didn't have micro partitions. the metadata for the table was out of date and there were really only 58 partitions total
b) the query was using an Xlarge warehouse and could scan the partitions in parallel
c) the static optimization determined the number of possible micro partitions would be 110 but the dynamic optimization was able to prune some of the partitions from a joined table
d) during the execution of the query, new data was added to the table and the optimizer had to add those micro partitions into the scan
c) the static optimization determined the number of possible micro partitions would be 110 but the dynamic optimization was able to prune some of the partitions from a joined table
74
what all objects can be shared?
a) secure view
b) table
c) secure udf
d) standard view
a) secure view
b) table
c) secure udf
75
snowflake decouples storage and compute. in case of increase in compute usages, storage usage also increases........
TRUE or FALSE
FALSE
76
Snowflake is a packaged software offering that can be installed by a user
TRUE or FALSE
FALSE
77
SQL clause which helps defining the clustering key:
a) clustering on
b) cluster by
c) cluster on
d) clustering by
b) cluster by
78
which cache type gets purged regularly?
a) warehouse cache
b) metadata cache
c) results cache
c) results cache
79
secured view can be used to hide the definition but its performance can get degraded?
TRUE or FALSE
TRUE
80
user-defined function supports
a) Java
b) python
c) javascript
d) go
e) SQL
a) Java
c) Jaavascript
e) SQL
81
Can you share data with multiple consumers with row based access control?
Yes or No
Yes
82
which query will require compute (virtual warehouse)?
Consider table created as - CREATE or REPLACE TABLE T1 (ID number(2), Name varchar(20), ID number(11,2));
a) SHOW DATABASE;
b) SELECT *FROM T1;
c) SELECT CURRENT_ACCOUNT();
d) SELECT MAX(ID0 FROM T1;
e) SELECT MIN(ID) FROM T1;
b) SELECT *FROM T1;
83
what is the higest term for snowflake architecture
a) shared network
b) shared disk
c) shared memory
d) shared data
e) shared nothing
d) shared data
84
which tables will experience the most benefit from clsuetring?
a) tables with sizes between the range of 1GB to 10GB compressed
b) all sizes of tables
c) tables with sizes between the range of 100MB to 1 GB compressed
d) tables in the multi-terabyte (TB) range
d) tables in the multi-terabyte (TB) range
85
Which of the following workload is snowflake suited for?
a) data applications
b) data sharing and exchanges
c) data lakes
d) data warehouse
e) data engineering
f) data science
a) data applications
b) data sharing and exchanges
c) data lakes
d) data warehouse
e) data engineering
f) data science
86
which of the following object types are child objects within schemas?
a) roles
b) stages
c) sequences
d) stored procedures
e) UDF (user defined functions)
f) file formats
b) stages
c) sequences
d) stored procedures
e) UDF (user defined functions)
f) file formats
87
snowflake follows the staged release process for new releases. how many days it takes to normally to complete all the stages of the staged releases?
a) 7 days
b) 1 day
c) 3 days
d) 2 days
d) 2 days
88
select all the features snowflake supports:
a) SQL- based transformation
b) a graphical UI to build datapipelines
c) semi-structured data
d) unstructured data
e) dedicated resource for compute
a) SQL- based transformation
c) semi-structured data
e) dedicated resource for compute
89
there are two types of snowflake planned releases. please choose all applicable
a) upgrade release
b) patch release
c) full release
d) installation release
b) patch release
| c) full release
90
John is having SECURITYADMIN role. he created custom DBA_ROLE. he granted SYSADMIN role to DRA_ROLE. he created a user 'Monica'. John granted DBA_ROLE to Monica. Monica creates a database Monica_DB under Public schema. what should john do access table T1 created by Monica?
a) granted role DBA_ROLE to John; USE DATABASE monica_db; select* from t1;
b) use role dba_role; use database monica_db; select*fromt1;
c) grant role DBA_role to john; use role dba_role: use database monica_db; select* from t1;
d) use role securityadmin; use database monica_db; select * from t1;
c) grant role DBA_role to john; use role dba_role: use database monica_db; select* from t1;
91
if snowflake hostname is hhtp://bbx99999.us-east-1.snowflakecomputing.com, what is the customer Full account name?
a) bbx99999.us-east-1.snowflakecomputing
b) bbx99999.us-east-1
c) bbx99999
d) us-east-1
e) snowflakecomputing
b) bbx99999.us-east-1
92
what is the name of the noswflake-produced command line interface tool?
a) snow command
b) snowSQL
c) snowCLI
d) SnowConnect
b) SnowSQL
93
which of these can access database obejcts and issue SQL statements?
a) both
b) stored procedure
c) user-defined function
b) stored procedure
94
reclustering in snowflake is automatic. TRUE or FALSE
TRUE
95
a user can connect snowlfake in mutliple ways. please select.
a) command line clients
b) any 3rd party partner that can connect to snowflake
c) browser-based web interface
d) any client application connected via JDBC or ODBC
a) command line clients
b) any 3rd party partner that can connect to snowflake
c) browser-based web interface
d) any client application connected via JDBC or ODBC
96
each share contains a single datbase, and all other objects included in the share must be from this same database TRUE or FALSE
FALSE
97
snowflake adminstrations should utilize resource monitors to help control costs and avoid unexcepted credit usage. which of the following actions can snowflakes resources monitor triggers initiate automatically?
a) impose limits on the number of credits that warehouses consume each month
b) trigger alert notifications for high usage
c) roll over query executions to under-utilised warehouses
d) trigger warehouses suspension for high usage
a) impose limits on the number of credits that warehouses consume each month
b) trigger alert notifications for high usage
d) trigger warehouses suspension for high usag
98
an hour ago, you ran a complex query. you then ran several simple queries from the same worksheet. You want to export the results from the complex query but they are no longer loaded in the results pane of the worksheet. what is the least costly way to download the results?
a) click on history -> locate the query -> click "download results" in column 3
b) type the command select results(-3) into the worksheet and click "run"
c) type the command select results (, ,) int he worksheet and click "run"
d) click on history -> locate the query -> click the queryId -> use the "export result" button
d) click on history -> locate the query -> click the queryId -> use the "export result" button
99
user a and b can access one another's result sets from the results cache, as long as which of the following are true? (select two)
a) they use the same role
b) they use the same warehouse
c) they run the exact same SQL text/query
d) they sign in tp the same session
e) they run with 59 minutes of one another
a) they use the same role
| c) they run the exact same SQL text/query
100
which query will require compute (virtual warehouse)? consider table created as - CREATE or REPLACE TABLE T1( ID number ("), Name varchar(20), ID number (11,2);
a) SELECT COUNT (*) FROM T1;
b) SELECT MAX(ID) FROM T1 WHERE NAME = 'JOHN';
c) SELECT MIN(ID) FROM T1;
d) SELECT AVG(ID) FROM T1;
e) SELECT MIN(ID) FROM T1 WHERE NAME ='JOHN';
f) SELECT MAX(ID) FROM T1;
b) SELECT MAX(ID) FROM T1 WHERE NAME = 'JOHN';
d) SELECT AVG(ID) FROM T1;
e) SELECT MIN(ID) FROM T1 WHERE NAME ='JOHN';
101
the BI group is complaining about their queries taking too long to run. checking the virtual warehouse information shows the queued time is pretty high. what is the best way to fix this issue?
a) determine which users have the high priority queries and set the other users
b) increase the virtual warehouse MAX_CLUSTER_COUNT property
c) increase the size of the virtual warehouse
d) STATEMENT_QUEUED_TIMEOUT_IN_SECONDS parameter to a low value to cancel those queries if they get in the queue
e) increase the virtual warehouse MAXCONCURRENCY_LEVEL parameter
f) provide a virtual warehouse for every user in the group
b) increase the virtual warehouse MAX_CLUSTER_COUNT property
102
what does ETL stand for?
Extract, Transform. Load
103
which actions are not supported with shared data?
a) editing the comments for a shared database
b) can be re-shared by data consumer
c) time travel for a shared database or any schemas/tables in the database
d) creating a clone of a shared database or any schema/tables in the database
a) editing the comments for a shared database
b) can be re-shared by data consumer
c) time travel for a shared database or any schemas/tables in the database
d) creating a clone of a shared database or any schema/tables in the database
104
snowflake architecture consists of many separate layers. please select the correct layers
a) security layer
b) query processing layer
c) cloud services layer
d) database storage layer
b) query processing layer
c) cloud services layer
d) database storage layer
105
if another object gets added to the shared database. will consumers be able to see it immediately?
YES or NO
NO
106
which of the following are unique objects introduced by snowflake?
a) stage
b) table
c) pipe
a) stage
| c) pipe
107
clustering keys are not intended for all tables
TRUE or FALSE
TRUE
