Data Management Fundamentals v1.0

Page:    1 / 7   
Exam contains 99 questions

When trying to integrate a large number of systems, the integration complexities can be reduced by:

  • A. The use of a common data model
  • B. Using data quality measures and targets
  • C. Clear business specification and priorities
  • D. The use of SQL
  • E. Tackling the largest systems first


Answer : A

In order to gain endorsement to extend the use of reference and master data across the enterprise, a key supporting DMBOK knowledge area is:

  • A. Data Architecture
  • B. Data Governance
  • C. Data Storage and Operations
  • D. Data Security
  • E. Document and Content Management


Answer : B

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

  • A. Multiple data owners
  • B. Multiple integration technologies
  • C. Multiple data warehouses
  • D. Multiple metadata tags
  • E. Multiple application coding languages


Answer : B

A 'Content Distribution Network' supporting a multi-national website is likely to use:

  • A. A database backup and restore solution
  • B. An extract transform and load solution
  • C. A records disposal solution
  • D. A replication solution
  • E. An archiving solution


Answer : D

First Normal Form:

  • A. Ensures that each attribute has a balanced proportion of neutrons and protons
  • B. Ensures that each entity has no hidden primary keys
  • C. Ensures that the Party Role structure is correctly represented
  • D. Ensures that each attribute is atomic without repeating groups
  • E. Ensures that each attribute has a definition that makes sense


Answer : D

In data modelling practice, entities are linked by:

  • A. Triggers
  • B. Cardinality
  • C. Processes
  • D. Indexes
  • E. Relationships


Answer : E

Data Models are critical to effective management of data, because they:

  • A. Control the list of values in dropdown lists in applications
  • B. Strategically prepare organisations to quickly evolve their products and services
  • C. Define the rules and approval mechanisms to make changes to the data structures
  • D. Determine which style of data schema is used in a data warehouse
  • E. Provide a common vocabulary around data


Answer : E

The goal of data modelling, documenting different perspectives and aligning them in a single data model, achieves:

  • A. Applications that are deployed by simple version upgrades
  • B. Application projects that are less complicated due to a variant data model
  • C. Application performance that is guaranteed
  • D. Applications that meet the custom needs of specific business areas
  • E. Applications that more closely align to current and future business requirements


Answer : E

Significant operational issues have been caused by the implementation of a data model that represents a Customer Agreement as a ternary relationship between the Enterprise, a Customer, and their Contact Person. Which of the following describes the likely operational issue?

  • A. Every time the customer changes addresses the address for the contact person must change as well
  • B. In the event of a merger between enterprises, the contact person addresses need to be updated
  • C. Every time the contact person changes, the customer agreement needs to be re-established
  • D. Response time for retrieving the Customer Agreement degrades rapidly due to the lack of indexing
  • E. Every time the Customer Agreement was renewed, a new Contact Person record was required


Answer : C

A project scope includes the collection, exchange and reporting of data from multiple systems. Conceptual, logical and physical data models are maintained. How many models of each type can be expected?

  • A. More logical data models than physical data models, and more logical data models than conceptual data models
  • B. The same number of each of the model types
  • C. More conceptual data models than logical data models, and more logical data models than physical data models
  • D. Only 1 conceptual data model, 1 logical data model and 1 physical data model
  • E. More physical data models than logical data models, and more logical data models than conceptual data models


Answer : E

A workforce is locked out of a building due to a threat to personnel. The Business Continuity plan (BCP) is stored in the Document Management System (DMS).
Luckily:

  • A. The security policy includes such a scenario
  • B. The workforce are expendable
  • C. The document is printed and stored off site
  • D. The metadata repository holds the BCP
  • E. The data warehouse catalog is fully operational


Answer : C

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

  • A. Fitness for purpose metrics for unstructured data
  • B. Straight-through processing for NoSQL queries
  • C. Appropriate access and authorization to structured data
  • D. Appropriate access and authorization to unstructured data
  • E. Appropriate privacy controls on data marts


Answer : D

Common data loss scenarios, that a DBA plans for, are unlikely to include:

  • A. Customers losing their user guide
  • B. Loss of database server
  • C. Corruption of the physical database
  • D. Loss of transaction logs
  • E. Loss of one or more disk storage devices


Answer : A

Database monitoring tools measure key database metrics, such as:

  • A. Capacity, availability, cache performance, user statistics
  • B. Capacity, availability, backup instances, data quality
  • C. Create, read, normalization, user access
  • D. Create, read, update, delete
  • E. Capacity, design, normalization, user access


Answer : A

The goals of data storage and operations are:

  • A. Managing accessibility, ensuring authorized access and managing performance
  • B. Managing availability, ensuring consistency and managing glossaries
  • C. Managing user experience, ensuring consistency and managing glossaries
  • D. Managing user experience, ensuring data access and managing data lifecycles
  • E. Managing availability, ensuring integrity and managing performance


Answer : E

Page:    1 / 7   
Exam contains 99 questions

Talk to us!


Have any questions or issues ? Please dont hesitate to contact us

Certlibrary.com is owned by MBS Tech Limited: Room 1905 Nam Wo Hong Building, 148 Wing Lok Street, Sheung Wan, Hong Kong. Company registration number: 2310926
Certlibrary doesn't offer Real Microsoft Exam Questions. Certlibrary Materials do not contain actual questions and answers from Cisco's Certification Exams.
CFA Institute does not endorse, promote or warrant the accuracy or quality of Certlibrary. CFA® and Chartered Financial Analyst® are registered trademarks owned by CFA Institute.
Terms & Conditions | Privacy Policy