Weekend Sale - Special 75% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 75onlydt

DQ-1220 Questions and Answers

Question # 6

Who does the DMBoK consider to be generally responsible for developing business glossary content?

A.

Business Data Stewards

B.

Conceptual Data Modellers

C.

Data Architects

D.

Business Users

E.

Coordinating Data Stewards

Full Access
Question # 7

A goal of reference and master data management is for data to ensure shared data is:

A.

Secure, auditable, publicly available and free

B.

Continuous, consistent, current and private

C.

Complete, consistent, content and relevant

D.

Secure, auditable, complete and relevant

E.

Complete, consistent, current and authoritative

Full Access
Question # 8

The best way to manage a data architecture roadmap is by using:

A.

Integrated strategic reviews

B.

An annual review

C.

Senior management buy-in

D.

Peer reviews

E.

Results evaluation

Full Access
Question # 9

Discovering and documenting metadata about physical data assets provides:

A.

An estimation of balance sheet value of enterprise data

B.

Scoping boundaries of the data dictionary

C.

Insights into the temporal data quality

D.

Information on how data is transformed as it moves between systems

E.

Effective project scope management

Full Access
Question # 10

A retail system accepts an order for 750,000 identical office chairs from an individual consumer. The value passes all datatype, domain, and mandatory-field checks. Which additional Data Quality dimension should detect the anomaly?

A.

Completeness

B.

Reasonableness

C.

Uniqueness

D.

Currency

Full Access
Question # 11

The implementation of a 'Super Type - Sub Type' structure can use the following 2 options:

A.

Super-Subtype Merge and Super-Subtype Split

B.

Subtype Absorption and Supertype Partition

C.

Super-Subtype Split and Super-Subtype Merge

D.

Supertype Rollover and Subtype Rollunder

E.

Supertype Absorption and Subtype Partition

Full Access
Question # 12

A security mechanism that searches for customer bank account details in outgoing emails is achieving the goal of:

A.

Ensuring stakeholder requirements for openness and transparency are met

B.

Ensuring stakeholder requirements for concise definitions and usage are met

C.

Ensuring stakeholder requirements for service design and experience are met

D.

Ensuring stakeholder requirements for response time and availability levels are met

E.

Ensuring stakeholder requirements for confidentiality and privacy are met

Full Access
Question # 13

The Data Architecture workstream on results produces:

A.

Interaction with the enterprise data architecture group

B.

Data architecture artefects within a overall roadmap

C.

Assignment of accountability and responsibilities

D.

A change in behaviour

E.

Selection of the data architecture framework

Full Access
Question # 14

Critical to the incremental development of the data warehouse is:

A.

The assurance to include velocity, variety and veracity measurement

B.

A agile development team

C.

A strong capacity management process

D.

A strong incident management process

E.

A strong release management process

Full Access
Question # 15

Two departments use the term "Active Customer" but apply different definitions. Which Data Management capability should be addressed first?

A.

Business glossary governance

B.

Storage compression

C.

Index rebuilding

D.

Network segmentation

Full Access
Question # 16

Three source systems provide different telephone numbers for the same customer. An MDM hub selects one number according to approved source-priority rules. This is an example of:

A.

Survivorship

B.

Encryption

C.

Normalization

D.

Archiving

Full Access
Question # 17

Big data management requires:

A.

More discipline than relational data management

B.

Less discipline than relational data management

C.

Big ideas with big budgets

D.

No discipline at all

E.

A certification in data science

Full Access
Question # 18

The search function associated with a document management store is failing to return known artefacts. This is due to a failure of:

A.

Maintaining appropriate metadata on each document

B.

Maintaining public access to all documents in the document management store

C.

Effective data quality metrics

D.

Data privacy and confidentiality procedures

E.

Business intelligence implementation

Full Access
Question # 19

The role of Metadata in Data Management is:

A.

To build a big data solution

B.

To group common data concepts

C.

To help organisations understand its data, its systems and its workflows

D.

To provide effective decision making

E.

To display appropriate data on screens and reports

Full Access
Question # 20

A Data Quality team has identified 500 defects across several domains. Which factor should have the strongest influence on remediation priority?

A.

Alphabetical order of the affected attributes

B.

Business impact and risk

C.

Which database contains the fewest records

D.

Which issue was easiest to describe

Full Access
Question # 21

Following the rollout of a data issue process, there have been no issues recorded in the first month. The reason for this might be:

A.

The automatic deletion of all issues in the database

B.

There are no data issues in the enterprise

C.

Lack of credibility in the data governance process to effect changes

D.

The denial of overtime requests

E.

Staff staying back late to enter the issues into the system

Full Access
Question # 22

