Manufacturing file review in PCB Design - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding the purpose of a drill file in manufacturing

Which of the following best describes the main purpose of a drill file in a PCB manufacturing file set?

A It provides the bill of materials for component placement.

B It contains the copper layer artwork for signal routing.

C It specifies the locations and sizes of holes to be drilled on the PCB.

D It defines the solder mask openings on the PCB surface.

💡 Hint

Think about what holes are needed for components and vias.

The drill file lists all hole locations and sizes needed for vias and component leads. It does not contain copper or mask information.

❓ dax_lod_result

intermediate

Calculating total PCB layers using DAX

Given a table 'PCB_Layers' with columns 'LayerName' and 'IsActive' (TRUE/FALSE), which DAX measure correctly counts the number of active layers?

A Active Layers = CALCULATE(COUNTROWS(PCB_Layers), PCB_Layers[IsActive] = TRUE)

B Active Layers = COUNT(PCB_Layers[IsActive])

C Active Layers = SUM(PCB_Layers[IsActive])

D Active Layers = COUNTROWS(FILTER(PCB_Layers, PCB_Layers[IsActive] = TRUE()))

💡 Hint

Filter the table to only active layers before counting rows.

Option D filters the table to only rows where IsActive is TRUE, then counts those rows. Option D counts all values, including FALSE. Option D sums booleans which is invalid. Option D has incorrect filter syntax.

❓ visualization

advanced

Best visualization for layer thickness distribution

You have manufacturing data showing thickness measurements for each PCB layer over multiple batches. Which visualization best helps identify layers with inconsistent thickness?

A A box plot per layer showing thickness distribution across batches.

B A stacked bar chart showing total thickness per batch.

C A line chart showing average thickness over time for all layers combined.

D A pie chart showing proportion of layers by thickness category.

💡 Hint

Look for a chart that shows spread and outliers per category.

A box plot per layer clearly shows the spread, median, and outliers of thickness measurements, helping identify inconsistency. Other charts do not show distribution well.

🔧 Formula Fix

advanced

Identifying error in SQL query for manufacturing defect counts

Given this SQL query to count defects per PCB batch: SELECT BatchID, COUNT(DefectID) AS DefectCount FROM Defects WHERE DefectType = 'Critical' GROUP BY BatchID HAVING DefectCount > 5; What error will this query produce?

A Syntax error because HAVING cannot use alias DefectCount.

B No error; query runs correctly and returns batches with more than 5 critical defects.

C Runtime error due to missing GROUP BY column DefectType.

D Logical error because WHERE cannot filter DefectType before aggregation.

💡 Hint

Check if aliases can be used in HAVING clauses in SQL.

In many SQL dialects, the HAVING clause cannot reference column aliases defined in the SELECT clause. The alias DefectCount is not recognized in HAVING, causing a syntax error.

🎯 Scenario

expert

Optimizing manufacturing file review dashboard performance

You have a Power BI dashboard showing manufacturing file review metrics with multiple slicers and detailed tables. Users report slow loading times. Which approach will most effectively improve performance without losing key insights?

A Increase the number of visuals on the page to distribute load.

B Use aggregations and pre-calculated summary tables to reduce data volume.

C Remove all slicers and replace tables with static images.

D Disable data refresh to avoid loading delays.

💡 Hint

Think about reducing the amount of data processed at runtime.

Using aggregations and summary tables reduces the data Power BI processes, improving performance while keeping interactive insights. Removing slicers or disabling refresh reduces functionality. Adding visuals increases load.