got cdmp?

© 2007 DAMA International and/or ICCP, used with permission

International

Got CDMP?Stand Out Professionally with Certification

Got CDMP?Stand Out Professionally with Certification

Presented by Eva Smith, MSIM, CCP, CDMP

(Adapted from material provided by Patricia Cupoli, CCP, CBIP, CDMP)

2007 DAMA International and/or ICCP, used with permission 2

International

TopicsTopics

Some Definitions Some History CDMP Program Overview Reasons for Certifying What Can Your Chapter Do? The CDMP Examinations Discussion

Some Definitions Some History CDMP Program Overview Reasons for Certifying What Can Your Chapter Do? The CDMP Examinations Discussion


International

DefinitionsDefinitions


International

What is a profession?What is a profession? A profession is defined as an

occupational calling (vocation) requiring specialized knowledge and skills, or the body of persons engaged in that vocation.

A profession is defined as an occupational calling (vocation) requiring specialized knowledge and skills, or the body of persons engaged in that vocation.


International

Characteristic: Community of Practice

Characteristic: Community of Practice

A professional society, guild or community of practice for the communal support of professionals

Notable members of the profession well known to the public, recognized for their professionalism

A professional society, guild or community of practice for the communal support of professionals

Notable members of the profession well known to the public, recognized for their professionalism


International

Characteristic:Specialized Knowledge & Skills

Characteristic:Specialized Knowledge & Skills

Publication of a recognized body of knowledge A professional degree or emphasis available

from an accredited higher education institution, using curriculum validated by the professional society

Availability of continuing education and expectation of continuing skills development for professionals

Publication of a recognized body of knowledge A professional degree or emphasis available

from an accredited higher education institution, using curriculum validated by the professional society

Availability of continuing education and expectation of continuing skills development for professionals


International

Characteristic: Commitment to Quality

Characteristic: Commitment to Quality

Existence of a specific code of ethics with a formal oath of commitment to this code, including obligations to society beyond occupational expectations

Registration of fitness to practice via voluntary certification or mandatory licensing

Existence of a specific code of ethics with a formal oath of commitment to this code, including obligations to society beyond occupational expectations

Registration of fitness to practice via voluntary certification or mandatory licensing


International

Examples of Professional Communities:

Examples of Professional Communities:

