CDMP

اختبار أساسيات إدارة البيانات CDMP (DAMA): اختبار تجريبي مجاني

ابدأ بـ10 أسئلة مجانية لتعرف ما يحتاج إلى تدريب. بعد الانتهاء، راجع درجتك والوحدات الأضعف وشرح كل خيار.

العودة إلى صفحة اختبار أساسيات إدارة البيانات CDMP (DAMA)

أسئلة الاختبار التجريبي مع الإجابات والشرح

حلّ الأسئلة في الاختبار أعلاه أولًا، ثم افتح كل سؤال هنا لترى الإجابة الصحيحة وسبب خطأ كل خيار.

01An agency holds sensitive health records that law bars it from releasing, yet its policy says its data should be FAIR. Which action best honours the policy within this limit?

سؤال تدريبي الوحدة: حوكمة البيانات

  1. أPublish rich metadata and clear rules for requesting access, while the records stay restricted ✓ الإجابة الصحيحة

    The principles separate data from metadata, so detailed metadata and clear access rules give a high degree of FAIRness even when the data itself stays restricted.

  2. بPublish only a short title for each record set, since detailed descriptions could expose sensitive content

    A bare title is not rich metadata; discovery and reuse need detailed descriptions, which can be written without revealing record content.

  3. جSet the policy aside for these records, because data that cannot be public cannot be made findable

    Because the principles are modular and treat metadata separately, restricted data can still be made findable and its access route made clear.

  4. دRelease a fully open copy of the records under a permissive licence so that others can find and reuse them

    An open public copy would breach the legal bar on release, and the principles do not require sensitive data to be published openly.

المرجع: The FAIR Guiding Principles for scientific data management and stewardship (Scientific Data, 2016), §The FAIR Guiding Principles in detail

02In a Lambda architecture, a dashboard shows the last hour of sensor totals from the speed layer. The next morning the batch layer finishes processing that same hour, and its total differs by 2% from what the dashboard showed. Which total should analysts treat as the better figure for that hour, and why?

سؤال تدريبي الوحدة: معمارية البيانات

  1. أThe speed total, because it was calculated closest to the time the events occurred and so reflects them more faithfully

    The speed layer favours low latency over accuracy; being computed sooner does not make it more faithful, and its figures are later replaced by batch results.

  2. بThe average of the two totals, because each layer is expected to hold part of the true value and errors then offset

    The layers are not complementary halves of a value; the batch result is a full, more accurate computation, so blending it with the hot-path estimate adds error.

  3. جNeither total, because a mismatch shows the raw events were overwritten and both views need rebuilding

    A small difference is expected between the paths, and the raw data at the batch layer is immutable and append-only, so nothing is overwritten.

  4. دThe batch total, because the cold path computes accurately across the full data and supersedes the hot path result ✓ الإجابة الصحيحة

    The speed layer trades accuracy for low latency, and its results are later updated with the more accurate cold path output, so the batch total is the better figure.

المرجع: Big data architectures (Azure Architecture Center, Microsoft Learn), §Lambda architecture

03In a class model, Vehicle has a property trailers with multiplicity 0..*. Bicycle is a subclass of Vehicle and must never have any trailers, while Vehicle and its other subclasses stay unchanged. Which modeling step fits the UML rules?

سؤال تدريبي الوحدة: نمذجة البيانات وتصميمها

  1. أMark trailers in Bicycle as derived so its values are computed

    Derived means a value may be computed from other information, so a derived property can still produce values rather than none.

  2. بRedefine trailers in Bicycle with a multiplicity of 0..0 ✓ الإجابة الصحيحة

    A zero-to-zero multiplicity is the UML way to constrain a more general classifier's property so that the specializing class holds no values.

  3. جSet trailers in Bicycle to 0..1 to limit it to a single value

    An upper bound of 1 still allows one trailer, so a Bicycle could hold a value, violating the rule that it never has any.

  4. دMark trailers in Bicycle as read-only after initialisation

    Read-only blocks updates only after an initial value is assigned; it does not forbid the property from holding values.

المرجع: OMG Unified Modeling Language (UML) Version 2.5.1, §7.5.3 MultiplicityElement semantics, PDF p.76; read-only and derived semantics, PDF p.150 and p.154

04Two concurrent Repeatable Read transactions each sum a different group of rows and insert the total into the other group, then both commit. The combined result matches no one-at-a-time execution order. Which fix addresses this in PostgreSQL?

