Self-review: Design and develop the data model :Deploy and Maintain Power BI Assets and Capstone project (Microsoft Power BI Data Analyst Professional Certificate) Answers 2025

Question 1

While designing and developing the data model, which tables did you establish a relationship based on One-to-one (1:1) cardinality? (Select all that apply)

✅ Purchases and Sales tables
✅ Countries and Exchange Data tables
❌ Calendar and Purchases tables
❌ Sales and Countries tables

Explanation:

• Purchases and Sales have a 1:1 relationship because each purchase record directly corresponds to one sales record.

• Countries and Exchange Data also form a 1:1 relationship, as each country maps to a single exchange-rate record in the model.

• Calendar and Purchases is one-to-many, since one date can have multiple purchases.

• Sales and Countries is many-to-one, as many sales can occur within one country.

Question 2

True or False: The Net Revenue in USD for the order with Order ID 1035 is 300 USD, representing the total revenue generated from this order before accounting for any deductions, returns, allowances, and discounts.

❌ True
✅ False

Explanation:
The description given refers to Gross Revenue, not Net Revenue.
Net Revenue is calculated after accounting for deductions such as taxes, returns, allowances, and discounts. Therefore, the statement is False.

Question 3

Which cardinality was required for the relationship between the Sales and Countries tables?

❌ Many to Many
❌ One to One (1:1)
✅ Many to One (Many:1)

Explanation:
Each country can have multiple sales records, but each sale belongs to only one country. Hence, the correct relationship is Many-to-One.

🧾 Summary Table