DAMA (of course!) (http://www.dama.org) IIBA (http://www.theiiba.org)

International Institute for Business Analysts SIM (http://www.simnet.org/ )

Society for Information Management BPMI (http://www.bpminstitute.org)

Business Process Management Institute ACM (http://www.acm.org)

Association of Computing Machinery AITP (http://www.aitp.org)

Association of Information Technology Professionals

DAMA (of course!) (http://www.dama.org) IIBA (http://www.theiiba.org)

International Institute for Business Analysts SIM (http://www.simnet.org/ )

Society for Information Management BPMI (http://www.bpminstitute.org)

Business Process Management Institute ACM (http://www.acm.org)

Association of Computing Machinery AITP (http://www.aitp.org)

Association of Information Technology Professionals

http://www.dam.org/

http://www.theiiba.org/

http://www.simnet.org/

http://www.bpminstitute.org/

http://www.acm.org/

http://www.aitp.org/

http://www.dam.org/

http://www.theiiba.org/

http://www.simnet.org/

http://www.bpminstitute.org/

http://www.acm.org/

http://www.aitp.org/


International

Certification: A DefinitionCertification: A Definition A process for ensuring that an

individual has the knowledge, skills and/or abilities needed to perform a job, job role, duty or responsibility at a standard level of performance

A process for ensuring that an individual has the knowledge, skills and/or abilities needed to perform a job, job role, duty or responsibility at a standard level of performance

Source: IBM Training Presentation, used with permission


International

Certification must be:Certification must be: Measurable Validity Legally Defensible Job Related

Measurable Validity Legally Defensible Job Related


International

What Certification is NotWhat Certification is Not

An event A class An end-of-course exam Subjective

An event A class An end-of-course exam Subjective


International

Certification BasicsCertification Basics Vendor Neutrality Assessment Methods

Education-based Exam-based

Certifying Bodies Commercial Professional Associations Academic

Vendor Neutrality Assessment Methods

Education-based Exam-based

Certifying Bodies Commercial Professional Associations Academic


International

Vendor NeutralityVendor Neutrality

Vendor certifications Assess skills related to a specific product set Examples: Microsoft’s MCSE, Oracle DBA

Vendor-neutral Assess specific skill-sets, not products Examples: CompTIA’s A+ , ICCP

Vendor certifications Assess skills related to a specific product set Examples: Microsoft’s MCSE, Oracle DBA

Vendor-neutral Assess specific skill-sets, not products Examples: CompTIA’s A+ , ICCP


International

Assessment MethodsAssessment Methods

Education-based Typically requires completing a program

of study Qualitative and quantitative assessment Examples: UW Extension Programs

Exam-based Quantitative, Multiple-choice exams Examples: Most non-academic

Education-based Typically requires completing a program

of study Qualitative and quantitative assessment Examples: UW Extension Programs

Exam-based Quantitative, Multiple-choice exams Examples: Most non-academic


International

Certifying BodiesCertifying Bodies Commercial

Sell product, or sell exams and training for profit

Professional Associations Non-profit Exist to support the profession

Academic Typically accredited institution Can be for-profit or public funded

Commercial Sell product, or sell exams and training for

profit Professional Associations

Non-profit Exist to support the profession

Academic Typically accredited institution Can be for-profit or public funded


International

What is the ICCP?What is the ICCP? Institute for Certification of Computing

Professionals Independent certification organization A Consortium of Professional Associations Offers vendor & product-neutral exams Handles DAMA International exam

administration

Institute for Certification of Computing Professionals

Independent certification organization A Consortium of Professional Associations Offers vendor & product-neutral exams Handles DAMA International exam

administration


International

What does ICCP do?What does ICCP do? Establishes recognized professional standards

within the information systems and information technology industry

Tests knowledge of stringent industry fundamentals, not product-specific awareness

Establishes recognized professional standards within the information systems and information technology industry

Tests knowledge of stringent industry fundamentals, not product-specific awareness


International

HistoryHistory


International

1993: DAMA / ICCP team created the Data Resource Mgmt exam

1994: DAMA became an ICCP affiliate 2002: DAMA became ICCP constituent

member

1993: DAMA / ICCP team created the Data Resource Mgmt exam

1994: DAMA became an ICCP affiliate 2002: DAMA became ICCP constituent

member

DAMA I Certification History


International

2004: Three new data exams implemented: Data

Management, Data Warehousing and Database Administration

CDMP program introduced 2007:

Business Intelligence & Analytics Under Construction: Data/Information

Quality

2004: Three new data exams implemented: Data

Management, Data Warehousing and Database Administration

CDMP program introduced 2007:

Business Intelligence & Analytics Under Construction: Data/Information

Quality


International

DAMA I Certification & Model Curriculum

ICCP exams used by many colleges and universities to assess students’ exiting competency

ICCP data exams designed to test knowledge of IRM/DRM function

Serves as validation for the proposed DAMA IRM/DRM curriculum Exam topics covered in curriculum (& DMBOK)

ICCP exams used by many colleges and universities to assess students’ exiting competency

ICCP data exams designed to test knowledge of IRM/DRM function

Serves as validation for the proposed DAMA IRM/DRM curriculum Exam topics covered in curriculum (& DMBOK)


International

CDMP Program OverviewCDMP Program Overview


International

What is the CDMP?What is the CDMP? Certified Data Management Professional Professional Designation Awarded by

DAMA International & the ICCP

Certified Data Management Professional Professional Designation Awarded by

DAMA International & the ICCP


International

CDMP Exams TakenCDMP Exams Taken

0

50

100

150

200

250

300

YTD Aug04

YTD Aug05

YTD Aug06

YTD Aug07

# of Exams

# of Exams


International

How can I get a CDMP?How can I get a CDMP?Fill out application (www.dama.org)Pass the Core ExamTwo Specialty ExamsOne Specialty Exam must be taken from:

Data ManagementData WarehousingDatabase Administration

Meet the Experience & Education qualifications

Sign the ICCP Code of Ethics


International

CORE EXAMINATION

CDMP CERTIFICATION

One Data Specialty Exam

One Other Specialty Exam

Experience/Education Qualifications

Sign Code of Ethics


International

How many exams?How many exams?

Three Examinations 90 minutes, 110 questions each Pass Exams at 70% or better for

Mastery Level 50%-69% for Practitioner Level

Three Examinations 90 minutes, 110 questions each Pass Exams at 70% or better for

Mastery Level 50%-69% for Practitioner Level


International

Specialty Exam ChoicesICCP Exams include:

Data ManagementData WarehousingDatabase AdministrationBusiness Intelligence &

Analytics (beta)Integrated Project ManagementIT ManagementSystems DevelopmentOthers


International

CDMP Requirements

Experience & Education48 months experience 24 months for Practitioner levelSubstitute up to 24 months of the experience requirement with appropriate undergraduate or graduate degree

Three-year recertification cycle


International

SubstitutionsSubstitutions

These programs are pre-qualified to substitute for one specialty exam. Others may qualify.

These programs are pre-qualified to substitute for one specialty exam. Others may qualify.

Certified Insurance Data Manager (CIDM)

IBM Certified Database Administrator

IBM Certified Advanced DBA IBM Certified Solutions Expert

Microsoft Certified Database Administrator

Teradata Certified Professional

Oracle Certified Professional Oracle Database Administrator


International

Additional CDMP Certification Procedures

Additional CDMP Certification Procedures

ICCP will issue certificates and ICCP performance profiles to candidates

Candidates may arrange through the ICCP to sit for the same examination or other exams

ICCP will issue certificates and ICCP performance profiles to candidates

Candidates may arrange through the ICCP to sit for the same examination or other exams


International

Exam PrepExam Prep ICCP offers Sponsored Review Courses through

chapters or companies Study materials and exam review course

available through ICCP office ([email protected]) DAMA study materials ([email protected]):

Data Management Exam Study Guide Data Warehousing Exam Study Guide

ICCP offers Sponsored Review Courses through chapters or companies

Study materials and exam review course available through ICCP office ([email protected])

DAMA study materials ([email protected]): Data Management Exam Study Guide Data Warehousing Exam Study Guide


International

How do I take exams?How do I take exams?

Contact ICCP to arrange for a proctor

Attend an Exam Prep class Find a proctor (a CDMP or CCP

holder, educator, testing center) and have them make arrangements with ICCP

Contact ICCP to arrange for a proctor

Attend an Exam Prep class Find a proctor (a CDMP or CCP

holder, educator, testing center) and have them make arrangements with ICCP


International


International

ICCP Performance Profile ICCP Performance Profile

PERFORMANCE PROFILEContent Number Your Status Percen- 2 5 7 9Description Of Items Score tile 1 5 0 5 9

Systems Development 100 77 Pass 85 **********************1. Systems Analysis 39 33 94 ************************

1.1 General System Theory 4 31.2 Preliminary Studies 10 91.3 Problem Definition 5 51.4 Data Gathering/Analysis 10 81.5 System Requirements 10 8

2. Systems Design & Imp’n 52 38 80 **********************2.1 Alternative Sys. Design 5 52.2 Logical Design 10 92.3 Detailed System Design 17 102.4 Privacy/Sec’y/Controls 8 82.5 System Implementation 7 12.6 System Eval’n and Mtce. 5 5

3. Systems Analyst as Prof’l 9 6 41 ********3.1 Organizational Roles 3 23.2 Interpersonal Roles 2 23.3 Communication Skills 2 03.4 Ident. Key Individuals 2 2


International

Recertification Recertification Goals

Maintain professional competence

Update existing knowledge and skills

Attain new or additional knowledge and skills

Goals Maintain professional

competence Update existing

knowledge and skills Attain new or

additional knowledge and skills

Guidelines 3 year cycle Earn 120 approved

contact hours of continuing education

Pay $75 per year maintenance fee to ICCP

Receive Annual Transcript from ICCP

Guidelines 3 year cycle Earn 120 approved

contact hours of continuing education

Pay $75 per year maintenance fee to ICCP

Receive Annual Transcript from ICCP


International

Types of Continuing Education

Formal educational institutions Independent organized programs Professional society meetings,

seminars, conferences Write ICCP examination questions Articles, teaching, lecturing Self-study programs Sit for other ICCP examinations


International

Reasons for CertifyingReasons for Certifying


International

ProfessionalismProfessionalism

“Certification, in itself , is not a goal, but Professionalism is.”

Dr. Paul M. Pair, ICCP Fellow, 1982


International

Reasons for Seeking Certification

Source: Prometric (Dataquest Study)

Advancement in Profession 41.7%

Advancement in Current Job 17.2%

Secure Employment 8.1%

Job Requirement 8.0%

Improve Job Security 4.8%

Assess Current Expertise 3.1%

Increase Compensation 2.4%

Attain Access to Vendor Support 1.8%

Other 3.6%

Prepare for New Job 9.4%

0.0% 10.0% 20.0% 30.0% 40.0% 50.0%


International

Why People CertifyWhy People Certify

Professional GrowthConsultantsContractorsJob HuntersPromotion Seekers

CredentialsSelf-AssessmentProfessionalismChallenge

Financial Reward0.4%

Professional Growth45.3%

Company Requirement

0.4%

Credential37.3% Self-Evaluation

5.1%

Other11.4%


International

Primary Achievement Resulting from Certification

"Greater Self-Esteem"

22%

"More Credibility within

Organization"24%

"Solve Problems Quicker"

19%

"Increase in Salary"

11%

"More Credibility with Customers"

24%


International

Positive Business ImpactPositive Business Impact

17

34

59

30

23

$1,000 or less$1,000 to $2,000

$2,000 to $5,000$5,000 to $10,000

more than $10,000

Currency (American Dollars)

0

10

20

30

40

50

60

70

Amount of Money Invested in Certification Per Individual (M = $6,525)

90%

10%

Yes No0%

25%

50%

75%

100%

Does the Investment yield the Anticipated ROI?

Source: 1999 IBM Professional Certification Survey


International

Career GrowthCareer Growth Many consulting firms pay bonuses averaging $5,000

for those who achieve professional certifications Large corporations typically reimburse employees for

review course, testing, etc. and many provide bonuses from $100 to $1,000+

Government agencies pay for training, exams, provide bonuses, and some give permanent salary increases (up to 15%)

Surveys consistently show that certified individuals earn more than their counterparts and hold more advanced positions

Many consulting firms pay bonuses averaging $5,000 for those who achieve professional certifications

Large corporations typically reimburse employees for review course, testing, etc. and many provide bonuses from $100 to $1,000+

Government agencies pay for training, exams, provide bonuses, and some give permanent salary increases (up to 15%)

Surveys consistently show that certified individuals earn more than their counterparts and hold more advanced positions


International

AMERICAN COUNCIL ON EDUCATION (ACE)

ACE awards undergraduate college credits

for achievement of the ICCP exams

9 credits for the Core Examination

3 credits for most of the expert specialty examinations, e.g. DRM

4 credits for Microcomputers and Networking

2 credits for Procedural Programming


International

What Can Your Chapter Do?

What Can Your Chapter Do?


International

Sponsor Review CourseSponsor Review Course Test takers who go through a review course

for the ICCP examinations improve their performance by almost 30% on the final examinations.

The CDMP Review ("exam prep") program is available for a customized delivery from ICCP

Hold your own review courses Order books and course materials from ICCP Coordinate with AITP and other

professional associations

Test takers who go through a review course for the ICCP examinations improve their performance by almost 30% on the final examinations.

The CDMP Review ("exam prep") program is available for a customized delivery from ICCP

Hold your own review courses Order books and course materials from ICCP Coordinate with AITP and other

professional associations


International

Schedule Exam SessionsSchedule Exam Sessions Administer Exams

Requires an approved Proctor CCP or CDMP holder, Professor at local University, HR Manager

Can give the exams at a discount to make money for your chapter

Promote the exams in conjunction with local AITP chapters in conjunction with local colleges and

universities

Administer Exams Requires an approved Proctor

CCP or CDMP holder, Professor at local University, HR Manager

Can give the exams at a discount to make money for your chapter

Promote the exams in conjunction with local AITP chapters in conjunction with local colleges and

universities


International

Track Continuing Education HoursTrack Continuing Education Hours

Attendance at DAMA meetings and events qualify for recertification hours

Keep a sign in sheet for your events for people wishing to be credited with continuing education hours

Periodically (quarterly/annually) have an officer submit recertification credits to ICCP & other recertification programs

Attendance at DAMA meetings and events qualify for recertification hours

Keep a sign in sheet for your events for people wishing to be credited with continuing education hours

Periodically (quarterly/annually) have an officer submit recertification credits to ICCP & other recertification programs


International

Exam PhilosophyExam Philosophy Item Writer’s Guide http://iccp.org/iccpnew/iwguide.html Exam Subject Outlines

http://www.iccp.org/iccpnew/outlines.html Contents of each exam

100 experience based randomized multiply choice questions (scored)

Plus 10 beta multiply choice randomized questions (not scored)

Exams: Product & vendor neutral International in nature

Item Writer’s Guide http://iccp.org/iccpnew/iwguide.html Exam Subject Outlines

http://www.iccp.org/iccpnew/outlines.html Contents of each exam

100 experience based randomized multiply choice questions (scored)

Plus 10 beta multiply choice randomized questions (not scored)

Exams: Product & vendor neutral International in nature


International

What does it cost?

IT Core $250First Data Specialty $250Second Specialty $250Total USD $750

Exam Prep Course (2-days) $495

All fees are non-refundableCandidates may re-schedule within 48 hours of an exam date


International

Seattle Exam Prep CourseSeattle Exam Prep Course

“Boot Camp” Nov. 1 and 2 Best Western Executive Inn 8:30 a.m. - 6:00 p.m. (or longer) Morning prep sessions Afternoon exam sessions $495 - includes all materials

“Boot Camp” Nov. 1 and 2 Best Western Executive Inn 8:30 a.m. - 6:00 p.m. (or longer) Morning prep sessions Afternoon exam sessions $495 - includes all materials


International

QUESTIONS SO FAR? QUESTIONS SO FAR?


International

The CDMP Exams & Sample Questions

The CDMP Exams & Sample Questions

IT Core

Data Management

Data Warehousing

Database Administration


International

IT Core Exam TopicsIT Core Exam Topics1. Human & Organization

Framework (19%) 1.1 Business Environment 1.2 Management 1.3 Technology Transfer 1.4 Interpersonal

Communication 1.5 Professional Issues2. Systems Concepts (12%) 2.1 Types of Systems 2.2 Application Strategies3. Data and Information

(19%) 3.1 Data Architectures 3.2 Data Management

1. Human & Organization Framework (19%)

1.1 Business Environment 1.2 Management 1.3 Technology Transfer 1.4 Interpersonal

Communication 1.5 Professional Issues2. Systems Concepts (12%) 2.1 Types of Systems 2.2 Application Strategies3. Data and Information

(19%) 3.1 Data Architectures 3.2 Data Management

4. Systems Development (21%) 4.1 SDLC 4.2 Systems Integration 4.3 Tools and Techniques5. Technology (16%) 5.1 Hardware 5.2 Software6. Associated Disciplines (14%) 6.1 Financial Management and Analysis 6.2 Management Science 6.3 Systems Auditing 6.4 Mathematics 6.5 Statistics


International

Core Sample Question #1Core Sample Question #1

A list of the open accounts in a ledger showing their debit and credit balances is known as

A) a trial balance B) a PL statement C) a closing journal D) an account analysis


A) a trial balance B) a PL statement C) a closing journal D) an account analysis


International



A) a trial balance * B) a PL statement C) a closing journal D) an account analysis