سؤال تدريبي الوحدة: تخزين البيانات وعملياتها

  1. أRun both at Read Committed so each statement sees the latest commits

    Read Committed gives weaker guarantees, so statements can interleave even more freely; it cannot make the outcome match any serial order.

  2. بKeep Repeatable Read and rely on its guarantee of a stable view

    A stable snapshot blocks dirty, nonrepeatable and phantom reads here, yet it does not detect dependency cycles between what concurrent transactions read and write.

  3. جKeep Repeatable Read and retry any transaction that raises a concurrent-update error

    The transactions modify different rows, so no concurrent-update error is raised; the retry logic never triggers and both commits succeed.

  4. دRun both at Serializable and retry whichever transaction is rolled back ✓ الإجابة الصحيحة

    Serializable tracks read/write dependencies and aborts one of the pair; the retried transaction then produces a result consistent with some serial order.

المرجع: PostgreSQL 18 Documentation, 13.2 Transaction Isolation (PostgreSQL Global Development Group, 2026), §13.2.2 Repeatable Read Isolation Level and §13.2.3 Serializable Isolation Level

05A public agency keeps two lists with the same fields (name, address, phone) and the same number of people, on the same server with the same staff access, and no law or contract sets special duties for either. One list is newsletter subscribers; the other is applicants for a disability benefit. Which factor most justifies a higher PII confidentiality impact level for the second list?

سؤال تدريبي الوحدة: أمن البيانات

  1. أThe legal obligation to protect the confidentiality of the data

    The scenario states that no law or contract adds special duties, so this factor does not separate the two lists.

  2. بThe number of individuals who can be identified from the list

    Both lists identify the same number of people, so quantity cannot explain a difference in rating.

  3. جThe purpose for which the personal data is collected and used ✓ الإجابة الصحيحة

    The same fields can warrant different levels depending on why they are held; disclosure for a benefit application can harm people more than disclosure of a newsletter list.

  4. دThe sensitivity of the individual data fields it holds

    The fields are identical in both lists, so field sensitivity gives the same result for each.

المرجع: NIST SP 800-122, Guide to Protecting the Confidentiality of Personally Identifiable Information (PII) (NIST, April 2010), §3.2.4 Context of Use, PDF p.20

06A nightly pipeline overlaps extraction, transformation and loading, with several parallel workers loading the same target table. Workers now block each other on writes, and rerunning a failed worker creates duplicate rows. Which redesign keeps the overlap while fixing both problems?

سؤال تدريبي الوحدة: تكامل البيانات وقابلية التشغيل البيني

  1. أMake loading single-threaded while extraction and transformation continue to run in parallel

    One loader removes contention but gives up parallel loading, and a rerun of a failed load can still insert the same rows twice.

  2. بSplit the work along partition boundaries such as date or tenant so each worker owns a slice ✓ الإجابة الصحيحة

    Disjoint partitions remove write contention, and a failed slice can be rerun against only its own data, so retries are safe.

  3. جAdd more parallel workers so that a failed slice is quickly picked up by several others

    More workers on the same table increase contention, and several workers redoing one slice multiplies the duplicate rows.

  4. دAdd a deduplication step at the end of the run so reruns cannot leave duplicates in reports

    Cleaning duplicates afterwards hides one symptom but leaves the workers contending for the same table, so write blocking continues.

المرجع: Extract, transform, load (ETL) (Microsoft Learn, Azure Architecture Center), section 'Extract, transform, load (ETL) process'

07A manufacturer's ERP and product lifecycle system hold the same finished goods under different IDs and descriptions, which has led to excess inventory. The two systems also code the colour red as "R" and "Red". Which pairing of remedies fits these two problems?

سؤال تدريبي الوحدة: إدارة البيانات الرئيسية والمرجعية

  1. أAdd a surrogate key to every product record, and leave the colour values as they are in each system

    A surrogate key identifies a row but does not tell that two rows describe the same product, and unreconciled colour values still block combined reporting.

  2. بRetire the colour codes, and merge product records only when their descriptions are identical

    Descriptions differ between the systems, so an identical-description rule would find few duplicates, and dropping the colour codes loses the categorisation.

  3. جMatch and merge the duplicate product records into one master, and map the colour values with a crosswalk ✓ الإجابة الصحيحة

    Duplicate products are one entity held twice, so they need a merged master; differing colour codes are one list coded two ways, which a crosswalk reconciles.

  4. دMap the product IDs with a crosswalk and keep both records, and match and merge the colour values into one

    A crosswalk alone leaves both duplicate product records alive, so excess inventory persists, and colour values are mapped between code sets rather than merged as records.

