Snowflake Screening TestBy mfh.officials@gmail.com / January 9, 2025 Snowflake 1 / 20 What is the role of the query profiler in Snowflake? To load external data sources To back up queries To identify bottlenecks in query execution To schedule query execution times 2 / 20 How does Snowflake ensure data security? By using end-to-end encryption and role-based access control By disabling data export functionality Through on-premises encryption only By restricting data sharing 3 / 20 What is a Snowflake Virtual Warehouse? A physical server in the cloud An external data connector A storage location for semi-structured data A logical compute resource for processing queries 4 / 20 Which feature in Snowflake enables secure data sharing across accounts? Virtual Private Cloud Data Pipeline Snowpipe Sharing Secure Data Sharing 5 / 20 What is Time Travel in Snowflake? The ability to query historical data for a defined retention period A backup and recovery mechanism A feature to migrate data between clouds A way to move data between warehouses 6 / 20 What file formats can Snowflake natively load and process? Only CSV and JSON CSV, JSON, Parquet, ORC, and Avro HTML files only XML and TXT files only 7 / 20 Which caching mechanism improves Snowflake performance? Storage cache Query cache Metadata cache Result cache 8 / 20 What is a role in Snowflake? A set of permissions assigned to users A data storage layer A query execution engine A virtual machine instance 9 / 20 Which command is used to clone a table in Snowflake? CREATE TABLE CLONE COPY TABLE CLONE TABLE ALTER TABLE CLONE 10 / 20 Which of the following compliance certifications is held by Snowflake? ISO 27001 HIPAA All of the above GDPR 11 / 20 What type of data can Snowflake store? Metadata only Structured data only Unstructured data only Semi-structured and structured data 12 / 20 What type of database architecture does Snowflake use? Distributed-memory with no shared resources Multi-tenant with shared-disk and shared-nothing hybrid Shared-memory A. Monolithic B. C. D. 13 / 20 Which of the following statements is true about Snowflake’s storage? It cannot store semi-structured data. It uses SSD drives for storage. It is auto-scalable and decoupled from compute. It requires manual configuration for scaling. 14 / 20 Which layer of Snowflake architecture handles query execution? Virtual Warehouse Layer Storage Layer Data Pipeline Layer Cloud Services Layer 15 / 20 What is Snowpipe? A security feature for encryption A data ingestion service for continuous loading of data A logging service for data pipelines A query optimization feature 16 / 20 Which cloud providers support Snowflake? AWS only AWS and IBM Cloud only AWS, Azure, and Google Cloud Azure and Google Cloud only 17 / 20 What is the default retention period for Time Travel in Snowflake? 1 day 30 days 90 days 7 days 18 / 20 How does Snowflake handle concurrency? By creating physical partitions By isolating workloads using multiple virtual warehouses By caching queries at the storage layer By limiting users to one query at a time 19 / 20 What is the purpose of multi-cluster warehouses in Snowflake? To encrypt data across multiple clusters To store large datasets To back up data automatically To handle variable query workloads 20 / 20 What does "zero-copy cloning" in Snowflake mean? Using external storage for cloned data Using temporary tables for queries Creating clones without duplicating the underlying data Cloning a database with limited compute resources Your score isThe average score is 10% 0% Restart quiz
By
/ January 9, 2025 By
/ January 9, 2025 By
/ January 9, 2025 By
/ January 9, 2025 By
/ January 9, 2025 By
/ January 9, 2025