Download Snowflake Certification Questions and Answers and more Exams Data Warehousing in PDF only on Docsity!
Snowflake Certification questions with
answers
True or False: Data Storage is independent from compute? - .... 🔰 VERIFIED ANSWERS.... ✔✔ True True or False: All virtual warehouses have access to all data? - .... 🔰 VERIFIED ANSWERS.... ✔✔ True True or False: Al interactions with data are initialized through the services layer? - .... 🔰 VERIFIED ANSWERS.... ✔✔ True True or False: Multi-Cluster Warehouses support high concurrency? - .... 🔰 VERIFIED ANSWERS.... ✔✔ True True or False: Warehouses can be dynamically expanded to adjust to workloads? - .... 🔰 VERIFIED ANSWERS.... ✔✔ True Which layer provides centralized services for the data warehouse? - .... 🔰 VERIFIED ANSWERS.... ✔✔ Cloud Services Which layer contains virtual warehouses for data access? - .... 🔰 VERIFIED ANSWERS.... ✔✔ Query Processing Which layer contains the data in compressed, columnar format? - .... 🔰 VERIFIED ANSWERS.... ✔✔ Database Storage
True or False: Snowflake's security and authentication includes Multi-Factor authentication? - .... 🔰 VERIFIED ANSWERS.... ✔✔ True True or False: Snowflake's security and authentication includes Snowflake Failures alerts? - .... 🔰 VERIFIED ANSWERS.... ✔✔ False True or False: Snowflake's security and authentication includes data encryption using Snowflake-managed keys? - .... 🔰 VERIFIED ANSWERS.... ✔✔ False True or False: Snowflake's security and authentication includes object-level access? - .... 🔰 VERIFIED ANSWERS.... ✔✔ 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? - .... 🔰 VERIFIED ANSWERS.... ✔✔ True True or False: Snowflake's architecture includes advance capabilities in the cloud services layer that delivers metadata service? - .... 🔰 VERIFIED ANSWERS.... ✔✔ True True or False: Snowflake's architecture includes advance capabilities in the cloud services layer that delivers security and authentication control? - .... 🔰 VERIFIED ANSWERS.... ✔✔ True
True or False: Stages are unique database objects in Snowflake?
- .... 🔰 VERIFIED ANSWERS.... ✔✔ True True or False: Pipe are unique database objects in Snowflake? - .... 🔰 VERIFIED ANSWERS.... ✔✔ True True or False: Table are unique database objects in Snowflake? - .... 🔰 VERIFIED ANSWERS.... ✔✔ 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 - .... 🔰 VERIFIED ANSWERS.... ✔✔ D) All of the above True or False: Snowflake Support Services addresses customer issues covering troubleshooting failed queries? - .... 🔰 VERIFIED ANSWERS.... ✔✔ True True or False: Snowflake Support Services addresses customer issues covering product usage questions? - .... 🔰 VERIFIED ANSWERS.... ✔✔ True
True or False: Snowflake Support Services addresses customer issues covering individual query syntax improvement? - .... 🔰 VERIFIED ANSWERS.... ✔✔ True True or False: Snowflake Support Services addresses customer issues covering 3rd party application configuration support? - .... 🔰 VERIFIED ANSWERS.... ✔✔ False Snowflake users with support contracts that have a Severity- issue should contact Snowflake in these ways except: A) Snowflake Lodge - set appropriate severity (1-4) B) Send email C) 844-SNOWFLAKE - .... 🔰 VERIFIED ANSWERS.... ✔✔ B) Send email True or False: The Snowflake Lodge is a community site that has technical information for Support Customers only? - .... 🔰 VERIFIED ANSWERS.... ✔✔ False True or False: The Snowflake Lodge is a community site that is the recommend place to submit support cases? - .... 🔰 VERIFIED ANSWERS.... ✔✔ True True or False: The Snowflake Lodge is a community site that contains the most up to date security alerts and product release information? - .... 🔰 VERIFIED ANSWERS.... ✔✔ True
True or False: Grant Privilege permission can be granted within a Snowflake account by the administrator? - .... 🔰 VERIFIED ANSWERS.... ✔✔ True Snowflake provides specific administration features and capabilities to support the following activities except: A) Managing databases and warehouses within a Snowflake account B) Managing roles and users within a Snowflake account C) Monitoring Usage and manage resources to control costs in a Snowflake account D) Manage 3rd party applications providing data to a Snowflake account - .... 🔰 VERIFIED ANSWERS.... ✔✔ 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? - .... 🔰 VERIFIED ANSWERS.... ✔✔ Snowflake's Cloning A defined data set can be shared with customers outside the Snowflake account is? - .... 🔰 VERIFIED ANSWERS.... ✔✔ 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) - .... 🔰 VERIFIED ANSWERS.... ✔✔ C) Enterprise for Sensitive (ESD) True or False: Caching techniques are supported by Snowflake's performance optimizing query methods? - .... 🔰 VERIFIED ANSWERS.... ✔✔ True True or False: B-tree type indexes are supported by Snowflake's performance optimizing query methods? - .... 🔰 VERIFIED ANSWERS.... ✔✔ False True or False: Retrieving results of previous query from cache is supported by Snowflake's performance optimizing query methods? - .... 🔰 VERIFIED ANSWERS.... ✔✔ True True or False: Snowflake security supports user-based access control? - .... 🔰 VERIFIED ANSWERS.... ✔✔ True True or False: Federated authentication in Snowflake is complaint with SAML 2.0? - .... 🔰 VERIFIED ANSWERS.... ✔✔ True True or False: Tri-secret requires that customers manage their own keys? - .... 🔰 VERIFIED ANSWERS.... ✔✔ True
True or False: MFA (Multi-factor Authentication) is an integrated feature powered by Duo Security service? - .... 🔰 VERIFIED ANSWERS.... ✔✔ True True or False: MFA (Multi-factor Authentication) can be used for connecting to Snowflake via the Snowflake JDBC driver? - .... 🔰 VERIFIED ANSWERS.... ✔✔ True True or False: MFA (Multi-factor Authentication) login is desired only for connecting to Snowflake through the web interface? - .... 🔰 VERIFIED ANSWERS.... ✔✔ False Snowflake includes Role-Based Access Control to enable administrators to: A) Limit access to data and privileges 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 - .... 🔰 VERIFIED ANSWERS.... ✔✔ 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? - .... 🔰 VERIFIED ANSWERS.... ✔✔ True With an IdP (identity provider) configured for your account, Snowflake supports using SSO to connect and authenticate with Python Connector? - .... 🔰 VERIFIED ANSWERS.... ✔✔ True
With an IdP (identity provider) configured for your account, Snowflake supports using SSO to connect and authenticate with JDBC Driver? - .... 🔰 VERIFIED ANSWERS.... ✔✔ True With an IdP (identity provider) configured for your account, Snowflake supports using SSO to connect and authenticate with SnowSQL? - .... 🔰 VERIFIED ANSWERS.... ✔✔ 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 - .... 🔰 VERIFIED ANSWERS.... ✔✔ D) All of the above True or False: Different editions of Snowflake instances require separate accounts? - .... 🔰 VERIFIED ANSWERS.... ✔✔ True True or False: Snowflake instances in different regions require separate accounts? - .... 🔰 VERIFIED ANSWERS.... ✔✔ True True or False: Data can be shared READ ONLY across accounts, and can be cloned accounts? - .... 🔰 VERIFIED ANSWERS.... ✔✔ False
A) Single place for data, both structured and semi-structured B) Minimal management C) Instant and live data sharing D) Pay a set monthly fee for DWaaS and support E) Instant and unlimited on-demand scalability in both Storage and Compute F) All of the above - .... 🔰 VERIFIED ANSWERS.... ✔✔ A, B, C, & E Select all layers that are part of Snowflake architecture: A) Security B) Compute C) Memory D) Storage E) Query Optimization F) Transaction Management G) Cloud Services H) Metadata Management - .... 🔰 VERIFIED ANSWERS.... ✔✔ 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 - .... 🔰 VERIFIED ANSWERS.... ✔✔ 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 - .... 🔰 VERIFIED ANSWERS.... ✔✔ 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 - .... 🔰 VERIFIED ANSWERS.... ✔✔ B) Scaling_Policy
After 5 to 6 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. Semi-structured data strings are stored in a column with a Snowflake data type of __________________? A) Object B) Character C) Varchar D) Variant E) None of the above - .... 🔰 VERIFIED ANSWERS.... ✔✔ D) Variant Not A) Object - key pair values like Hadoop When sizing a Snowflake warehouse, which of the following factors should not be considered: A) Number of users B) Number of concurrent queries C) Number of tables being queried D) Data size and composition E) All of the above - .... 🔰 VERIFIED ANSWERS.... ✔✔ A) Number of Users - if users are not querying the database, then they don't take any resources Snowflake utilizes per _______________ billing.
A) Millisecond B) Second C) Minute D) Hour E) None of the above - .... 🔰 VERIFIED ANSWERS.... ✔✔ B) Second True or False: Each server in a cluster has a position. Servers are always removed from the warehouse in reverse order of when they were added (aka LIFO, "Last In, First Out") - .... 🔰 VERIFIED ANSWERS.... ✔✔ True True or False: The size of the cache is determined by the number of servers in the all of warehouses for an account - .... 🔰 VERIFIED ANSWERS.... ✔✔ False - size of the cache is determined by the number of servers in a warehouse. Snowflake has three types of caching to optimize performance. Select the three types of caches from the list: A) Server B) Warehouse C) Client D) Results E) Security F) Metadata G) Database
True or False: Warehouse cache may be reset or invalidated if the Virtual Warehouse is suspended and resumed? - .... 🔰 VERIFIED ANSWERS.... ✔✔ True True or False: Semi-structured data can be queried using SQL while incorporating JSON path notation? - .... 🔰 VERIFIED ANSWERS.... ✔✔ True True or False: In general, you should try to match the size of the warehouse to the expected size and complexity of the queries to be processed by the warehouse? - .... 🔰 VERIFIED ANSWERS.... ✔✔ True SQL functionality can be extended via (select all of the appropriate answers): A) SQL User Functions (UDF) B) Javascript UDFs C) Session Variables D) Only SQL and Javascript UDFs E) None of - .... 🔰 VERIFIED ANSWERS.... ✔✔ A, B, and C True or False: A customer needs to have a preexisting account with AWS or MicroSoft Azure in order to have a Snowflake account or to use Snowflake? - .... 🔰 VERIFIED ANSWERS.... ✔✔ False - not a requirement
How many availability zones does Snowflake replicate to for disaster recovery and high availability? A) Zero B) One C) Three D) As many as the user specifies in the configuration - .... 🔰 VERIFIED ANSWERS.... ✔✔ C) Three - Snowflake automatically does this for each account. It is built-in and fully managed by Snowflake True or False: Snowflake only replicates Storage layer to the other availability zones within a region? - .... 🔰 VERIFIED ANSWERS.... ✔✔ False - Storage and Cloud Services layers are replicated True or False: Multi-region accounts are supported by Snowflake? - .... 🔰 VERIFIED ANSWERS.... ✔✔ False - Each Snowflake accounts is located in a single region Snowflake is currently available on the following Cloud Providers: A) AWS B) Google C) Microsoft's Azure G) All of the above - .... 🔰 VERIFIED ANSWERS.... ✔✔ A & C - Google is not support, but is coming in the future
