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