Black Friday Special Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: buysanta

Exact2Pass Menu

Question # 4

Data governance requires control mechanisms and procedures for, but not limited to, assignment and tracking of action items.

A.

FALSE

B.

TRUE

Full Access
Question # 5

Preparation and pre-processing of historical data needed in a predictive model may be performed in nightly batch processes or in near real-time.

A.

TRUE

B.

FALSE

Full Access
Question # 6

The flow of data in a data integration solution does not have to be designed and documented.

A.

TRUE

B.

FALSE

Full Access
Question # 7

The operational data quality management procedures depend on the ability to measure and monitor the applicability of data.

A.

FALSE

B.

TRUE

Full Access
Question # 8

Self-service is a fundamental delivery channel in the BI portfolio.

A.

TRUE

B.

FALSE

Full Access
Question # 9

A goal of reference and master data is to provide authoritative source of reconciled and quality-assessed master and reference data.

A.

TRUE

B.

FALSE

Full Access
Question # 10

Customer relationship management systems manage Master Data about customers.

A.

TRUE

B.

FALSE

Full Access
Question # 11

Data quality issues only emerge at initial stages of the data lifecycle.

A.

TRUE

B.

FALSE

Full Access
Question # 12

Deliverables in the Metadata Management context diagram include:

A.

Metadata Strategy

B.

Metadata Standards

C.

Data Lineage

D.

Metadata Architecture

E.

Metadata design

F.

Data storage and operations

Full Access
Question # 13

In gathering requirements for DW/BI projects, begin with the data goals and strategies first.

A.

TRUE

B.

FALSE

Full Access
Question # 14

Dimensions of data quality include:

A.

Validity

B.

Privacy

C.

Innovation

D.

Accessibility

E.

Currency

F.

All of the above

Full Access
Question # 15

Data warehouses are often loaded and serviced by a nightly batch window.

A.

FALSE

B.

TRUE

Full Access
Question # 16

Please select the transition phases in Bridges’ Transition process:

A.

The neutral zone

B.

The new beginning

C.

The ending

D.

The transition

E.

The translation

F.

The game

Full Access
Question # 17

Lack of automated monitoring represents serious risks, including compliance risk.

A.

TRUE

B.

FALSE

Full Access
Question # 18

Control activities to manage metadata stores include:

A.

Roadmap extrapolation

B.

Load statistical analysis

C.

Lineage

D.

Missing metadata reports

E.

Definitions resolutions improvement

F.

Job scheduling and monitoring

Full Access
Question # 19

Data modelling tools are software that automate many of the tasks the data modeller performs.

A.

FALSE

B.

TRUE

Full Access
Question # 20

JSON is an open, lightweight standard format for data interchange.

A.

FALSE

B.

TRUE

Full Access
Question # 21

SOR Stands for:

A.

Service of Record

B.

System of Record

C.

System on Record

D.

Service over Record

Full Access
Question # 22

Effective data management involves a set of complex, interrelated processes that enable an organisation to use its data to achieve strategic goals.

A.

TRUE

B.

FALSE

Full Access
Question # 23

CMA is an abbreviation for Capability Maturity Assessment.

A.

TRUE

B.

FALSE

Full Access
Question # 24

Enterprise data architecture usually include the following work streams:

A.

Strategy

B.

Governance

C.

Organization

D.

Results

E.

Working methods

F.

All of the above

Full Access
Question # 25

Malware refers to any infectious software created to damage, change or improperly access a computer or network.

A.

TRUE

B.

FALSE

Full Access
Question # 26

Subtype absorption: The subtype entity attributes are included as nullable columns into a table representing the supertype entity

A.

FALSE

B.

TRUE

Full Access
Question # 27

Temporal aspects usually include:

A.

Valid time

B.

Transmitting time

C.

Transaction time

D.

Value time

Full Access
Question # 28

Possible application coupling designs include:

A.

Relaxed coupling

B.

Loose coupling

C.

Value coupling

D.

Tight coupling

Full Access
Question # 29

Device security standards include:

A.

Access policies regarding connections using mobile devices

B.

Awareness of security vulnerabilities

C.

Installation of malware software

D.

Storage of data on fixed devices

Full Access
Question # 30

Technical Metadata provides data about the technical data, the systems that store data, and the processes that move between systems.

