Snowflake Certification Practice Test 11
Practice Test 11
Snowflake Certification Practice Test 11
Practice Test 11
Insightful Saga — Modern Data Engineering Certification Preparation
Question 181
## Question 181 A newly joined Snowflake Support Engineer receives a Sev-2 incident at 2:00 AM. The Finance department reports that the daily revenue dashboard did not refresh. Investigation shows: - Source files arrived successfully - Snowpipe completed successfully - Stream contains unprocessed records - Dashboard table was not updated What should the engineer investigate FIRST?
Since Snowpipe loaded data and the Stream contains pending changes, the next likely failure point is the Task that processes Stream records. ---
Question 182
## Question 182 A retail company reports that today's sales numbers appear twice as high as expected. During investigation the engineer finds that the same source file was loaded twice. What should be reviewed FIRST?
Question 183
## Question 183 A business user opens a ticket saying: "My report was running in 20 seconds last week. Today it takes more than 10 minutes." What is the BEST first step?
Question 184
## Question 184 A global insurance company notices Snowflake credit consumption doubled overnight. No new projects were deployed. What should engineers investigate first?
Question 185
## Question 185 A nightly CDC pipeline processed successfully. However, 5,000 customer updates are missing from the reporting layer. Which area should be investigated FIRST?
Question 186
## Question 186 A healthcare company receives a complaint that sensitive patient values are visible to unauthorized analysts. What should be reviewed immediately?
Question 187
## Question 187 An ETL workflow succeeds every day except Mondays. The support engineer observes significantly higher source volume on Mondays. What is the MOST likely area to investigate?
Question 188
## Question 188 A production task stopped executing. The underlying SQL works correctly when run manually. What should be checked next?
Question 189
## Question 189 A company reports inconsistent revenue figures across two dashboards. Both dashboards use different underlying datasets. What should engineers investigate?
Question 190
## Question 190 A support engineer receives an alert that warehouse utilization is continuously above 95%. Users also report delays. What should be evaluated first?
Question 191
## Question 191 A newly deployed ETL process suddenly starts failing after a schema change in the source system. What should be investigated first?
Question 192
## Question 192 A finance team reports yesterday's data is missing from reports. Investigation reveals that source files never arrived in cloud storage. What is the root cause category?
Question 193
## Question 193 A production warehouse remains running even when no users are active. Management asks Support to reduce costs immediately. What should be checked?
Question 194
## Question 194 A Stream suddenly contains millions of records waiting to be processed. Business reports are now delayed. What should the engineering team investigate first?
Question 195
## Question 195 A company performs a production deployment Friday evening. On Saturday users begin reporting incorrect calculations. What should be reviewed first?
Question 196
## Question 196 A healthcare reporting workflow failed overnight. Support engineers need to identify exactly which step failed. What should be reviewed first?
Question 197
## Question 197 A Snowflake administrator notices that one department consistently consumes far more credits than expected. Leadership requests accountability. What should be implemented?
Question 198
## Question 198 A newly joined Support Engineer receives repeated alerts for the same pipeline every night. Each incident is caused by a temporary network timeout. What long-term recommendation should be made?
Question 199
## Question 199 A business executive asks why a Gold reporting table suddenly contains fewer records than expected. What investigation approach should be taken FIRST?
Question 200
## Question 200 A newly hired Snowflake Production Support Lead is asked: "What is the most important goal of a production support team?" Choose the BEST answer.
A Snowflake production support team is responsible for maintaining stable operations, resolving incidents, preventing outages, and ensuring business-critical workloads continue running successfully. --- --- title: Snowflake Certification Practice Test 12 description: Advanced Architect and Enterprise Platform Design Scenarios ---