A) a trial balance * B) a PL statement C) a closing journal D) an account analysis


International


What management function is concerned with the grouping of activities to be performed and the establishment of institutional structures to carry them out?

A) Planning B) Organizing C) Controlling D) Coordinating


A) Planning B) Organizing C) Controlling D) Coordinating


International



A) Planning B) Organizing * C) Controlling D) Coordinating


A) Planning B) Organizing * C) Controlling D) Coordinating


International


The Gantt chart is a planning tool whose primary basis of measurement is:

A) Time B) Events C) Manpower D) Milestones


A) Time B) Events C) Manpower D) Milestones


International



A) Time * B) Events C) Manpower D) Milestones


A) Time * B) Events C) Manpower D) Milestones


International

Data Management Exam TopicsData Management Exam Topics1. Data Management Function (18%)

1.1 Planning 1.2 Organization 1.3 Roles and Responsibilities

2. Data & Metadata Infrastructure Creation / Maintenance (15%)2.1 Planning for Data & Metadata 2.2 Tools and Technology Types

3. Data Analysis and Design (37%)3.1 Data / Metadata Analysis & Design 3.2 Data Model Components 3.3 Data / Metadata Model Management

4. Data / Metadata Infrastructure Management (12%)4.1 Standards, Policies, Procedures, Guidelines 4.2 Data Security and Privacy

