Snowflake Certification Practice Test 04
Practice Test 04
Snowflake Certification Practice Test 04
Practice Test 04
Insightful Saga — Modern Data Engineering Certification Preparation
Question 61
## Question 61 A newly joined Data Engineer at a global retail company is assigned to investigate a reporting issue. The company stores more than 20 billion sales records in Snowflake. Business users frequently run reports filtered by: - country - store_id - transaction_date Over the last few months, report execution times increased from 20 seconds to nearly 8 minutes. The engineer reviews query history and notices that queries are scanning significantly more data than expected even though filters are being applied. The data itself is correct, but query performance continues to degrade as data volume grows. What should the engineer evaluate FIRST?
Since queries repeatedly filter on the same columns, clustering may improve pruning of micro-partitions and reduce scanned data. ---
Question 62
## Question 62 A banking company processes customer transactions 24 hours a day. During month-end reporting, hundreds of analysts execute dashboards simultaneously. Business users complain that reports become slower even though the warehouse size has not changed. A newly hired Snowflake Engineer discovers that warehouse CPU utilization reaches very high levels during peak reporting periods. Management wants faster report execution without modifying business logic. What is the MOST appropriate recommendation?
The issue is compute contention. Additional compute capacity can improve concurrency and query performance. ---
Question 63
## Question 63 A healthcare company stores eight years of patient billing records. Analysts usually query only the most recent 90 days of data. A new Data Engineer discovers that reports still scan large portions of historical data. The company wants to reduce query execution time while keeping all historical data available. Which optimization area should be investigated?
Snowflake should ideally eliminate unnecessary micro-partitions during query execution. ---
Question 64
## Question 64 A global airline company recently migrated to Snowflake. Data loads complete successfully every day. However, a dashboard used by airport operations teams runs the same query hundreds of times throughout the day. The underlying data changes only once every morning. Management wants to reduce compute consumption without changing the dashboard. Which Snowflake capability would MOST likely help?
Repeated execution of identical queries can leverage cached results. ---
Question 65
## Question 65 A manufacturing company receives sensor data from thousands of production machines. Data volume grows rapidly every month. The engineering team notices that query performance varies significantly depending on which sensor IDs are queried. Management asks the data team to improve performance for frequently searched sensor identifiers. What should be considered?
Search Optimization can improve access performance for highly selective queries. ---
Question 66
## Question 66 A telecommunications company has implemented several Snowflake warehouses. Management notices cloud costs increasing every month. Investigation reveals that many warehouses remain running overnight despite no user activity. The platform team wants to immediately reduce unnecessary spending. What should be recommended?
Warehouses incur compute charges while running. Auto Suspend minimizes idle compute costs. ---
Question 67
## Question 67 A newly hired Data Engineer reviews an ETL pipeline that creates thirty temporary tables every day. The process functions correctly, but storage consumption keeps growing unexpectedly. Leadership wants to understand whether obsolete objects are contributing to the issue. What should the engineer review first?
Unused temporary or intermediate objects can contribute to unnecessary storage consumption. ---
Question 68
## Question 68 A global insurance company runs thousands of queries every hour. Executives want better visibility into why some reports finish in seconds while others require several minutes. A Senior Snowflake Engineer is asked to investigate. Which Snowflake capability should be examined first?
Query Profile provides details regarding scans, joins, bottlenecks, and execution behavior. ---
Question 69
## Question 69 A retail company allows different business departments to share the same Snowflake environment. Finance users often execute large month-end queries while Marketing teams run campaign analytics simultaneously. Management wants workloads isolated so one department does not impact another. What should be recommended?
Independent virtual warehouses isolate compute resources and reduce contention. ---
Question 70
## Question 70 A pharmaceutical company maintains a business-critical dashboard. Executives expect the dashboard to refresh within seconds regardless of data volume growth. The engineering team notices that report performance continues to degrade as table sizes increase into billions of rows. Management asks the Snowflake Architect: "Without changing business requirements, what performance area should we continuously monitor as data volume grows?"
As datasets grow, efficient partition pruning becomes increasingly important for sustaining query performance. --- --- title: Snowflake Certification Practice Test 05 description: Advanced Performance and Cost Optimization Scenarios ---