🚧 Under construction — VoTechWorks is being built. A free tech program — complimentary, as our commitment to get America working.
voTechWorksGrade 13 · a vocational technology learning center, by urbanicity
newSchoolWorks.com › VoTechWorks › Technology & Design › Data Management / Database Administration › Certification Exam Preparation: PostgreSQL CE, Oracle DBA CA, Microsoft DP-300, and DAMA CDMP Associate › Lesson 3
TEC-DATA86-12 · Lesson 3 · 20 clock hours · theory

Microsoft DP-300 and DAMA CDMP Associate Domain Review

Objective. Students review and accurately explain the high-weight exam domains for the Microsoft DP-300 and DAMA CDMP Associate credentials, practicing scenario-based and concept-based questions that match each exam's published format.

⚠ Pending professional review

This lesson, its worked examples and its practice questions has not yet been verified by an industry-certified professional or by a certification or approval body. It is a study draft and may contain errors. Do not use it as instructions for work on a job site or on live equipment. Always follow your instructor, your supervising professional, and current official references and regulations.

VoTechWorks program approval and accreditation are still in progress. Credentials are issued only by the certifying bodies named in each program, after their own exams.

Microsoft DP-300 and DAMA CDMP Associate Domain Review

Why Domain-Focused Review Matters

Both the Microsoft DP-300 (Administering Relational Databases on Microsoft Azure) and the DAMA CDMP Associate exams test a defined set of knowledge areas that Microsoft and DAMA International publish in official skills outlines. Studying those outlines directly—rather than reviewing topics at random—is the most efficient way to close gaps before exam day. This lesson maps the highest-weight domains for each credential and shows you how to work through them systematically.

---

DP-300 High-Weight Domains

Planning and Implementing Database Deployments on Azure

The DP-300 expects you to choose the right Azure SQL deployment option for a given scenario. The three main options are Azure SQL Database (a fully managed PaaS service), Azure SQL Managed Instance (PaaS with near-complete SQL Server compatibility, including SQL Server Agent and cross-database queries), and SQL Server on Azure Virtual Machine (IaaS, giving you full OS and engine control). Scenario questions often hinge on a specific feature—such as linked servers or CLR integration—that requires Managed Instance or a VM rather than Azure SQL Database.

Configuring and Managing Security

DP-300 security questions cover four mechanisms you must distinguish:

Know what each control protects and at what layer (storage, network, query result, identity).

Monitoring and Optimizing Operational Resources

Query Store captures query plans and runtime statistics over time, allowing you to identify plan regressions and force a known-good plan. Wait statistics categorize where SQL Server spends time waiting (CPU, I/O, locks, network), pointing you toward the right remediation. Index maintenance—reorganize for moderate fragmentation, rebuild for high fragmentation—reduces I/O cost. Intelligent Query Processing (IQP) is a family of features introduced in compatibility level 150 and later that includes adaptive joins, memory grant feedback, and table variable deferred compilation.

Configuring High Availability and Disaster Recovery

---

DAMA CDMP Associate High-Weight Knowledge Areas

The DAMA CDMP Associate exam is based on the DAMA-DMBOK2: Data Management Body of Knowledge, Second Edition. Questions test conceptual understanding of knowledge areas rather than hands-on tool skills.

Data Governance

Data governance establishes accountability for data assets through defined roles (Data Owner, Data Steward, Data Custodian), policies, and decision-making processes. A Data Steward is responsible for day-to-day quality and compliance of a data domain; a Data Owner holds business accountability. Governance programs require executive sponsorship and a data governance council or equivalent body.

Data Quality

DAMA-DMBOK2 defines dimensions of data quality that commonly include completeness, consistency, accuracy, timeliness, validity, and uniqueness. Data profiling analyzes source data to measure these dimensions before loading or integration. Remediation corrects or quarantines records that fail quality rules.

Data Modeling and Design

Three model levels matter for the exam: conceptual (business entities and relationships, no technical detail), logical (normalized attributes and keys, database-platform independent), and physical (actual table and column definitions, indexes, partitioning, optimized for a specific engine). Entity-relationship notation and normalization through third normal form are testable topics.

Reference and Master Data Management

Reference data is a set of permissible values used to classify other data (e.g., country codes, product categories). Master data represents the core business entities shared across systems (customers, products, locations). Master Data Management (MDM) establishes a single authoritative source—a golden record—for each master entity.

Data Warehousing and Business Intelligence

A data warehouse integrates historical data from multiple sources for analytical reporting. Key design patterns include the star schema (fact table surrounded by dimension tables) and the snowflake schema (normalized dimensions). ETL (Extract, Transform, Load) and ELT pipelines move and transform data from operational sources into the warehouse.

Metadata Management

Metadata is data about data. Business metadata describes meaning and context (data definitions, business rules). Technical metadata describes structure (schemas, lineage, data types). Operational metadata tracks process execution (job run times, row counts). A data catalog surfaces metadata to users for discovery and governance.

---

Study Safety and Academic Integrity

When using Azure portal accounts or shared lab environments, protect credentials: never store passwords in plain text, log out after each session, and do not deploy resources that incur costs beyond your free-tier allocation. For exam preparation, use only officially licensed practice materials. Reproducing or distributing live exam questions violates exam provider agreements and can result in permanent credential revocation for all parties involved.

---

Using the Mixed Practice Set Effectively

During the timed 50-question mixed set, treat each incorrect answer as a research task: find the exact source passage (a Microsoft Learn page, a DAMA-DMBOK2 chapter, or an official docs page), then write one sentence in your own words. This retrieval-plus-elaboration technique builds durable recall far more reliably than re-reading alone.

Key terms10

