<< Prev Question Next Question >>

Question 49/169

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

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (169q)
Question 1: The implementation of a Data Warehouse should follow these g...
Question 2: DBAs and database architects combine their knowledge of avai...
Question 3: Valuation information, as an example of data enrichment, is ...
Question 4: An input in the data architecture context diagram includes d...
Question 5: Technical metadata describes details of the processing and a...
Question 6: The load step of the ETL is physically storing or presenting...
Question 7: ECM is an abbreviation for:
Question 8: The goals of data security include:...
1 commentQuestion 9: Triplestores can be classified into these categories:...
Question 10: The Data Model Scorecard provides 10 data model quality metr...
Question 11: The most important reason to implement operational data qual...
Question 12: Data security internal audits ensure data security and regul...
Question 13: In a SQL injection attack, a perpetrator inserts authorized ...
Question 14: The acronym CMDB stands for:
Question 15: Self-service is a fundamental delivery channel in the BI por...
Question 16: The first two steps in the data science process are:...
Question 17: Please select the correct name for the PDM abbreviation when...
Question 18: The biggest business driver for developing organizational ca...
Question 19: SDLC stands for:
Question 20: A synonym for transformation in ETL is mapping. Mapping is t...
Question 21: The deliverables in the data architecture context diagram in...
Question 22: Barriers to effective management of data quality include:...
Question 23: Sample value metrics for a data governance program include:...
Question 24: The impact of the changes from new volatile data must be iso...
Question 25: Data Integration and Interoperability (DII) describes proces...
Question 26: A communication plan includes an engagement model for stakeh...
Question 27: Issues caused by data entry processes include:...
Question 28: An application DBA leads the review and administration of pr...
Question 29: A Metadata repository contains information about the data in...
Question 30: Reference data management entails the preventative maintenan...
Question 31: Through similarity analysis, slight variation in data can be...
Question 32: Drivers for data governance most often focus on reducing ris...
Question 33: One of the deliverables in the Data Integration and Interope...
Question 34: Vulnerability is defined as:
Question 35: Business glossaries have the following objectives:...
Question 36: In gathering requirements for DW/BI projects, begin with the...
Question 37: Typically, DW/BI projects have three concurrent development ...
Question 38: In an information management context, the short-term wins an...
Question 39: A 'Golden Record' means that it is always a 100% complete an...
Question 40: Data Warehouse describes the operational extract, cleansing,...
Question 41: Access to data for Multidimensional databases use a variant ...
Question 42: Integration of ETL data flows will usually be developed with...
Question 43: Those responsible for the data-sharing environment have an o...
Question 44: The categories of the Data Model Scorecard with the highest ...
Question 45: Factors that have shown to play a key role in the success in...
Question 46: SOA stand for Service Orchestrated Architecture...
Question 47: Effectiveness metrics for a data governance programme includ...
Question 48: The CAP theorem states that at most two of the three propert...
Question 49: Subtype absorption: The subtype entity attributes are includ...
Question 50: Bold means doing something that might cause short term pain,...
Question 51: Examples of the 'What' entity category include the following...
Question 52: Data models are critical to effective management of dat a. T...
Question 53: A sandbox is an alternate environment that allows write-only...
Question 54: Quality Assurance Testing (QA) is used to test functionality...
Question 55: Device security standard include:...
Question 56: Creating the CDM involves the following steps:...
Question 57: Databases are categorized in three general ways:...
Question 58: A goal of data governance is to enable an organisation to ma...
Question 59: Data warehouses are often loaded and serviced by a nightly b...
Question 60: The database administrator (DBA) is the most established and...
Question 61: Please select the answer that does not represent a machine l...
Question 62: Metadata is described using different set of categories, inc...
Question 63: Snowflaking is the term given to normalizing the flat, singl...
Question 64: Malware types include:
Question 65: Technical Metadata provides data about the technical data, t...
Question 66: Inputs in the reference and master data context diagram incl...
Question 67: Poorly managed Metadata leads to, among other, redundant dat...
Question 68: DAMA International's Certified Data Management Professional ...
Question 69: The goals of data storage and operations include:...
Question 70: Effective document management requires clear policies and pr...
Question 71: Please select the transition phases in Bridges' Transition p...
Question 72: The Shewhart chart contains the following elements:...
Question 73: When selecting a DMM framework one should consider of it is ...
Question 74: Data mining is a sub-field of supervised learning where user...
Question 75: An implemented warehouse and its customer-facing BI tools is...
Question 76: Archiving is the process of moving data off immediately acce...
Question 77: Please select the correct General Accepted Information Princ...
Question 78: Data Governance is at the centre if the data management acti...
Question 79: Changes to reference data do not need to be management, only...
Question 80: The accuracy dimension has to do with the precision of data ...
Question 81: Data security issues, breaches and unwarranted restrictions ...
Question 82: A dimensional physical data model is usually a star schema, ...
Question 83: Issues caused by data entry processes include:...
Question 84: The second stage of Kotter's eight stage process is:...
Question 85: ANSI 859 recommends taking into account the following criter...
Question 86: The impact of the changes from new volatile data must be iso...
Question 87: Analytics models are associated with different depths of ana...
Question 88: SOA is an abbreviation for service orientated architecture....
Question 89: Data science depends on:
Question 90: XML provides a language for representing both structures and...
Question 91: Confirming and documenting understanding of different perspe...
Question 92: Please select the user that best describes the following des...
Question 93: A hacker is a person who finds unknown operations and pathwa...
Question 94: A roadmap for enterprise data architecture describes the arc...
Question 95: Data Management Professionals only work with the technical a...
Question 96: The flow of data in a data integration solution does not hav...
Question 97: Data management professionals who understand formal change m...
Question 98: The best preventative action to prevent poor quality data fr...
Question 99: Normalisation is the process of applying rules in order to o...
Question 100: Measuring the effects of change management on in five key ar...
Question 101: On example of a transformation process in ETL is:...
1 commentQuestion 102: Wat data architecture designs represent should be clearly do...
Question 103: Enterprise data architecture usually include the following w...
Question 104: While the focus of data quality improvement efforts is often...
Question 105: Organizations conduct capability maturity assessments for a ...
Question 106: Inputs in the data storage and operations context diagram in...
Question 107: A sandbox environment can either be a sub-set of the product...
Question 108: Improving an organization's ethical behaviour requires an in...
Question 109: Record management starts with a vague definition of what con...
Question 110: Data asset valuation is the process of understanding and cal...
Question 111: Data governance program must contribute to the organization ...
Question 112: In the context of big data the Three V's refer to: Volume, V...
Question 113: SLA Stands for:
Question 114: Typically, DW/BI have three concurrent development tracks:...
Question 115: DBAs exclusively perform all the activities of data storage ...
Question 116: Please select the 3 visuals that depict DAMA's Data Manageme...
Question 117: In designing and building the database, the DBA should keep ...
Question 118: Controlling data availability requires management of user en...
Question 119: Metadata is described using a different set of categories, n...
Question 120: When assessing security risks it is required to evaluate eac...
Question 121: Veracity refers to how difficult the data is to use or to in...
Question 122: Operational Metadata describes details of the processing and...
Question 123: Issue management is the process for identifying, quantifying...
Question 124: Please select the correct definition of Data Management from...
Question 125: A content strategy should end with an inventory of current s...
Question 126: Big data primarily refers specifically to the volume of the ...
Question 127: A control activity in the metadata management environment in...
Question 128: Communication should start later in the process as too many ...
Question 129: The implementation of a Data Warehouse should follow guiding...
Question 130: Master data is an aggregation of:...
Question 131: The purpose of data governance is to ensure that data is man...
Question 132: Within projects, conceptual data modelling and logical data ...
Question 133: Different types of product Master Data solutions include:...
Question 134: To build models, data modellers heavily rely on previous ana...
Question 135: Some common data quality business rule types are:...
Question 136: Some ways to measure value of data include:...
Question 137: Data integrity is the state of being partitioned - protected...
Question 138: Change only requires change agents in special circumstances,...
Question 139: Deliverables in the data management maturity assessment cont...
Question 140: Possible application coupling designs include:...
Question 141: The data in Data warehouses and marts differ. Data is organi...
Question 142: Data and enterprise architecture deal with complexity from t...
Question 143: The IBM Data Governance Council model is organized around fo...
Question 144: Enterprise data architecture project-related activities incl...
Question 145: A deliverable in the data security context diagram is the da...
Question 146: If the target system has more transformation capability than...
Question 147: Traditional tool sin data visualtization have both a data an...
Question 148: The four A's in security processes include:...
Question 149: Many people assume that most data quality issues are caused ...
Question 150: Class operations can be:
Question 151: A node is a group of computers hosting either processing or ...
Question 152: An implemented warehouse and its customer facing BI tool is ...
Question 153: Activities that drive the goals in the context diagram are c...
Question 154: Change Data Capture is a method of reducing bandwidth by fil...
Question 155: Small reference data value sets in the logical data model ca...
Question 156: Data flows map and document relationships between data and:...
Question 157: Data quality issues only emerge at initial stages of the dat...
Question 158: The better an organization understands the lifecycle and lin...
Question 159: In the Abate Information Triangle the past moves through the...
Question 160: Data governance requires control mechanisms and procedures f...
Question 161: Common OLAP operations include:...
Question 162: One of the percentages to measure success of a records manag...
Question 163: Data stewardship is the least common label to describe accou...
Question 164: Examples of transformation in the ETL process onclude:...
Question 165: Data governance requires control mechanisms and procedures f...
Question 166: Please select the incorrect item that does not represent a d...
Question 167: Please select the correct component pieces that form part of...
Question 168: Data profiling is a form of data analysis used to inspect da...
Question 169: As an often-overlooked aspects of basic data movement archit...