المرجع: Microsoft Purview and partner MDM tool Master Data Management (MDM) (Microsoft Learn), MDM use cases (Product data; Reference data)

08An analyst needs sales totals by year, by year and month, by year, month and day, and a grand total, and nothing else. Which grouping operator suits this best?

سؤال تدريبي الوحدة: مستودعات البيانات وذكاء الأعمال

  1. أGROUP BY alone, because it already returns every level of subtotal and the grand total

    Plain GROUP BY gives only the finest level; subtotals need ROLLUP or CUBE, or separate unioned queries.

  2. بROLLUP, because it returns only the hierarchical super-aggregates of the listed columns ✓ الإجابة الصحيحة

    ROLLUP yields just the progressively coarser totals plus the grand total, which matches the linear year-month-day request exactly.

  3. جCUBE, because date columns that are derived from one another make a rollup meaningless

    The reasoning is reversed: because the columns depend on one another, a full cube would be meaningless and ROLLUP is the better fit.

  4. دCUBE, because it adds the hierarchical subtotals together with every other combination

    CUBE does include those subtotals but also produces meaningless combinations, so it returns more than the request asks for.

المرجع: Data Cube: A Relational Aggregation Operator (Gray et al., Microsoft Research, 1997), §3 CUBE and ROLLUP Operators, PDF p.9

09A distribution has no access URL written on it, but it is linked to a data service whose endpoint URL is https://api.example.org/stops. A consumer applies the DCAT axioms to this description. What does it conclude?

سؤال تدريبي الوحدة: إدارة البيانات الوصفية

  1. أThe endpoint address is also inferred as the distribution's access URL ✓ الإجابة الصحيحة

    DCAT axiomatizes access URL as the chain from access service to endpoint URL, so the endpoint address is inferred as the access URL.

  2. بThe endpoint address is the landing page of the distribution's dataset

    A landing page is a property of the dataset, and nothing in the chain from service to endpoint assigns it to the dataset.

  3. جNothing, since an access URL must always be written on the distribution

    The axiom is stated precisely so that the access URL need not be repeated by hand when a service link and its endpoint are given.

  4. دThe endpoint address is the download URL, a direct link to the file

    Download URL is reserved for direct links to a downloadable file, whereas an API endpoint is a service address that gives access through queries.

المرجع: Data Catalog Vocabulary (DCAT) - Version 3 (W3C Recommendation, 22 August 2024), §6.8.9 Property: access URL; §6.8.10 Property: access service

10A UK school accepts applications by date of birth. A US parent enters 09/08/2016 meaning 8 September, but the system reads it as 9 August, and a child below the age limit is admitted. What best describes the data?

سؤال تدريبي الوحدة: جودة البيانات

  1. أAccuracy fails: the date is well formed yet records a birth date that is not the real one ✓ الإجابة الصحيحة

    The value looks like a normal date, so it passes format checks, yet it misrepresents the true birth date and fails accuracy.

  2. بValidity fails: the date breaks the expected format and should have been rejected on entry

    Wrong meaning behind a well-formed value is exactly what format and range checks cannot catch.

  3. جConsistency fails: the school register and the application hold two different date formats

    Only one source holds the date here, so there is no second format to contradict the stored value.

  4. دTimeliness fails: the application reached the school after the intake deadline had passed

    No timing problem is described; the harm comes from a misread date, not from a late entry.

المرجع: The Government Data Quality Framework (UK Government Data Quality Hub, gov.uk web page), §Data quality dimensions – how to measure your data quality / Accuracy

CDMP

التحضير الكامل للاختبار

كل هذا في شراء واحد.

  • اختبار تجريبي كامل مثل الحقيقي100 سؤال في 90 دقيقة. تخرج بدرجتك الكلية ودرجة كل وحدة.
  • تدريب على كل وحدة632 سؤال، لكل خيار شرحه ومصدره. تبدأ بأضعف وحداتك.
  • الملخص الشامل 1448 (PDF)مرتب حسب وزن كل وحدة في الاختبار. مع الوصول الدائم فقط.

اختر مدة الوصول

خطوة واحدة قبل الدفع

سجّل الدخول بحساب Google ثم تنتقل مباشرة إلى صفحة الدفع.

اعرف درجتك مجانًاالتحضير الكامل