Azure SQL Managed InstanceA fully managed PaaS Azure SQL deployment option that provides near-complete SQL Server engine compatibility, including features such as SQL Server Agent, cross-database queries, and CLR integration, making it suitable for lift-and-shift migrations.
Transparent Data Encryption (TDE)A SQL Server and Azure SQL feature that encrypts database files at rest at the storage layer automatically, without requiring changes to the application.
Dynamic Data Masking (DDM)An Azure SQL and SQL Server security feature that hides sensitive column data in query results for non-privileged users while leaving the underlying stored data unchanged.
Query StoreA SQL Server and Azure SQL feature that captures query execution plans and runtime statistics over time, enabling identification and forced correction of plan regressions.
Auto-Failover GroupAn Azure SQL high-availability feature built on geo-replication that groups one or more databases under a single listener endpoint and supports policy-driven or manual failover to a secondary region.
Data StewardIn DAMA-DMBOK2 terminology, a person accountable for the day-to-day quality, compliance, and appropriate use of data within an assigned data domain.
Golden RecordIn master data management, the single authoritative, de-duplicated representation of a core business entity such as a customer or product, reconciled from all contributing source systems.
MetadataData that describes other data; categorized in DAMA-DMBOK2 as business metadata (meaning and context), technical metadata (structure and lineage), and operational metadata (process execution details).
Star SchemaA dimensional data warehouse design pattern consisting of a central fact table that stores measurable events or transactions, surrounded by denormalized dimension tables that provide descriptive context.
Intelligent Query Processing (IQP)A family of SQL Server and Azure SQL query-processing improvements, available at database compatibility level 150 and later, that includes adaptive joins, memory grant feedback, and table variable deferred compilation to reduce manual tuning needs.
In class: Work through DP-300 domain review using Microsoft Learn modules as the framework: planning and implementing database deployments on Azure (Azure SQL Database, Managed Instance, SQL Server on Azure VM), configuring and managing security (Microsoft Entra authentication, transparent data encryption, dynamic data masking, auditing), monitoring and optimizing operational resources (Query Store, wait statistics, index maintenance, Intelligent Query Processing), and configuring high availability and disaster recovery (geo-replication, failover groups, automated backup and point-in-time restore) — completing 15-to-20 scenario-based practice questions per domain with explanations. · Work through DAMA CDMP Associate review organized around DAMA-DMBOK2 knowledge areas at the level tested on the Associate exam: data governance (roles, policies, stewardship), data quality (dimensions of quality, profiling, remediation), data modeling and design (conceptual, logical, physical), reference and master data management, data warehousing and business intelligence concepts, and metadata management — completing 15-to-20 concept-based questions per knowledge area. · Students individually complete a timed 50-question mixed practice set that samples all four credentials' domains proportionally, then review every incorrect answer by locating the source passage in the official reference (Microsoft Learn page, DAMA-DMBOK2 chapter, PostgreSQL docs page, or Oracle docs page) and writing a one-sentence explanation in their own words.
Materials: Microsoft Learn DP-300 learning path (learn.microsoft.com); Microsoft DP-300 exam skills outline (official, current version); Azure portal student access or Azure free-tier account; DAMA-DMBOK2: Data Management Body of Knowledge, 2nd edition; DAMA CDMP Associate exam content outline (dama.org); instructor-prepared scenario-based question sets; student answer-explanation notebook
Check: Domain knowledge quiz of 50 questions (25 DP-300 scenario-based, 25 DAMA CDMP Associate concept-based) drawn from covered material; students must score at least 75% overall and no lower than 70% on either credential's subset — scores below threshold in any area require completion of a targeted 30-minute instructor-guided remediation drill on the failing domain before moving to the mock exam lesson.

Practice check8

Answer each question, then check it. Nothing is recorded; this is your own practice.

Microsoft DP-300 – Planning and Implementing Database Deployments
1. A company needs to migrate an on-premises SQL Server application that uses SQL Server Agent jobs and cross-database queries to Azure with minimal application changes. Which Azure SQL deployment option best meets these requirements?
Microsoft DP-300 – Configuring and Managing Security
2. A database administrator wants to ensure that data stored in Azure SQL Database files on disk is encrypted without modifying any application connection strings or queries. Which feature should the administrator use?
Microsoft DP-300 – Monitoring and Optimizing Operational Resources
3. A DBA notices that a query that performed well last month now runs significantly slower. After checking Query Store, she sees the query is using a different execution plan. What Query Store action should she take to immediately restore prior performance while investigating the root cause?
Microsoft DP-300 – Configuring High Availability and Disaster Recovery
4. An organization needs its Azure SQL Database to automatically fail over to a secondary region with a consistent DNS endpoint so that applications do not need to update connection strings after a failover. Which feature satisfies this requirement?
DAMA CDMP Associate – Data Governance
5. According to DAMA-DMBOK2, which role holds day-to-day accountability for the quality and appropriate use of data within a specific business data domain?
DAMA CDMP Associate – Data Quality
6. A data quality analyst finds that 12% of customer records have a missing value for the 'email address' field, which is required by business rules. Which dimension of data quality does this finding most directly measure?
DAMA CDMP Associate – Data Modeling and Design
7. A data architect is creating a model that defines business entities such as 'Customer,' 'Order,' and 'Product' along with their relationships, without specifying attributes, keys, or any database platform details. Which level of data model is the architect producing?
DAMA CDMP Associate – Metadata Management
8. An organization's enterprise data catalog records the owner, business definition, and steward for each data element, as well as the table name, data type, and ETL job run times for each field. According to DAMA-DMBOK2, which THREE metadata categories do these entries represent?
Record this lesson on my transcript. Sign in with your key and enrollment email to record lessons (enroll free if you have no key). This page stays open to read and practise.
← Previous lessonProgram planNext lesson →