Prepstellar
Get the app

DP-900 · Practice set 3 of 4

Transactional Workloads: 10 practice questions

10 questions · Untimed · Free

10 free DP-900 practice questions on Transactional Workloads, with an explanation for every answer. Untimed. The full mock exam and the timed version are in the app.

Set 3 · Transactional Workloads · 10 questions Read the lesson

  1. Question 1 of 10

    What name is commonly given to the work performed by transactional systems?

    1. AOnline Transactional Processing
    2. BOnline Analytical Processing
    3. CExtract, Transform, and Load
    4. DExtract, Load, and Transform
    Show the answer

    OLTP identifies the workload that records discrete business events with quickly accessible data, unlike analytical processing or data-loading sequences.

    Next → 1 / 10

  2. Question 2 of 10

    Which description best defines a transaction in a transactional system?

    1. AA small, discrete business unit of work
    2. BA vast collection of historical business metrics
    3. CA read-mostly reporting data store
    4. DA preaggregated hierarchy of dimensions
    Show the answer

    A transaction encapsulates a specific event that the organization tracks, such as a bank transfer or retail payment.

    Next → 2 / 10

  3. Question 3 of 10

    Which expansion correctly identifies the CRUD operations described for an OLTP workload?

    1. ACollect, classify, protect, and govern
    2. BCreate, retrieve, update, and delete database records
    3. CExtract, transform, load, aggregate, and publish analytical data
    4. DIngest, cleanse, conform, and summarize
    Show the answer

    OLTP database storage supports the CRUD pattern because transactional applications need both read and write operations on current records.

    Next → 3 / 10

  4. Question 4 of 10

    Which ACID property treats a transaction as a unit that succeeds completely or fails completely?

    1. AThe durability property
    2. BThe atomicity property
    3. CThe consistency property
    4. DThe isolation property
    Show the answer

    Atomicity governs completeness of the unit of work; the other properties govern valid states, concurrent interference, and persistence after commit.

    Next → 4 / 10

  5. Question 5 of 10

    Which ACID property restricts transactions to moving a database from one valid state to another?

    1. AConsistency
    2. BDurability
    3. CIsolation
    4. DAtomicity
    Show the answer

    Consistency is the valid-state rule; it is distinct from complete execution, separation of concurrent work, and persistence of committed work.

    Next → 5 / 10

  6. Keep the ones you got wrong

    In the app, every question you miss comes back exactly when you’re about to forget it.

    Get the app

  7. Question 6 of 10

    Which ACID property prevents concurrent transactions from interfering with one another?

    1. AThe isolation property
    2. BConsistency
    3. CDurability
    4. DAtomicity
    Show the answer

    Isolation keeps concurrent work from producing a mixed view of database state; the neighboring properties address completion, validity, and persistence.

    Next → 6 / 10

  8. Question 7 of 10

    Which ACID property ensures that a committed transaction remains committed?

    1. AAtomicity
    2. BConsistency
    3. CIsolation
    4. DDurability
    Show the answer

    Durability is evaluated after commit and protects persistence, unlike the properties concerning completeness, valid states, or concurrent interference.

    Next → 7 / 10

  9. Question 8 of 10

    A bank transfer debits Account A, but the credit to Account B cannot complete. What should an ACID transaction do?

    1. AKeep the debit and retry the credit after commit.
    2. BComplete the debit and mark the resulting state valid.
    3. CPersist the debit and expose both account balances.
    4. DFail the debit so neither account change completes.
    Show the answer

    Atomicity makes the debit and credit one all-or-nothing unit, so failure of one action requires failure of the other.

    Next → 8 / 10

  10. Question 9 of 10

    While a bank transfer is in progress, a balance check sees Account A before the transfer and Account B after it. Which ACID property should prevent this result?

    1. AIsolation
    2. BConsistency
    3. CDurability
    4. DAtomicity
    Show the answer

    The fault is a concurrent reader observing a mixed state, so the decision turns on separation between simultaneous transactions.

    Next → 9 / 10

  11. Question 10 of 10

    A retail payment is committed, and then the database system is switched off. Which outcome demonstrates durability when the system restarts?

    1. AThe payment is reversed because no reader was active.
    2. BThe committed payment remains reflected in the stored data.
    3. CThe payment remains pending until another transaction starts.
    4. DThe payment is split into separate read and write operations.
    Show the answer

    The decisive moment is after commit: durability requires the revised data to persist through the system being switched off and on.

    Next → 10 / 10

  12. You’ve finished this set

    That’s 10 questions on Transactional Workloads. In the app the ones you miss come back exactly when you’re about to forget them.

    Back to the course Next lesson: Analytical WorkloadsGet the app
Keep your progress · Get the app

The whole course, on your phone

Lessons you can read, audio you can listen to on the way to work, and practice that remembers what you got wrong.

Get the app