Snowflake Certification Practice Test 09
Practice Test 09
Snowflake Certification Practice Test 09
Practice Test 09
Insightful Saga — Modern Data Engineering Certification Preparation
Question 141
## Question 141 Statement 1: A Stream can capture row-level changes made to a source table. Statement 2: A Stream automatically performs ETL processing.
Streams track changes but do not execute processing logic themselves. ---
Question 142
## Question 142 Statement 1: Snowpipe is designed for automated continuous ingestion. Statement 2: Snowpipe eliminates the need for staging files.
Question 143
## Question 143 Statement 1: Time Travel can be used to access historical data versions. Statement 2: Time Travel is intended primarily for query performance optimization.
Question 144
## Question 144 Statement 1: Zero-Copy Cloning initially avoids duplicating physical data. Statement 2: Cloning requires a full copy of underlying storage at creation time.
Question 145
## Question 145 Statement 1: Multi-Cluster Warehouses help address concurrency challenges. Statement 2: Multi-Cluster Warehouses increase the storage capacity of Snowflake tables.
Question 146
## Question 146 Statement 1: Resource Monitors help organizations manage credit consumption. Statement 2: Resource Monitors can trigger alerts when usage thresholds are reached.
Question 147
## Question 147 Statement 1: Materialized Views store precomputed query results. Statement 2: Materialized Views may improve performance for repetitive workloads.
Question 148
## Question 148 Statement 1: Dynamic Data Masking can hide sensitive values based on user access. Statement 2: Dynamic Data Masking permanently removes sensitive data.
Question 149
## Question 149 Statement 1: Row Access Policies can filter visible rows based on user context. Statement 2: Row Access Policies primarily control warehouse scaling behavior.
Question 150
## Question 150 Statement 1: A Virtual Warehouse provides compute resources. Statement 2: A Virtual Warehouse stores table data.
Question 151
## Question 151 Statement 1: Tags can be used to classify Snowflake data assets. Statement 2: Tags are commonly used in governance initiatives.
Question 152
## Question 152 Statement 1: External Stages can reference files stored outside Snowflake. Statement 2: External Stages require data to be copied into Snowflake-managed storage before access.
Question 153
## Question 153 Statement 1: Query Profile helps engineers investigate performance bottlenecks. Statement 2: Query Profile provides execution-level insights.
Question 154
## Question 154 Statement 1: Micro-partition pruning helps reduce data scanned during queries. Statement 2: Effective pruning can improve query performance.
Question 155
## Question 155 Statement 1: Auto Suspend helps reduce unnecessary compute costs. Statement 2: Warehouses consume credits while actively running.
Question 156
## Question 156 Statement 1: Secure Data Sharing allows consumers to access shared data without copying it. Statement 2: Data Sharing always requires the consumer to own a Snowflake account.
Reader Accounts can be used when consumers do not own Snowflake accounts. ---
Question 157
## Question 157 Statement 1: A CDC architecture generally processes only changed records. Statement 2: CDC implementations often reduce compute costs compared to full reloads.
Question 158
## Question 158 Statement 1: Role-Based Access Control improves security management. Statement 2: Granting permissions directly to thousands of individual users is usually easier to maintain.
Question 159
## Question 159 Statement 1: Audit logging supports compliance and governance requirements. Statement 2: Audit logging can help during security investigations.
Question 160
## Question 160 Statement 1: A scalable Snowflake platform should consider future growth in users, data volumes, and workloads. Statement 2: Enterprise architecture should prioritize only current requirements and ignore expected growth.
Successful enterprise Snowflake platforms are designed for growth, maintainability, governance, and scalability. --- --- title: Snowflake Certification Practice Test 10 description: Enterprise Architect Scenario Questions ---