Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Snowflake SnowPro Core Certificates > Snowflake Overview and Architecture | Performance and Tuning > Flashcards

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

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

if you click on “History” in the ribbon, how far back in time are you able to view history?

A

14 days

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

Snowflake offers the early access of staged release to designated standard edition customer. true or false?

A

FALSE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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”

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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()

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

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

which cache stores object definitions and statics?

a) warehouse cache
b) results cache
c) metadata cache

A

c) metadata

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

a snowflake customer is responsible for all the maintenance and services. TRUE or FALSE

A

FALSE

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

how often does snowflake release new features?

A

weekly

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

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

which view behaves like a table and gets auto-refreshed?

a) standard
b) secured
c) none
d) materialized

A

d) materialised

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

snowflake is a cloud data platform delivered as a service. TRUE or FALSE

A

TRUE

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

stored procedure supports

a) python
b) go
c) javascript
d) java (using snowpark)
e) SQL

A

c) javascript

d) java (using snowpark)

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

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

A

e) if possible, use the table’s defined cluster key in the query

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

which of these values must return a value?

a) both
b) stored procedure
c) user-defined function

A

c) user-defined function

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

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?

A

temporary

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

which type of view is most like a table?

a) standard
b) materialsed
c) secure
d) external

A

b) materialsed

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

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

a) handles queries that can be processes completely from metadata

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

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();

A

b) SELECT current_database();

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

can you have a database overlap across two snowflake account?

Yes or No

A

No

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

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

a) business ciritical

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

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

a) user authentication
b) data security
d) metadata storage
e) metadata management

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

please choose all the securable objects from the given options

a) schema
b) udf
c) database
d) external table
e) stored procedure

A

a) schema
b) udf
c) database
d) external table
e) stored procedure

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

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

A

c) used for storing physical micro partition

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

which cache type runs on a 24 hour clock?

A

results cache

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

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

A

TRUE

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

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

a) azure
b) AWS
d) GCP

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

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

a) number of availability zones within a region

d) promimity to the point of service

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

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

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

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

who can create shares?

a) ROLE with CREATE SHARES global privilege
b) ACCOUNTADMIN

A

a) ROLE with CREATE SHARES global privilege

b) ACCOUNTADMIN

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

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

A

d) run a sample query before clustering and after to compare the results

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

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

A

b) define a cluster key for the table

44
Q

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

a) ACCOUNT> DATABASE > SCHEMA> TABLE

45
Q

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;

A

b) SELECT AVG(ID) FROM T1;

46
Q

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

a) history
b) account
d) warehouses

47
Q

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

A

c) secure

48
Q

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

A

FALSE

49
Q

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

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
Q

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

A

b) 3 to 4

51
Q

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

A

d) SELECT employeenmae::VARCHAR

52
Q

Snowflake datawarehouse is not built on an existing database or “big data” software platform such as Hadoop. TRUE or FALSE

A

True

53
Q

who pays for the compute usage of the reader account?

Consumer or Provider

A

provider

54
Q

the following SQL statement will require a running warehouse

‘CREATE TABLE T1 (NAME(VARCHAR20), ADDRESS VARCHAR (50));

TRUE or FLASE

A

FALSE

55
Q

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

a) avoid MANY-TO-MANY join
b) avoid intentional cross join
c) use distinct keys

56
Q

what type of privelege data consumer should have to adminster shares?

a) show share
b) export share
c) list share
d) import shares

A

d) import shares

57
Q

which of the following are snowflake view types? (select 3)

a) secure
b) materialized
c) permanent
d) trainsent
e) standard

A

a) secure
b) materialized
e) standard

58
Q

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

A

b) build from the ground up for the cloud
c) Native SQL
d) Multi-cluster
e) hybrid Consumer

59
Q

snowflake pffers mutliple editions. which ones is not an offering from snowflake

a) business critical
b) enterprise
c) premium
d) standard

A

c) premium

60
Q

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

A

d) SNOWFLAKE contains a schema called ACCOUNT_USAGE

e) ACCOUNT USAGE is a schema filled with secure views

61
Q

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

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
Q

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

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
Q

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

A

TRUE

64
Q

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

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
Q

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

A

