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