5. Information Quality Management (18%)5.1 Information Quality Principles 5.2 Information Quality Assessment / Audit 5.3 Information Quality Improvement


International

DM Sample Question #1DM Sample Question #1

A word such as CUSTOMER in a column name should

A) be abbreviated in every column name the same way.

B) not be abbreviated. C) be abbreviated but a different abbreviation may

be used in different columns depending upon the additional characters allowed-e.g.-CUST in some columns, CST in others where additional space needs to be saved.

D) be abbreviated only when necessary.


A) be abbreviated in every column name the same way.





International



A) be abbreviated in every column name the same way.*





A) be abbreviated in every column name the same way.*





International


A subject area model describes A) business subjects and the data contained within

them. B) data entities and the subjects that they contain. C) data subjects mapped to legacy systems. D) business subjects and the relationships among

them.


them. B) data entities and the subjects that they contain. C) data subjects mapped to legacy systems. D) business subjects and the relationships among

them.


International



them. B) data entities and the subjects that they contain. C) data subjects mapped to legacy systems. D) business subjects and the relationships

among them. *


them. B) data entities and the subjects that they contain. C) data subjects mapped to legacy systems. D) business subjects and the relationships

among them. *


International


A data model in the first normal form has no

A) keys or identifiers. B) relationships. C) repeating groups. D) data redundancy.


