Uncategorized Snowflake Screening Test by mfh.officials@gmail.com Jan 9, 2025 0 Comment Snowflake 1 / 20 What is the role of the query profiler in Snowflake? To load external data sources To schedule query execution times To identify bottlenecks in query execution To back up queries 2 / 20 What is a Snowflake Virtual Warehouse? A storage location for semi-structured data An external data connector A logical compute resource for processing queries A physical server in the cloud 3 / 20 What file formats can Snowflake natively load and process? HTML files only XML and TXT files only CSV, JSON, Parquet, ORC, and Avro Only CSV and JSON 4 / 20 What does "zero-copy cloning" in Snowflake mean? Using temporary tables for queries Cloning a database with limited compute resources Creating clones without duplicating the underlying data Using external storage for cloned data 5 / 20 What is a role in Snowflake? A set of permissions assigned to users A virtual machine instance A data storage layer A query execution engine 6 / 20 Which of the following compliance certifications is held by Snowflake? GDPR All of the above ISO 27001 HIPAA 7 / 20 Which caching mechanism improves Snowflake performance? Storage cache Result cache Metadata cache Query cache 8 / 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 9 / 20 What is Snowpipe? A data ingestion service for continuous loading of data A security feature for encryption A query optimization feature A logging service for data pipelines 10 / 20 What is the purpose of multi-cluster warehouses in Snowflake? To encrypt data across multiple clusters To store large datasets To handle variable query workloads To back up data automatically 11 / 20 Which feature in Snowflake enables secure data sharing across accounts? Virtual Private Cloud Data Pipeline Snowpipe Sharing Secure Data Sharing 12 / 20 Which of the following statements is true about Snowflake’s storage? It is auto-scalable and decoupled from compute. It requires manual configuration for scaling. It cannot store semi-structured data. It uses SSD drives for storage. 13 / 20 What is Time Travel in Snowflake? A backup and recovery mechanism A way to move data between warehouses A feature to migrate data between clouds The ability to query historical data for a defined retention period 14 / 20 What type of data can Snowflake store? Unstructured data only Structured data only Metadata only Semi-structured and structured data 15 / 20 How does Snowflake handle concurrency? By limiting users to one query at a time By caching queries at the storage layer By isolating workloads using multiple virtual warehouses By creating physical partitions 16 / 20 Which command is used to clone a table in Snowflake? CLONE TABLE COPY TABLE CREATE TABLE CLONE ALTER TABLE CLONE 17 / 20 Which layer of Snowflake architecture handles query execution? Cloud Services Layer Virtual Warehouse Layer Data Pipeline Layer Storage Layer 18 / 20 Which cloud providers support Snowflake? AWS only Azure and Google Cloud only AWS, Azure, and Google Cloud AWS and IBM Cloud only 19 / 20 What is the default retention period for Time Travel in Snowflake? 90 days 30 days 1 day 7 days 20 / 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. Your score isThe average score is 10% 0% Restart quiz
Leave a Reply Cancel replyYour email address will not be published. Required fields are marked *Comment Name* Email* Save my name, email, and website in this browser for the next time I comment.
Leave a Reply