A.

TRUE

B.

FALSE

Full Access
Question # 31

A roadmap for enterprise data architecture describes the architecture’s 3 to 5-year development path. The roadmap should be guided by a data management maturity assessment.

A.

TRUE

B.

FALSE

Full Access
Question # 32

Data profiling also includes cross-column analysis, which can identify overlapping or duplicate columns and expose embedded value dependencies.

A.

TRUE

B.

FALSE

Full Access
Question # 33

Small reference data value sets in the logical data model can be implemented in a physical model in three common ways:

A.

Create a matching separate code table

B.

Create a master shared code table

C.

None of the above

D.

Program integration by joining tables

E.

Embed rules or valid codes into the appropriate object’s definition.

F.

Roadmap Development

Full Access
Question # 34

Those responsible for the data-sharing environment have an obligation to downstream data consumers to provide high quality data.

A.

TRUE

B.

FALSE

Full Access
Question # 35

Class operations can be:

A.

General: Hidden

B.

Public: Externally visible

C.

Internally visible: Visible to children objects

D.

Private: Hidden

Full Access
Question # 36

Business glossaries have the following objectives:

A.

Improve the alignment between technology assets and the business organization

B.

All of the above

C.

Cultural factors that might improve the concepts and terminology

D.

Maximise search capability and enable access to documented institutional knowledge

E.

Enable common understanding of the core business concepts and terminology

F.

Reduce the risk that data will be misused due to inconsistent understanding of the business concepts.

Full Access
Question # 37

Veracity refers to how difficult the data is to use or to integrate.

A.

TRUE

B.

FALSE

Full Access
Question # 38

Examples of concepts that can be standardized within the data quality knowledge area include:

A.

Standard measurement methodologies

B.

Data security standards

C.

Data remediation standards and procedures

D.

None of the above

E.

Data quality rules

F.

Data quality rules

Full Access
Question # 39

Business activity information is one of the types of data that can be modelled.

A.

TRUE

B.

FALSE

Full Access
Question # 40

Controlling data availability requires management of user entitlements and of structures that technically control access based on entitlements.

A.

FALSE

B.

TRUE

Full Access
Question # 41

Data quality rules and standards are a critical form of Metadata. Ti be effective they need to be managed as Metadata. Rules include:

A.

None of the above

B.

Tied to business impact

C.

Document consistency

D.

Accessible to all data customers

E.

Hierarchical consistency

F.

Confirmed by SMEs

Full Access
Question # 42

All organizations have the same Master Data Management Drivers and obstacles.

A.

TRUE

B.

FALSE

Full Access
Question # 43

The IBM Data Governance Council model is organized around four key categories. Select the answer that is not a category.

A.

Outcomes

B.

System Lifecycles

C.

Enablers

D.

Core disciplines

E.

Supporting disciplines

Full Access
Question # 44

Data warehousing describes the operational extract, cleaning, transformation, control and load processes that maintain the data in a data warehouse.

A.

TRUE

B.

FALSE

Full Access
Question # 45

To mitigate risks, implement a network-based audit appliance, which can address most of the weaknesses associated with the native audit tools. This kind of appliance has the following benefits:

A.

Granular transaction tracking

B.

High performance

C.

Transaction time

D.

Separation of duties

Full Access
Question # 46

MPP is an abbreviation for Major Parallel Processing.

A.

TRUE

B.

FALSE

Full Access
Question # 47

The minority of operational metadata is generated as data is processed.

A.

TRUE

B.

FALSE

Full Access
Question # 48

Product Master data can only focus on an organization’s internal product and services.

A.

TRUE

B.

FALSE

Full Access
Question # 49

Some common data quality business rule types are:

A.

Definitional conformance

B.

Format compliance

C.

Range conformance

D.

Mapping conformance

Full Access
Question # 50

The first two steps in the data science process are:

A.

Define Big Data data strategy & Business Need(s)

B.

Choose Data Sources

C.

Develop Data Science Hypotheses and Mehods

D.

Acquire & Ingest Data source(s)

Full Access
Question # 51

Issues caused by data entry processes include:

A.

Data entry interface issues

B.

List entry placement

C.

Field overloading

D.

None of the above

E.

Training issues

F.