What is the purpose of Data Governance?

A.

Ensure that financial performance of the company is improved

B.

Encompass the entire lifecycle of a data asset

C.

Ensure an organization gets value out of its data

D.

Establish processes and functions through which data can be enabled for use and also maintained

E.

To ensure that data is managed properly, according to policies and best practices

Full Access
Question # 23

The creation of overly complex enterprise integration over time is often a symptom of:

A.

Multiple integration technologies

B.

Multiple data warehouses

C.

Multiple application coding languages

D.

Multiple data owners

E.

Multiple metadata tags

Full Access
Question # 24

The requirement to enter a username, a password and then a code sent to an authentication app is called:

A.

3-factor authentication

B.

Biometric authentication

C.

Proactive authentication

D.

2-factor authentication

E.

Mobile authentication

Full Access
Question # 25

A report displaying birth date contains possible, but incorrect values. What is a possible explanation?

A.

Birth date is populated from two source systems, both of which record the birth date in the birth date field

B.

Birth date is populated from a single source system, which does not contain birth date

C.

Birth date is populated from a single source system, which contains missing values

D.

Birth date is populated from a single source system, where the date field is an offset value of 1601

E.

Birth date is populated from two source systems, one of which stores marriage date in the birth date field

Full Access
Question # 26

Integrating data security with document and content management knowledge areas, guides the implementation of:

A.

Appropriate access and authorization to structured data

B.

Fitness for purpose metrics for unstructured data

C.

Straight-through processing for NoSQL queries

D.

Appropriate access and authorization to unstructured data

E.

Appropriate privacy controls on data marts

Full Access
Question # 27

Database monitoring tools measure key database metrics, such as:

A.

Create, read, normalization, user access

B.

Capacity, availability, backup instances, data quality

C.

Create, read, update, delete

D.

Capacity, design, normalization, user access

E.

Capacity, availability, cache performance, user statistics

Full Access
Question # 28

Reference data is often a list of code values with their full names. One example is:

A.

Person age associated with accessibility requirements

B.

State or province associated with the related country

C.

Encrypted code values with the unencrypted data value

D.

Country codes associated with the country names

E.

Master data values encoded into reference values

Full Access
Question # 29

Compound authorization groups provide a means to:

A.

Distract the data security officer

B.

Precisely configure an individual's access to a system

C.

Obfuscate a user's actual access to a system

D.

Encrypt sensitive transmissions of data

E.

Effectively prepare for data security audits

Full Access
Question # 30

A customer moved house three months ago. The CRM still contains the customer's former address, although the record was originally correct when created. Which Data Quality dimension best describes the current problem?

A.

Completeness

B.

Integrity

C.

Currency

D.

Uniqueness

Full Access
Question # 31

A financial transaction is captured correctly at 9:00 AM but does not become available to the fraud-monitoring system until 6:00 PM, although the business requirement is availability within five minutes. Which Data Quality dimension is primarily violated?

A.

Accuracy

B.

Timeliness

C.

Uniqueness

D.

Completeness

Full Access
Question # 32

The primary reason for identifying Critical Data Elements is to:

A.

Apply identical controls to every field in every system

B.

Focus governance and quality resources on data with the greatest business impact

C.

Eliminate the need for metadata

D.

Replace all non-critical data

Full Access
Question # 33

Achieving security risk reduction in an organisation begins with developing what?

A.

A change management model, prioritising security changes and then updating the active directory

B.

A metadata model, locating the data and moving it into the metadata repository

C.

An enterprise data model, rolling out data flow diagrams and enbedding security into the database

D.

A security model, classifying each organisational role and putting the physical data behind a firewall

E.

A classification model, classifying each data concept and locating the physical data

Full Access
Question # 34

Data governance represents:

A.

An inherent separation of duty between oversight and execution

B.

A joint effort in defining the data quality rules and profiling the data

C.

An initiative that addresses the financial accuracy of the balance sheet

D.

A federated government style of data management

E.

An organisation structure with a number of key roles

Full Access
Question # 35

How is Data Governance defined?

A.

Evaluation of the current state of critical data management activities in order to plan for improvement

B.

Data governance assists in representing information consistently and protecting sensitive information

C.

Set of interdependent functions, each with its own goals, activities, and responsibilities.

D.

Exercise of the authority and control over the management of data assets.

E.

Planning, implementation, and control activities for lifecycle management of data and information found in any form or medium

Full Access
Question # 36

The implementation of data architecture exposes the transformation of data as it moves across the landscape. A common name for this concept is:

A.

Data interfacing

B.

Data discovery

C.

Extract, transformation and load

D.

Data lineage

E.

Data modelling

Full Access