Free DGSP-F Practice Questions

Question 1

Finance reports 8,400 "active customers," meaning customers invoiced during the quarter. Marketing reports 11,200, meaning customers who interacted during the quarter. Checks confirm that both calculations follow their intended definitions. Executives want to compare the figures without losing either department's useful measure. What should the governance team do?

Accepted Answer

Approve distinct names and definitions, explaining how the populations differ.

Answer

Use the invoice-based definition to replace both departmental measures.

Answer

Use one source for both reports without changing the existing "active customers" labels.

Answer

Combine both populations into a single active-customer total and retire the separate measures.

Question 2

An employee investigates disputed customer statuses, checks them against service records, clarifies the business rule with operational teams, and prepares a revised definition for the data owner's approval. These activities most closely describe the work of a:

Accepted Answer

Business data steward

Answer

Accountable data owner

Answer

Technical data custodian

Answer

Independent assurance reviewer

Question 3

A supplier directory contains 600 records: 480 domestic and 120 foreign. The quality rule requires a tax identifier for domestic suppliers only; foreign suppliers are excluded from this completeness measure. Thirty domestic records lack the identifier. The quality plan requires corrective action when completeness is below 95%. Which assessment follows the rule?

Accepted Answer

93.75%; corrective action is required.

Answer

75%; corrective action is required.

Answer

95%; no corrective action is required.

Answer

6.25%; corrective action is required.

Question 4

A source team plans to change how Net_Sales is calculated. Several reports consume the result through intermediate datasets, and some rename the field. To identify the reports whose results could change, the steward should examine:

Accepted Answer

Field-level lineage showing transformations and downstream dependencies.

Answer

Business glossary definitions and synonyms for the term "net sales".

Answer

Data dictionary entries listing the source column's type and permitted range.

Answer

Access records identifying everyone authorized to read the source table.

Question 5

After an import change, supplier matching fails only for identifiers that begin with zero. One failed record contains "004271" in the source file, "4271" in staging, and "004271" in the current supplier master. Identifiers without leading zeroes still match. Which explanation best fits this pattern?

Accepted Answer

Staging converted supplier identifiers to numbers, removing their significant leading zeroes.

Answer

The supplier master refresh omitted recently registered suppliers from its reference data.

Answer

The import applied a maximum field length that removed trailing characters from long identifiers.

Answer

The matching process used an obsolete supplier-name mapping rather than the current one.

Question 6

A group council mandates common supplier identifiers and minimum access controls. Regional data teams approve local attributes and quality rules within those requirements; the council resolves cross-region conflicts. Which description captures this operating model?

Accepted Answer

Federated: shared requirements are central, with defined regional decision rights.

Answer

Centralized: all regional data rules require council approval.

Answer

Decentralized: regions can replace group requirements whenever their local priorities differ.

Answer

Advisory: the council recommends common requirements, but regions decide whether to adopt them.

Question 7

A steward discovers that a payroll extract is accessible through a public link without authentication. The steward is authorized to revoke public links, and revocation will preserve the file, internal payroll access, and audit logs. What should happen immediately?

Accepted Answer

Revoke the public link and activate the incident-response process.

Answer

Notify every employee named in the extract before changing the link's access permissions.

Answer

Leave the link active while security establishes who has downloaded the payroll extract.

Answer

Suspend all payroll access and begin an enterprise-wide review of employee access rights.

Question 8

Two supplier records share a trading name and registered address. Investigation confirms that they are separate subsidiaries, with different verified legal registration numbers and separate contracting authority. The supplier master is defined at the legal-entity level. How should the records be represented?

Accepted Answer

Keep separate supplier records linked to their common parent.

Answer

Merge them, retaining both legal registration numbers.

Answer

Treat one subsidiary as a trading-name alias of the other.

Answer

Replace both subsidiaries with one parent record and distinguish them by payment account.

Question 9

An access-request RACI assigns A to the data owner, R to the custodian, C to the business steward, and I to the governance office. The custodian grants access after the steward endorses the request, without obtaining the owner's decision. Where has the process failed?

Accepted Answer

The steward's consultation was substituted for the data owner's approval.

Answer

The governance office should approve every access request.

Answer

The business steward should perform the technical provisioning.

Answer

The owner was designated accountable despite not performing the technical provisioning.

Question 10

An automated validation service will be unavailable for four days. A tested manual review can apply the same rules to every record before release. Company policy permits equivalent temporary controls with data-owner approval, and the review team has sufficient capacity. Which arrangement maintains control without unnecessarily interrupting deliveries?

Accepted Answer

Use a four-day, owner-approved exception with recorded pre-release checks.

Answer

Suspend all deliveries until automated validation is restored.

Answer

Release new files using the last successful batch's validation results.

Answer

Replace the automated-control requirement permanently once the manual review begins operating.

Free DGSP-F Practice Questions

Domain 1: Data Governance Concepts, Business Drivers and Roles

Question 1

Question 2

Domain 2: Data Governance and Stewardship Roles

Question 3

Question 4

Domain 3: Data Governance Inputs and Deliverables

Question 5

Domain 4: Data Governance Function

Question 6

Question 7

Question 8

Domain 5: Fundamental Knowledge Areas for Data Stewardship Activities

Question 9

Question 10

That's 10 of 1,030