A) keys or identifiers. B) relationships. C) repeating groups. D) data redundancy.


International



A) keys or identifiers. B) relationships. C) repeating groups. * D) data redundancy.


A) keys or identifiers. B) relationships. C) repeating groups. * D) data redundancy.


International


What is a primary key in one entity that appears in a related entity either as a non-key or as part of the key?

A) Foreign key B) Primary key C) Candidate key D) Composite key


A) Foreign key B) Primary key C) Candidate key D) Composite key


International



A) Foreign key * B) Primary key C) Candidate key D) Composite key


A) Foreign key * B) Primary key C) Candidate key D) Composite key


International


The primary responsibility of a data steward is to

A) review data definitions. B) enforce data policies. C) facilitate consensus about data definitions

and usage. D) approve data models.


A) review data definitions. B) enforce data policies. C) facilitate consensus about data definitions

and usage. D) approve data models.


International



A) review data definitions. B) enforce data policies. C) facilitate consensus about data

definitions and usage. * D) approve data models.


A) review data definitions. B) enforce data policies. C) facilitate consensus about data

definitions and usage. * D) approve data models.


International


The primary considerations of data quality are

A) completeness and accuracy. B) precision and granularity. C) valid values and referential

integrity. D) timely updates and easy access.


A) completeness and accuracy. B) precision and granularity. C) valid values and referential