b) ordering the columns from lowest cardinality to highest cardinality

66
Q

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

a) EMPLOYEE is temporary table

67
Q

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

A

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
Q

snowflake is best suited for OLAP solutions

TRUE or FASLE

A

TRUE

69
Q

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

A

c) the account usage share

d) SNOWFLAKE (Database) -> ACCOUNT_USAGE (schema) -> Query_History(secure view)

70
Q

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

A

c) CONCAT(‘%’,CONCAT(FIRST_NAME,’%’))

d) ‘%’||FIRST_NAME||’%’

71
Q

which layer is responsible for data secuirty and authentication?

a) storage layer
b) cloud services
c) cloud agnostic layer
d) compute layer

A

d) cloud services

72
Q

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

A

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
Q

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

A

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
Q

what all objects can be shared?

a) secure view
b) table
c) secure udf
d) standard view

A

a) secure view
b) table
c) secure udf

75
Q

snowflake decouples storage and compute. in case of increase in compute usages, storage usage also increases……..

TRUE or FALSE

A

FALSE

76
Q

Snowflake is a packaged software offering that can be installed by a user

TRUE or FALSE

A

FALSE

77
Q

SQL clause which helps defining the clustering key:

a) clustering on
b) cluster by
c) cluster on
d) clustering by

A

b) cluster by

78
Q

which cache type gets purged regularly?

a) warehouse cache
b) metadata cache
c) results cache

A

c) results cache

79
Q

secured view can be used to hide the definition but its performance can get degraded?

TRUE or FALSE

A

TRUE

80
Q

user-defined function supports

a) Java
b) python
c) javascript
d) go
e) SQL

A

a) Java
c) Jaavascript
e) SQL

81
Q

Can you share data with multiple consumers with row based access control?

Yes or No

A

Yes

82
Q

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;

A

b) SELECT *FROM T1;

83
Q

what is the higest term for snowflake architecture

a) shared network
b) shared disk
c) shared memory
d) shared data
e) shared nothing

A

d) shared data

84
Q

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

A

d) tables in the multi-terabyte (TB) range

85
Q

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

a) data applications
b) data sharing and exchanges
c) data lakes
d) data warehouse
e) data engineering
f) data science

86
Q

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

A

b) stages
c) sequences
d) stored procedures
e) UDF (user defined functions)
f) file formats

87
Q

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

A

d) 2 days

88
Q

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

a) SQL- based transformation
c) semi-structured data
e) dedicated resource for compute

89
Q

there are two types of snowflake planned releases. please choose all applicable

a) upgrade release
b) patch release
c) full release
d) installation release

A

b) patch release

c) full release

90
Q

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

A

c) grant role DBA_role to john; use role dba_role: use database monica_db; select* from t1;

91
Q

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

A

b) bbx99999.us-east-1

92
Q

what is the name of the noswflake-produced command line interface tool?

a) snow command
b) snowSQL
c) snowCLI
d) SnowConnect

A

b) SnowSQL

93
Q

which of these can access database obejcts and issue SQL statements?

a) both
b) stored procedure
c) user-defined function

A

b) stored procedure

94
Q

reclustering in snowflake is automatic. TRUE or FALSE

A

TRUE

95
Q

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

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
Q

each share contains a single datbase, and all other objects included in the share must be from this same database TRUE or FALSE

A

FALSE

97
Q

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

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
Q

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

A

d) click on history -> locate the query -> click the queryId -> use the “export result” button

99
Q

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

a) they use the same role

c) they run the exact same SQL text/query

100
Q

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;

A

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
Q

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

A

b) increase the virtual warehouse MAX_CLUSTER_COUNT property

102
Q

what does ETL stand for?

A

Extract, Transform. Load

103
Q

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

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
Q

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

A

b) query processing layer
c) cloud services layer
d) database storage layer

105
Q

if another object gets added to the shared database. will consumers be able to see it immediately?

YES or NO

A

NO

106
Q

which of the following are unique objects introduced by snowflake?

a) stage
b) table
c) pipe

A

a) stage

c) pipe

107
Q

clustering keys are not intended for all tables

TRUE or FALSE

A

TRUE

Snowflake SnowPro Core Certificates (3 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions