Why governance ensures data trust in dbt - Challenge Your Understanding

Challenge - 5 Problems

🧠 Conceptual

intermediate

Why is data governance important for trust?

Which of the following best explains why data governance is essential to ensure data trust in an organization?

A It defines clear rules and responsibilities for data quality and security, so users can rely on the data.

B It increases the amount of data collected, making datasets larger and more useful.

C It automates all data processing tasks, removing the need for human oversight.

D It restricts access to data so only IT staff can view it, preventing misuse.

💡 Hint

Think about how trust is built when everyone knows who manages data and how it is kept accurate.

Data governance sets clear policies and roles that ensure data is accurate, secure, and well-managed. This clarity builds trust among users.

❓ data_output

intermediate

Identify the effect of governance on data quality metrics

Given a dataset with data quality metrics before and after applying governance policies, which metric shows the biggest improvement?

dbt

import pandas as pd

data = {'Metric': ['Completeness', 'Accuracy', 'Timeliness', 'Consistency'],
        'Before': [0.75, 0.80, 0.60, 0.70],
        'After': [0.90, 0.85, 0.85, 0.75]}
df = pd.DataFrame(data)
df['Improvement'] = df['After'] - df['Before']
print(df)

A Timeliness

B Accuracy

C Completeness

D Consistency

💡 Hint

Look at the difference between 'After' and 'Before' values for each metric.

Timeliness improved from 0.60 to 0.85, which is a 0.25 increase, the largest among all metrics.

🔧 Debug

advanced

Find the error in this dbt model related to governance enforcement

Which option correctly identifies the error in this dbt SQL model that enforces data governance by filtering only approved records?

dbt

select * from sales_data
where approval_status = 'approved'
  and date > '2023-01-01'
  and region = 'US'
  group by customer_id

A The WHERE clause should come after GROUP BY, so the order is wrong.

B The GROUP BY clause is used without aggregation functions, causing a syntax error.

C The filter on approval_status should use double quotes instead of single quotes.

D The date comparison should use >= instead of > to include the start date.

💡 Hint

Check if GROUP BY is used correctly with SELECT columns and aggregation.

GROUP BY requires aggregation functions on other columns or only grouping columns in SELECT. Here, SELECT * with GROUP BY causes a syntax error.

🚀 Application

advanced

How does data governance improve collaboration in dbt projects?

Which option best describes how data governance practices improve collaboration among data teams using dbt?

A By limiting access to dbt projects so only senior analysts can edit models.

B By removing the need for version control since governance tracks changes automatically.

C By automatically generating all dbt models without human input, reducing errors.

D By enforcing standardized naming conventions and documentation, making models easier to understand and share.

💡 Hint

Think about how clear rules and documentation help teams work together smoothly.

Standardized naming and documentation help everyone understand and maintain dbt models, improving teamwork and trust.

❓ visualization

expert

Interpreting a data lineage graph for governance impact

Given a data lineage graph showing sources, transformations, and outputs, which statement best reflects how governance ensures trust in this pipeline?

dbt

import matplotlib.pyplot as plt
import networkx as nx

G = nx.DiGraph()
G.add_edges_from([
    ('Raw Sales', 'Clean Sales'),
    ('Raw Customers', 'Clean Customers'),
    ('Clean Sales', 'Sales Summary'),
    ('Clean Customers', 'Sales Summary'),
    ('Sales Summary', 'Executive Dashboard')
])
pos = nx.spring_layout(G)
nx.draw(G, pos, with_labels=True, node_color='lightblue', node_size=2500, font_size=10, arrowsize=20)
plt.title('Data Lineage Graph')
plt.show()

A Governance focuses only on the final dashboard, ignoring intermediate transformations.

B Governance removes the need to document data sources because lineage is automatically inferred.

C Governance tracks each step from raw data to dashboard, ensuring transparency and easier error tracing.

D Governance requires manual data entry at each step to verify data correctness.

💡 Hint

Look at how knowing the path of data helps build trust.

Data lineage shows the full path data takes, so governance can ensure each step is correct and transparent, building trust.