International



A) completeness and accuracy. * B) precision and granularity. C) valid values and referential



A) completeness and accuracy. * B) precision and granularity. C) valid values and referential



International


The first major step in developing an enterprise model is to identify

A) user requirements. B) existing business systems. C) the chain of command. D) enterprise boundaries.


A) user requirements. B) existing business systems. C) the chain of command. D) enterprise boundaries.


International



A) user requirements. B) existing business systems. C) the chain of command. D) enterprise boundaries. *


A) user requirements. B) existing business systems. C) the chain of command. D) enterprise boundaries. *


International

Data Warehousing Exam TopicsData Warehousing Exam Topics1. Data Warehousing Function (19%)

1.1 Planning 1.2 Organization 1.3 Roles and Responsibilities

2. Data Warehouse Infrastructure Creation / Maintenance (21%)2.1 Data Warehouse Architectures 2.2 Data Warehouse Informational Database Architectures Types 2.3 Tools and Technology Types

3. Data Warehousing Analysis and Design (27%)3.1 Requirements Analysis 3.2 Data Warehouse Model Types and Components 3.3 Data Modeling for the Data Warehouse

4. Data Acquisition and Cleansing (10%)4.1 Source Data Acquisition4.2 Source Data Cleansing

5. Data Warehouse Implementation and Operation (23%)5.1 Development5.2 Deployment 5.3 Ongoing Support and Maintenance


International

DW Sample Question #1DW Sample Question #1

The two most common data integration architectures are

