Apache Airflow Certification Practice Test 09

Best and Most Cost-Effective Solution Questions

Question 1 of 20

📋 Multiple Choice

Question 161

A retail company runs 500 DAGs daily. Developers request additional workers because workflows occasionally queue during peak hours. Investigation shows worker utilization exceeds 90% only for 20 minutes each day. What is the BEST recommendation?

A. Create more Variables

B. Rewrite all DAGs

C. Add 50 permanent workers

✓

D. Review autoscaling strategy

Answer

✅ D. Review autoscaling strategy

Explanation

Autoscaling handles peak demand without permanently increasing infrastructure costs.

Answered: 0 / 20

Apache Airflow Certification Practice Test 09

Best and Most Cost-Effective Solution Questions

Insightful Saga — Modern Data Engineering Certification Preparation

Question 161

A. Create more Variables

B. Rewrite all DAGs

C. Add 50 permanent workers

D. Review autoscaling strategy

Answer: ✅ D. Review autoscaling strategy

Explanation:

Autoscaling handles peak demand without permanently increasing infrastructure costs.

Question 162

A banking company runs a DAG every five minutes. The DAG checks for files that typically arrive only once per day. Management wants to reduce unnecessary workload. What is the BEST solution?

A. Schedule the DAG based on actual arrival patterns

B. Split the DAG

C. Add more workers

D. Increase retries

Answer: ✅ A. Schedule the DAG based on actual arrival patterns

Question 163

A healthcare company operates 300 similar DAGs. Only table names and schedules differ. Maintenance effort has become excessive. What is the BEST architectural recommendation?

A. Dynamic DAG generation

B. Create 300 additional DAGs

C. Increase workers

D. Add more queues

Answer: ✅ A. Dynamic DAG generation

Question 164

A telecom company frequently experiences API timeouts. Current configuration: - Retry Delay: 1 second - Retries: 20 The external provider recommends reducing request frequency. What is the BEST improvement?

A. More workers

B. More schedules

C. More pools

D. Exponential Backoff

Answer: ✅ D. Exponential Backoff

Question 165

An airline company has 2,000 tasks competing for a database that only supports 25 concurrent connections. What is the BEST Airflow solution?

A. Add more retries

B. Pool Configuration

C. Create additional DAGs

D. Add more workers

Answer: ✅ B. Pool Configuration

Question 166

A manufacturing company wants near real-time visibility into workflow failures. Support engineers currently review logs manually every morning. What is the BEST recommendation?

A. Hire more support staff

B. Increase schedules

C. Automated alerting and monitoring

D. Add more workers

Answer: ✅ C. Automated alerting and monitoring

Question 167

A retail company maintains separate DAGs for: - Sales - Customers - Inventory - Products Each DAG performs identical processing logic. What is the BEST long-term approach?

A. Reusable workflow framework

B. Duplicate DAG code

C. More variables

D. Separate Airflow environments

Answer: ✅ A. Reusable workflow framework

Question 168

A newly joined support engineer observes frequent SLA breaches. Investigation reveals most failures stem from long-running source-system queries. What should be reviewed first?

A. Workflow colors

B. Source query optimization

C. DAG descriptions

D. Pool labels

Answer: ✅ B. Source query optimization

Question 169

A company wants faster onboarding of developers to Airflow. Current onboarding takes four weeks. What provides the greatest long-term benefit?

A. More DAGs

B. Additional workers

C. More queues

D. Templates and documentation

Answer: ✅ D. Templates and documentation

Question 170

A banking platform supports hundreds of workflows. Executives want visibility into platform health from a single dashboard. What is the BEST recommendation?

A. More Airflow UIs

B. Additional workers

C. Centralized observability platform

D. More queues

Answer: ✅ C. Centralized observability platform

Question 171

A healthcare company receives source files from 100 hospitals. The number of arriving files changes daily. What is the BEST design?

A. Create new DAGs daily

B. Create tasks manually

C. Create more pools

D. Dynamic Task Mapping

Answer: ✅ D. Dynamic Task Mapping

Question 172

A retailer wants every production deployment validated automatically before release. What is the BEST solution?

A. Shared production access

B. Manual testing only

C. More variables

D. CI/CD validation pipeline

Answer: ✅ D. CI/CD validation pipeline

Question 173

An insurance company runs Airflow across multiple business units. Each team uses different retry standards and alerting methods. What should be established?

A. Local team preferences

B. More DAG copies

C. Independent environments only

D. Enterprise engineering standards

Answer: ✅ D. Enterprise engineering standards

Question 174

A company experiences increasing Airflow infrastructure costs. Most workflows run only during daytime business hours. What should architects evaluate first?

A. More workers

B. Runtime resource optimization

C. More schedules

D. Larger pools

Answer: ✅ B. Runtime resource optimization

Question 175

A support team spends hours investigating recurring incidents. The root causes are often identical. What is the BEST investment?

A. Runbooks and knowledge base

B. More queues

C. More variables

D. Additional DAG tags

Answer: ✅ A. Runbooks and knowledge base

Question 176

A finance company wants workflow ownership clearly defined. Multiple teams currently share responsibility for everything. What is the BEST governance improvement?

A. More workers

B. Additional variables

C. More task groups

D. Defined ownership model

Answer: ✅ D. Defined ownership model

Question 177

A company must support future workload growth without major platform redesign. Which architectural principle is MOST important?

A. Independent Solutions

B. Scalability by Design

C. Fixed Capacity Planning

D. Manual Scaling

Answer: ✅ B. Scalability by Design

Question 178

A global retailer wants faster incident detection. Business users currently identify most failures before support teams. What should be improved first?

A. Proactive monitoring and alerting

B. More DAGs

C. More pools

D. More variables

Answer: ✅ A. Proactive monitoring and alerting

Question 179

A newly hired Architect reviews an Airflow environment with: - 1,500 DAGs - 200 developers - 15 business units Management wants long-term consistency. What should be implemented first?

A. More schedules

B. Platform governance framework

C. More workers

D. More DAG folders

Answer: ✅ B. Platform governance framework

Question 180

A Principal Airflow Architect is designing an orchestration platform expected to support: - Thousands of workflows - Multi-cloud integrations - Enterprise governance - Strict SLAs - Future growth What is the MOST important architectural objective?

A. Maximum worker count

B. Reliable, scalable and governed orchestration

C. Largest DAG inventory

D. Most schedules possible

Answer: ✅ B. Reliable, scalable and governed orchestration

Explanation:

Enterprise Airflow success is measured by reliability, scalability, governance, observability and business value, not by infrastructure size alone.