SE Onboarding Product Knowledge Exam PDF

SE Onboarding Product Knowledge Exam Study Guide On Day 1 of Boot Camp you will complete a closed-book SE product exam. 80% or above is passing. This study guide features 50 questions; you will only be quizzed on 30 questions. Each learner will be presented with randomly selected questio...

SE Onboarding Product Knowledge Exam Study Guide On Day 1 of Boot Camp you will complete a closed-book SE product exam. 80% or above is passing. This study guide features 50 questions; you will only be quizzed on 30 questions. Each learner will be presented with randomly selected questions, so each exam will be different. 1) Snowflake is what “type” of database (pick the best answer)? a) Graph b) NoSQL c) Relational d) Multi-dimensional 2) Which of the following languages can be used to interact with Snowflake? a) SQL b) Python c) Java d) All of the above 3) In Snowflake, what is a virtual warehouse? a) A physical location where data is stored b) A compute cluster that processes queries c) A logical grouping of databases d) A data pipeline for ETL tasks 4) How does Snowflake handle data encryption? a) It uses SSL/TLS for data in transit and AES for data at rest b) It encrypts data only in transit c) It encrypts data only at rest d) It does not support data encryption 5) What is the purpose of the Snowflake data sharing feature? a) Sharing data across different Snowflake accounts b) Sharing data with non-Snowflake databases c) Sharing data within the same Snowflake account d) Sharing data with external storage systems 6) Which of the following is not a component of Snowflake's architecture? a) Database storage  b) Query processing engine c) OLAP cube service d) Metadata repository 7) Which semi-structured file formats are supported in Snowflake? (Choose 2) a) JSON b) PDF c) DICOM d) Parquet 8) What is one proper use of the time travel feature? a) To track changes over a long period of time (> 6 months) b) To perform real-time analytics c) To schedule data backups d) To quickly recover from dropping a table 9) Which two components are the main drivers of Snowflake's pricing model? a) Amount of data stored b) Amount of compute used c) Number of users d) Number of direct data shares 10) Which two of the following cloud provider tools are likely to integrate with Snowflake? a) AWS Glue b) Google BigQuery c) Microsoft Azure Data Factory d) AWS Redshift 11) Which term refers to Snowflake’s framework for managing access to database objects? a) Role-based access control (RBAC) b) Attribute-based access control (ABAC) c) Policy-based access control (PBAC) d) Role-based encryption control (RBEC) 12) Which Snowflake data type is designed for semi-structured data storage? a) VARIANT b) BLOB c) ARRAY  d) XML 13) Which Snowflake edition is certified for use with data subject to regulations like HIPAA and PCI? a) Standard Edition b) Enterprise Edition c) Community Edition d) Business Critical Edition 14) What are two benefits of Snowflake using cloud provider object storage (S3, GCS, Azure Storage) for persistent data? (Choose 2) a) High availability and durability b) Leverage cloud provider GUI storage tools c) Inexpensive storage d) Customer-configurable encryption algorithms 15) You are the owner of a table T1 which is in schema S1. The schema is in database D1. In order to grant read-only permissions of this table to a newly created role R1, you will need to…(Choose 3) a) Grant ‘USAGE’ on database D1 b) Grant ‘SELECT’ on database D1 c) Grant ‘USAGE’ on schema S1 d) Grant ‘SELECT’ on schema S1 e) Grant ‘USAGE’ on table T1 f) Grant ‘SELECT’ on table T1 16) Which two of the following are system defined roles? a) ACCOUNTADMIN b) ROLEADMIN c) SYSADMIN d) WAREHOUSEADMIN 17) What is the default maximum number of clusters in a multi-cluster Warehouse? a) 99 b) 50 c) Unlimited d) 10 18) (True or False) A Virtual Warehouse cluster can be scaled up and down (e.g. Medium to Large, Large to Small) automatically by Snowflake. 19) What’s the name of the special files that Snowflake creates when data is added to a Table? a) Binary Files b) Partitioned Files c) Micro-Partition Files d) Object Storage Files 20) Snowflake is deployed on which of these Cloud Providers? (choose all that apply) a) Google Cloud b) AWS c) Oracle Cloud d) Microsoft Azure 21) What is the main purpose of Snowflake Database Replication (choose the best answer) a) To implement High Availability across Availability Zones b) To replicate data across different clouds/regions for DR c) To backup databases within a Snowflake account d) To implement data sharing across 2 accounts in the same Cloud Region 22) (True/False) Increasing the size of a Virtual Warehouse by one step (e.g. going from Small to Medium) doubles the compute power of that warehouse. 23) What is the feature used for implementing Change Data Capture on a Snowflake table? a) Zero Copy Cloning b) Snowpipe c) Streams d) Snowpark 24) What is a Snowflake Stage? a) A Special table for storing raw data in Snowflake b) An object for referencing an external or internal cloud bucket c) An object for implementing a data lake zone d) An External Function for accessing unstructured data files 25) What’s the name of Snowflake’s Command Line Client?  a) SnowSQL b) SQLPlus c) SnowSquall d) Snowpark 26) Critical architecture components like Cloud Services and Optimized Storage operate at the cloud provider region level so Snowflake can survive the failure of an availability zone. What is a cloud provider availability zone? a) A group of related features that are enabled together b) A cluster of compute instances c) A physical data center d) A set of cloud provider services that are typically used together 27) To execute a Snowflake analytic query without fully qualified object names, you need to provide context. The context consists of the following. (choose all that apply) a) Organization b) Role c) Virtual Warehouse d) Database/Schema 28) What's the maximum configurable window for Time Travel? a) 10 days b) Unlimited c) 90 days d) 7 days 29) What's the main reason that a Multi-Cluster Warehouse will scale out? a) A user-defined schedule change b) An ALTER WAREHOUSE command that changes warehouse size (e.g. Xsmall to Medium) c) Query activity from users in a workload management group defined as "urgent" d) Increasing query queueing 30) At what level does Snowflake apply compression and collect metadata information? a) A micropartition file b) An entire table c) A materialized view d) A cloud provider storage location, like a S3 bucket 31) (True/False) When scaling a warehouse up (e.g. growing from Small to Xlarge) all query activity on the warehouse must finish before the resize is effective. 32) How do users establish a hierarchy of Role Based Access Control roles in Snowflake? a) GRANT one role to another role b) Define roles using the PARENT and CHILD keywords c) They don't, Snowflake roles are all independent from each other d) Define the hierarchy in a federated authentication system like Okta 33) (True/False) When processing DML against a table Snowflake edits the existing micropartition files. 34) What’s the significance of “clustering” as a concept in Snowflake? a) Grouping virtual warehouses together based on the type of query workload they will handle b) Storing data so similar values are grouped together in micropartition files c) Organizing tables and views into schemas d) Choosing whether to use a standard or Snowpark-optimized warehouse. 35) Which of the following scaling strategies is most effective at making a single query or unit of work run faster? a) Adjust the virtual warehouse’s auto-suspend configuration b) Increase the size of the virtual warehouse c) Change the warehouse’s scaling policy to “STANDARD” d) Distribute queries across more warehouses/clusters 36) Which of the following scaling strategies is most effective at handling a workload with several queries running simultaneously? a) Adjust the virtual warehouse’s auto-suspend configuration b) Increase the size of the virtual warehouse c) Change the warehouse’s scaling policy to “STANDARD” d) Distribute queries across more warehouses and/or clusters 37) What’s the main characteristic that distinguishes a Snowpark-optimized virtual warehouse from a standard one? a) Higher virtual core count b) Flash-based storage c) More RAM  d) Pre-loaded ML libraries 38) Which Snowflake entity owns Snowflake objects like tables, virtual warehouses, and databases? a) A role b) A user ID c) A cloud provider identity (e.g. a AWS IAM role) d) A group defined in the customer’s federated authentication provider 39) How much compute power does Snowpipe allocate to a data ingest job? a) The user decides, by tying Snowpipe to a specific virtual warehouse b) Orchestration engines like Airflow and dbt choose the virtual warehouse size c) Snowpipe automatically chooses how much compute to use d) It depends on whether the Snowpipe was created as STANDARD or ECONOMY 40) What are two primary strengths of Snowflake’s governance and security model? (Choose 2) a) managed via a graphical interface b) granular permissions via Role Based Access Control c) controls applied consistently regardless of access method d) Snowflake employees administer database and table security for customers 41) SnowGrid is our mechanism for connecting Snowflake environments globally and across clouds. Which two of the following depend on SnowGrid? a) data sharing and replication b) a presence in all regions for each cloud provider c) seamless connections to on premise storage d) Cross-region and cross-cloud failover 42) What’s one main security benefit of using Snowflake’s LLM and machine learning functionality? a) data doesn’t leave the secure Snowflake environment b) Snowflake employees review each call to LLMs or ML functions c) customers define their own encryption for LLM and ML activities d) Snowflake automatically masks sensitive data in output from LLM or ML applications 43) What does the term “data clean room” refer to?  a) Data used for scientific research b) Snowflake Marketplace c) Prepackaged data cleansing and normalization applications d) A mechanism for sharing and analyzing data in a privacy-preserving way 44) Which Snowflake feature allows users to “bring their own model” for AI/ML use cases? a) Zero-Copy Cloning b) Search Optimization Service c) Snowpark-optimized virtual warehouses d) Snowpark Container Services 45) What is the name of the Snowflake feature that allows a customer to “bring your own key” for encryption purposes? a) KeyTrust b) Tri-secret Secure c) Killswitch d) SnowSafe 46) Which built-in schema would you most likely query if you want to drill into credit consumption in a Snowflake account? a) SYSVIEW b) METERING c) ACCOUNT_USAGE d) SYSUSAGE 47) Which query does not require an active warehouse to run? a) SELECT COUNT(*) FROM T1 where col1=123; b) COPY INTO @export_stage SELECT * FROM T1 WHERE col1=123 ; c) DELETE FROM T1 WHERE col1=123; d) DESCRIBE TABLE T1; 48) Which query plan statistic is a good indicator of how effective data pruning is? a) Partitions scanned b) Percentage scanned from cache c) Bytes spilled to local storage d) Bytes read from result 49) Which one of these technologies would likely be involved in federated authentication? a) Snowflake oAuth  b) Java Web Tokens (JWT) c) PrivateLink d) Microsoft Azure Active Directory 50) Which three of these terms are usually associated with Snowflake Collaboration? (Choose 3) a) Snowflake Marketplace b) Auto Fulfillment c) Search Optimization Service d) Listings