Changes to business processes

Full Access
Question # 52

Improving data quality requires a strategy that accounts for the work that needs to be done and the way people will execute it.

A.

TRUE

B.

FALSE

Full Access
Question # 53

Data can be assessed based on whether it is required by:

A.

Regulatory reporting

B.

Capturing policy

C.

Ongoing operations

D.

Provide the starting point for customizations, integration or even replacement of an application

E.

Business policy

F.

Make the integration between data management and data analytics possible

Full Access
Question # 54

Effective data management involves a set of complex, interrelated processes that disable an organization to use its data to achieve strategic goals.

A.

FALSE

B.

TRUE

Full Access
Question # 55

When constructing models and diagrams during formalisation of data architecture there are certain characteristics that minimise distractions and maximize useful information. Characteristics include:

A.

Linear symmetry

B.

A match between all diagram objects and the legend

C.

A clear and consistent legend

D.

A consistent line across display methods

E.

Consistent object attributes

F.

A clear and consistent line direction

Full Access
Question # 56

Please select the correct general cost and benefit categories that can be applied consistently within an organization.

A.

Cost of erasing data from servers

B.

Cost of improving data

C.

What the data could be sold for

D.

Benefit of higher quality data

E.

Cost of replacing data if it were lost

F.

What competitors would pay for data

Full Access
Question # 57

A synonym for transformation in ETL is mapping. Mapping is the process of developing the lookup matrix from source to target structures, but not the result of the process.

A.

TRUE

B.

FALSE

Full Access
Question # 58

Validity, as a dimension of data quality, refers to whether data values are consistent with a defined domain of values.

A.

TRUE

B.

FALSE

Full Access
Question # 59

The implementation of a Data Warehouse should follow these guiding principles:

A.

Managing performance of data assets

B.

Focus on the business goals

C.

Managing the availability of data throughout the data lifecycle

D.

Start with the end in mind

E.

Managing the performance of data transactions

F.

Collaborate

Full Access
Question # 60

Modeling Bid data is a non-technical challenge but critical if an organization that want to describe and govern its data.

A.

TRUE

B.

FALSE

Full Access
Question # 61

Three data governance operating models types include:

A.

Centralized

B.

Decentralized

C.

Feathered

D.

Federated

E.

Replicated

F.

Duplicated

Full Access
Question # 62

CIF stands for:

A.

Company Information Factory

B.

Corporate Information Floor

C.

Corporate Information Factories

D.

Corporate Information Factory

Full Access
Question # 63

Elements that point to differences between warehouses and operational systems include:

A.

Historical

B.

Data security standards

C.

Subject-orientated

D.

Non-volatile

E.

Data quality

F.

Integrated

Full Access
Question # 64

A goal of data governance is to enable an organisation to manage its data as a liability.

A.

TRUE

B.

FALSE

Full Access
Question # 65

Field overloading: Unnecessary data duplication is often a result of poor data management.

A.

TRUE

B.

FALSE

Full Access
Question # 66

A limitation of the centralized approach include: Maintenance of a decentralized repository is costly.

A.

TRUE

B.

FALSE

Full Access
Question # 67

Issues caused by data entry processes include:

A.

Training issues

B.

List entry replacement

C.

Software issues

D.

Soft state issues

E.

Change to business processes

F.

Inconsistent business process execution

Full Access
Question # 68

A control activity in the metadata management environment includes loading statistical analysis.

A.

FALSE

B.

TRUE

Full Access
Question # 69

If the target system has more transformation capability than either the source or the intermediary application system, the order of processes may be switched to ELT – Extract Load Tranform.

A.

TRUE

B.

FALSE

Full Access
Question # 70

An image processing system captures, transforms and manages images of paper and electronic documents.

A.

TRUE

B.

FALSE

Full Access
Question # 71

Managing business party Master Data poses these unique challenges:

A.

Difficulties in unique dimensions

B.

Difficulties in unique identification

C.

Reference data anomaly detection

D.

The number of data sources and the differences between them

Full Access
Question # 72

Several global regulations have significant implications on data management practices. Examples include:

A.

BCBS 239

B.

Data Standards

C.

Privacy laws

D.

Effectiveness of education Standards

E.

SPCA

F.

PCI-DSS

Full Access