Download Snowflake Query Throughput and Cloud Services and more Exams Public Health in PDF only on Docsity!
Which roles does Snowflake suggest to enable MFA (select all that apply?
A) SECURITYADMIN
B) SYSADMIN
C) ACCOUNTADMIN
D) User defined role
E) PUBLIC
F) All of the above -answer>>>A, B, & C
True or False: Users can have access to many roles and they are active in every session? -answer>>> False - only one active role per session
True or False: Users own database objects? -answer>>> False - roles own database objects
Which of the following are security best practices for Snowflake (select all that apply)?
A) All objects owned by SYSADMIN
B) All roles and users are own by SECURITYADMIN
C) Grant all of your roles back to SYSADMIN
D) All of the above -answer>>>D) All of the above
What is the frequency for Snowflake to apply software patches to the code base?
A) Daily
B) Weekly
C) Monthly
D) Semi-annually
E) As soon as they are ready -answer>>>B) Weekly
True or False: Customer has COMPUTE choices when it comes to cluster definition? -answer >>>False - COMPUTE clusters are predefined by Azure and AWS
When scaling up a Snowflake warehouse, what is the scaling factor when moving between T-shirt sizes?
A) 2
B) 4
C) 8
D) User specified -answer>>>A) 2
When dealing with a large complex query, the user must:
What are the types of tables in Snowflake (select all that apply)?
A) Regular
B) Transient
C) Permanent
D) Clones
E) Temporary
F) Persistent -answer>>>B, C, and E
How many resource monitors can you have at the account level?
A) 0
B) 1
C) 2
D) up to 5
E) unlimited -answer>>>B) 1
What is the largest size of a micro-partition?
A) 8 MB uncompressed
B) 8 MB compressed
C) 16 MB compressed
D) 32 MB compressed -answer>>>C) 16 MB compressed
Which of the following are actions that can be take from a Resource Monitor trigger (select all that apply)?
A) Suspend
B) Shutdown
C) Suspend immediately
D) Notify
E) All of the above -answer>>>A, C, and D
Which of the following conditions can restart a suspended Resource monitor (select all that apply)?
A) The credit threshold for the monitor trigger is increased
B) The monitor is no longer assigned to the warehouse
C) Increase in customer quota
D) A new time interval cycle has starts
E) All of the above -answer>>>A, B, and D
True or False: A warehouse can be assigned to one or more Resource monitors? - answer>>> False - warehouses can be assigned to only one resource monitor.
True or False: A virtual warehouse can only be resized after being stopped or suspended? -answer>>>False - a virtual warehouse can be resized at any time.
True or False: User can query a STAGE object? -answer>>>True
True or False: Data Storage is independent from compute? -answer>>>True
True or False: All virtual warehouses have access to all data? -answer>>>True
True or False: Al interactions with data are initialized through the services layer? - answer>>>True
True or False: Multi-Cluster Warehouses support high concurrency? - answer>>>True
True or False: Warehouses can be dynamically expanded to adjust to workloads? - answer>>>True
Which layer provides centralized services for the data warehouse? - answer>>>Cloud Services
Which layer contains virtual warehouses for data access? -answer>>>Query Processing
Which layer contains the data in compressed, columnar format? - answer>>>Database Storage
True or False: Snowflake's security and authentication includes Multi-Factor authentication? -answer>>>True
True or False: Snowflake's security and authentication includes Snowflake Failures alerts? -answer>>>False
True or False: Snowflake's security and authentication includes data encryption using Snowflake-managed keys? -answer>>>False
True or False: Snowflake's security and authentication includes object-level access? -answer>>>True
True or False: Snowflake's architecture includes advance capabilities in the cloud services layer that delivers transaction management for consistent operations on the same data at the same time? -answer>>>True
True or False: Snowflake's architecture includes advance capabilities in the cloud services layer that delivers metadata service? -answer>>>True
True or False: Snowflake's architecture includes advance capabilities in the cloud services layer that delivers security and authentication control? -answer>>>True
True or False: Pipe are unique database objects in Snowflake? -answer>>>True
True or False: Table are unique database objects in Snowflake? -answer>>>False
Which approach would result in improved performance through linear scaling of data ingestion workload:
A) Resize virtual warehouse
B) Consider the practice of organizing data by granular path
C) Consider the practice of splitting input file batch within the recommended range of 10MB and 100MB?
D) All of the above -answer>>>D) All of the above
True or False: Snowflake Support Services addresses customer issues covering troubleshooting failed queries? -answer>>>True
True or False: Snowflake Support Services addresses customer issues covering product usage questions? -answer>>>True
True or False: Snowflake Support Services addresses customer issues covering individual query syntax improvement? -answer>>>True
True or False: Snowflake Support Services addresses customer issues covering 3rd party application configuration support? -answer>>>False
Snowflake users with support contracts that have a Severity-1 issue should contact Snowflake in these ways except:
A) Snowflake Lodge - set appropriate severity (1-4)
B) Send email
C) 844-SNOWFLAKE -answer>>>B) Send email
True or False: The Snowflake Lodge is a community site that has technical information for Support Customers only? -answer>>>False
True or False: The Snowflake Lodge is a community site that is the recommend place to submit support cases? -answer>>>True
True or False: The Snowflake Lodge is a community site that contains the most up to date security alerts and product release information? -answer>>>True
True or False: The Snowflake Lodge is a community site that does not allow members to post questions? -answer>>>False
Snowflake includes administration settings for resource consumption in order to:
A) Help control costs associated with unexpected credit usage of warehouses
C) Monitoring Usage and manage resources to control costs in a Snowflake account
D) Manage 3rd party applications providing data to a Snowflake account - answer>>>D) Manage 3rd party applications providing data to a Snowflake account
A defined data set is a point in time snapshot and can be updated by customers is? -answer>>>Snowflake's Cloning
A defined data set can be shared with customers outside the Snowflake account is? -answer>>>Snowflakes's Data Sharing
Query statement encryption is supported on ___________ accounts?
A) Standard
B) Enterprise
C) Enterprise for Sensitive (ESD)
D) Virtual Private Snowflake (VPS) -answer>>>C) Enterprise for Sensitive (ESD)
True or False: Caching techniques are supported by Snowflake's performance optimizing query methods? -answer>>>True
True or False: B-tree type indexes are supported by Snowflake's performance optimizing query methods? -answer>>>False
True or False: Retrieving results of previous query from cache is supported by Snowflake's performance optimizing query methods? -answer>>>True
True or False: Snowflake security supports user-based access control? - answer>>>True
True or False: Federated authentication in Snowflake is complaint with SAML 2.0? -answer>>>True
True or False: Tri-secret requires that customers manage their own keys? - answer>>>True
All security information is stored in the ___________ layer in the Snowflake architecture?
A) Storage
B) Compute
C) Service
D) All of the above -answer>>>C) Service
True or False: One benefit of client-side encryption is that it provides a secure system for managing data in cloud storage? -answer>>>True
B) Manage secure access to the Snowflake account and data
C) Establish role hierarchy and privilege inheritance to align access
D) All of the above -answer>>>D) All of the above
With an IdP (identity provider) configured for your account, Snowflake supports using SSO to connect and authenticate with ODBC Driver? -answer>>>True
With an IdP (identity provider) configured for your account, Snowflake supports using SSO to connect and authenticate with Python Connector? -answer>>>True
With an IdP (identity provider) configured for your account, Snowflake supports using SSO to connect and authenticate with JDBC Driver? -answer>>>True
With an IdP (identity provider) configured for your account, Snowflake supports using SSO to connect and authenticate with SnowSQL? -answer>>>
Choosing separate accounts in Snowflake enables users to have:
A) Different editions of Snowflake and different regions
B) Billing at the account level
C) Simpler database object deployment between environments
D) All of the above -answer>>>D) All of the above
True or False: Different editions of Snowflake instances require separate accounts? -answer>>>True
True or False: Snowflake instances in different regions require separate accounts? -answer>>>True
True or False: Data can be shared READ ONLY across accounts, and can be cloned accounts? -answer>>>False
An enterprise view of data is useful because:
A) A data set can be stored once and shared multiple times
B) Data set provisioning is assigned to the owner of the data set
C) Data sets can be shared securely
D) All of the above -answer>>>D) All of the above
True or False: Data Sharing is only supported between accounts in the same Snowflake region? -answer>>>True
True or False: A share can't be cloned by a consumer account, but the share data CAN be copied into a table? -answer>>>True
True or False: Data can be shared Read-Only across Snowflake accounts and can also be cloned? -answer>>>False
G) Cloud Services
H) Metadata Management -answer>>>B, D, & G
Select all characteristics of Snowflake's Multi-Cluster environment:
A) Multiple virtual warehouses in a deployment
B) User has to specify which cluster each query will utilize
C) Individual warehouses automatically scale up and down base on query activity
D) Multi-cluster warehouses support all the same properties and actions as single- cluster warehouse
E) All of the above -answer>>>A, C, and D
Select the two types of modes that a Multi-Cluster Warehouses:
A) Statically
B) Dynamically
C) Maximized
D) Auto-Scale
F) None of the above -answer>>>C & D
To help control the usage of credits in Auto-scale mode, Snowflake provides a property, _________________, that determines the scaling policy to use when automatically starting or shutting down additional clusters. Select the property:
A) Auto_Scale
B) Scaling_policy
C) Maximum_number_of_server_clusters
D) Minimum_number of server clusters
E) None of the above -answer>>>B) Scaling_Policy
Standard Scaling Policy -answer>>>Definition:
Prevents/minimizes queuing by favoring starting additional clusters over conserving credits.
Cluster Starts....
Immediately when either a query is queued or the system detects that there's one more query than the currently-running clusters can execute.
Cluster Shuts down....
After 2 to 3 consecutive successful checks (performed at 1 minute intervals), which determine whether the load on the least-loaded cluster could be redistributed to the other clusters without spinning up the cluster again.
Economy Scaling Policy -answer>>>Definition:
Conserves credits by favoring keeping running clusters fully-loaded rather than starting additional clusters, which may result in queries being queued and taking longer to complete. (default setting)
