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