PCB design workflow overview (schematic to manufacturing) - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding the Role of the Schematic in PCB Design

Which statement best describes the primary purpose of the schematic in the PCB design workflow?

A It tests the PCB for electrical faults after assembly.

B It defines the physical layout and placement of components on the PCB.

C It generates the manufacturing files directly for PCB fabrication.

D It provides a visual representation of the electrical connections and components.

💡 Hint

Think about what a schematic shows before the physical board is designed.

The schematic is a diagram that shows how components connect electrically. It does not show physical placement or manufacturing details.

❓ dax_lod_result

intermediate

Calculating Total Components Count in a PCB Project

Given a table 'Components' with columns 'ComponentID' and 'Quantity', which DAX measure correctly calculates the total number of components used in the PCB design?

A Total Components = SUM(Components[Quantity])

B Total Components = COUNT(Components[ComponentID])

C Total Components = DISTINCTCOUNT(Components[ComponentID])

D Total Components = AVERAGE(Components[Quantity])

💡 Hint

Think about summing quantities versus counting unique IDs.

SUM adds all quantities to get the total count. COUNT counts rows, DISTINCTCOUNT counts unique IDs, and AVERAGE calculates the mean quantity.

❓ visualization

advanced

Best Visualization to Show PCB Manufacturing Status by Stage

You want to create a dashboard showing the number of PCB projects at each manufacturing stage (e.g., Fabrication, Assembly, Testing). Which visualization type is best to clearly communicate this status?

A Line chart showing cumulative projects completed over time

B Pie chart showing percentage of projects per stage

C Stacked bar chart showing projects per stage over time

D Scatter plot showing project size versus manufacturing cost

💡 Hint

Consider which chart best shows parts of a whole at a single point in time.

A pie chart effectively shows the proportion of projects in each manufacturing stage at a glance.

❓ data_modeling

advanced

Modeling Relationships Between PCB Design and Manufacturing Tables

In a BI model, you have a 'Designs' table with PCB schematic data and a 'Manufacturing' table with production details. What is the best relationship type between these tables to analyze manufacturing status per design?

A One-to-one between Designs and Manufacturing using DesignID

B Many-to-many between Designs and Manufacturing using DesignID

C One-to-many from Designs to Manufacturing using DesignID

D No relationship; join tables using a calculated column

💡 Hint

Think about how many manufacturing records can exist per design.

One design can have multiple manufacturing records (e.g., batches), so one-to-many is appropriate.

🔧 Formula Fix

expert

Identifying the Error in a DAX Measure for PCB Yield Calculation

Consider this DAX measure intended to calculate PCB yield percentage:
PCB Yield = DIVIDE(SUM(Manufacturing[GoodUnits]), SUM(Manufacturing[TotalUnits])) * 100
Which issue will cause this measure to produce incorrect results?

A If TotalUnits is zero, the measure will return blank instead of zero.

B The multiplication by 100 should be inside the DIVIDE function to avoid errors.

C SUM aggregation is invalid on numeric columns in this context.

D The measure should use COUNT instead of SUM for units.

💡 Hint

Consider what happens when dividing by zero in DAX.

DIVIDE handles division by zero safely by returning blank or an alternate result, but if TotalUnits is zero, the measure returns blank, which might be interpreted as error or missing data.