A) bus and hub-and-spoke. B) normalized and dimensional. C) data flow and data structure. D) star-schema and snowflake-schema.


A) bus and hub-and-spoke. B) normalized and dimensional. C) data flow and data structure. D) star-schema and snowflake-schema.


International



A) bus and hub-and-spoke. * B) normalized and dimensional. C) data flow and data structure. D) star-schema and snowflake-schema.


A) bus and hub-and-spoke. * B) normalized and dimensional. C) data flow and data structure. D) star-schema and snowflake-schema.


International


A data mart is a(n) A) end-user download from the data

warehouse. B) workgroup or business domain oriented

warehousing data store. C) internet portal to warehousing data. D) data warehouse subject area.


warehouse. B) workgroup or business domain oriented

warehousing data store. C) internet portal to warehousing data. D) data warehouse subject area.


International



warehouse. B) workgroup or business domain

oriented warehousing data store. * C) internet portal to warehousing data. D) data warehouse subject area.


warehouse. B) workgroup or business domain

oriented warehousing data store. * C) internet portal to warehousing data. D) data warehouse subject area.


International


Business drivers, goals, and strategies provide __________ for data warehousing activity programs.

A) requirements B) success measures C) context D) architecture


A) requirements B) success measures C) context D) architecture


International



A) requirements B) success measures C) context * D) architecture


A) requirements B) success measures C) context * D) architecture


International

Database Administration Exam Topics

Database Administration Exam Topics

1. Database Administration Function (10%)1.1 Planning1.2. Organization1.3. Roles & Responsibilities

2. Database Management Systems (DBMS)

Environment (16%)2.1. Planning for the DBMS

Environment2.2 Tools and Technology

Types3. Database Design (34%)

3.1. Data Modeling3.2. Data Access Methods 3.3. File Organization Methods3.4. Distribution Design

Considerations 3.5. Performance Modeling3.6. Database Design Reviews

4. Database Operation (30%)4.1. Database Standards4.2. Distributed Data Management4.3. Performance Tuning4.4. Backup and Recovery4.5. Database Processing Logic4.6. Data Storage Management 4.7 Database Connectivity

5. SQL Considerations (10%) 5.1. SQL Basics 5.2. DDL - Data Definition

Language 5.3. DML - Data Manipulation

Language 5.4. DCL - Data Control Language5.5. Data Dictionary (Systables)


International

DBA Sample Question #1DBA Sample Question #1

For maximum performance, transaction systems should have

A) as many indexes as possible. B) bitmap indexes placed on all

primary keys. C) logging turned off. D) a limited number of indexes.



primary keys. C) logging turned off. D) a limited number of indexes.


International




primary keys. C) logging turned off. D) a limited number of indexes. *



primary keys. C) logging turned off. D) a limited number of indexes. *


International


Horizontal partitioning can be used to

A) locate data close to where they are used. B) improve the consistency of access speed

across the database. C) reduce backup vulnerability. D) reduce the need for free space.


A) locate data close to where they are used. B) improve the consistency of access speed

across the database. C) reduce backup vulnerability. D) reduce the need for free space.


International



A) locate data close to where they are used.*

B) improve the consistency of access speed across the database.

C) reduce backup vulnerability. D) reduce the need for free space.


A) locate data close to where they are used.*

B) improve the consistency of access speed across the database.

C) reduce backup vulnerability. D) reduce the need for free space.


International


Which of the following is NOT a common use of DBMS replication features?

A) Disaster recovery B) Feeding a data warehouse C) Data distribution D) Rapid transaction processing


A) Disaster recovery B) Feeding a data warehouse C) Data distribution D) Rapid transaction processing


International



A) Disaster recovery B) Feeding a data warehouse C) Data distribution D) Rapid transaction processing *


A) Disaster recovery B) Feeding a data warehouse C) Data distribution D) Rapid transaction processing *


International

DiscussionDiscussionFor CDMP Program Information:

Patricia Cupoli, ICCP [email protected] orEva Smith, ICCP [email protected] DAMA website is www.dama.org

For ICCP Exam Administration:

ICCP office at: [email protected] or go to www.iccp.org

got cdmp?

Documents

professional degree

recognized body of knowledge

computing machineryaitp

business analystssim

information systems

voluntary certification

dama international andor

specific product setexamples