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. Add 50 permanent workers

✓

B. Review autoscaling strategy

C. Rewrite all DAGs

D. Create more Variables

Answer

✅ B. 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. Add 50 permanent workers

B. Review autoscaling strategy

C. Rewrite all DAGs

D. Create more Variables

Answer: ✅ B. 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. Add more workers

C. Increase retries

D. Split the DAG

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. Add more queues

D. Increase workers

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. Exponential Backoff

B. More workers

C. More schedules

D. More pools

Answer: ✅ A. 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. Pool Configuration

B. Add more workers

C. Create additional DAGs

D. Add more retries

Answer: ✅ A. 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. Automated alerting and monitoring

B. Hire more support staff

C. Add more workers

D. Increase schedules

Answer: ✅ A. 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. Separate Airflow environments

D. More variables

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. Source query optimization

B. Workflow colors

C. DAG descriptions

D. Pool labels

Answer: ✅ A. 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. Templates and documentation

B. Additional workers

C. More DAGs

D. More queues

Answer: ✅ A. 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. Centralized observability platform

B. More Airflow UIs

C. Additional workers

D. More queues

Answer: ✅ A. 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. Dynamic Task Mapping

B. Create tasks manually

C. Create new DAGs daily

D. Create more pools

Answer: ✅ A. Dynamic Task Mapping

Question 172

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

A. CI/CD validation pipeline

B. Manual testing only

C. Shared production access

D. More variables

Answer: ✅ A. 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. Enterprise engineering standards

B. Local team preferences

C. Independent environments only

D. More DAG copies

Answer: ✅ A. 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. Runtime resource optimization

B. More workers

C. More schedules

D. Larger pools

Answer: ✅ A. 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. Defined ownership model

B. More workers

C. Additional variables

D. More task groups

Answer: ✅ A. Defined ownership model

Question 177

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

A. Scalability by Design

B. Fixed Capacity Planning

C. Manual Scaling

D. Independent Solutions

Answer: ✅ A. 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. Platform governance framework

B. More workers

C. More DAG folders

D. More schedules

Answer: ✅ A. 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. Reliable, scalable and governed orchestration

B. Maximum worker count

C. Largest DAG inventory

D. Most schedules possible

Answer: ✅ A. Reliable, scalable and governed orchestration

Explanation:

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