Power symbols and ground connections in PCB Design - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Power Symbols in PCB Design

Which of the following power symbols is typically used to represent a positive voltage supply in PCB schematics?

A A square labeled NC (No Connection)

B A circle with a plus sign inside labeled GND

C A triangle pointing downwards labeled VSS

D A triangle pointing upwards labeled VCC

💡 Hint

Think about the common symbol for positive voltage in electronics.

The triangle pointing upwards labeled VCC is the standard symbol for a positive voltage supply in PCB schematics. GND is ground, VSS is often negative or ground reference, and NC means no connection.

❓ dax_lod_result

intermediate

Calculating Total Ground Connections in a PCB Design

Given a table 'Connections' with columns 'Node' and 'Type' where 'Type' can be 'Power' or 'Ground', which DAX measure correctly counts the total number of ground connections?

A TotalGrounds = COUNTROWS(Connections)

B TotalGrounds = COUNTROWS(FILTER(Connections, Connections[Type] = "Ground"))

C TotalGrounds = CALCULATE(COUNT(Connections[Node]), Connections[Type] = "Power")

D TotalGrounds = SUMX(Connections, IF(Connections[Type] = "Ground", 1, 0))

💡 Hint

Use FILTER to select only ground connections before counting rows.

Option B correctly filters the 'Connections' table to only rows where 'Type' is 'Ground' and counts them. Option B counts power connections, C sums 1s but is less efficient, and A counts all connections.

❓ visualization

advanced

Best Visualization for Power and Ground Distribution

You want to create a dashboard showing the distribution of power and ground connections across multiple PCB layers. Which visualization type best communicates this information clearly?

A Stacked bar chart showing counts of power and ground connections per layer

B Pie chart showing percentage of power vs ground connections overall

C Line chart showing connection counts over time

D Scatter plot of connection voltage vs layer number

💡 Hint

Consider a chart that compares categories across layers.

A stacked bar chart effectively shows counts of power and ground connections per PCB layer, allowing easy comparison. Pie charts show overall proportions but not per layer. Line charts and scatter plots are less suitable here.

🔧 Formula Fix

advanced

Debugging a Ground Connection Measure in DAX

Consider this DAX measure intended to count ground connections:
GroundCount = COUNTROWS(FILTER(Connections, Connections[Type] == "Ground"))
What is the issue with this measure?

A The table name 'Connections' is misspelled

B COUNTROWS cannot be used with FILTER

C The comparison operator should be a single equals sign '=' instead of '=='

D The measure is correct and will run without errors

💡 Hint

Check the syntax for comparison operators in DAX.

DAX uses a single equals sign '=' for comparisons, not '=='. Using '==' causes a syntax error. COUNTROWS works with FILTER, and the table name is correct.

🎯 Scenario

expert

Designing a Data Model for Power and Ground Analysis

You are designing a data model to analyze power and ground connections across multiple PCB projects. Which approach best supports flexible reporting on connection types, layers, and projects?

A Create a fact table 'Connections' with foreign keys to dimension tables 'Projects', 'Layers', and 'ConnectionTypes'

B Store all connection data in a single flat table with repeated project and layer names

C Use separate tables for power and ground connections without linking them

D Create a dimension table for connections and a fact table for projects

💡 Hint

Think about star schema design for BI data models.

Option A follows best practices by using a fact table for connections linked to dimension tables for projects, layers, and connection types. This supports flexible slicing and dicing. Option A causes data duplication, C fragments data, and D reverses fact/dimension roles.