Practice Exams:

Microsoft DP-900 Dumps

EXAM: Microsoft Azure Data Fundamentals
Verified By Experts
Premium Bundle
$40.00
$59.97 $99.97

DP-900 Premium Bundle


  • Premium File 332 Questions & Answers
  • Training Course 32 Lectures
  • Study Guide 672 Pages

Microsoft DP-900 Practice Test 40

Question 390

At Harborview Banking external auditors require a restricted account activity projection. The team proposes this approach: Use a view to expose a controlled reusable projection of sensitive transaction records. Which technical principle explains the choice?

  1. A view provides a defined query interface and can omit fields that consumers should not see.
  2. WHERE filters individual rows before projection into the result set.
  3. Third-normal-form design reduces repeated non-key dependencies and the anomalies they cause.
  4. Selecting a service tier should reflect the actual workload bottleneck rather than database size alone.

Answer & Explanations

Correct answer: A

A.

A view provides a defined query interface and can omit fields that consumers should not see. This principle supports the intervention: Use a view to expose a controlled reusable projection of sensitive transaction records. The relevant scenario is: At Harborview Banking external auditors require a restricted account activity projection. Verify the result by: Query a test reporting view and confirm it excludes protected payment-token columns.

B.

WHERE filters individual rows before projection into the result set. That explains a separate situation: At Pineport Commerce support needs orders placed on one business day. The current case is: At Harborview Banking external auditors require a restricted account activity projection. The actual mechanism is: A view provides a defined query interface and can omit fields that consumers should not see.

C.

Third-normal-form design reduces repeated non-key dependencies and the anomalies they cause. That explains a separate situation: At Harborcrest Tax a postal region's standard reference data changes annually. The current case is: At Harborview Banking external auditors require a restricted account activity projection. The actual mechanism is: A view provides a defined query interface and can omit fields that consumers should not see.

D.

Selecting a service tier should reflect the actual workload bottleneck rather than database size alone. That explains a separate situation: At Bayfield Travel application requests slow under concurrent booking loads. The current case is: At Harborview Banking external auditors require a restricted account activity projection. The actual mechanism is: A view provides a defined query interface and can omit fields that consumers should not see.

Question 391

At Harborview Banking external auditors require a restricted account activity projection. After implementing this approach—Use a view to expose a controlled reusable projection of sensitive transaction records—which result would most directly confirm success?

  1. Query a test reporting view and confirm it excludes protected payment-token columns.
  2. Connect from an allowed test application identity and verify a disallowed client cannot open the SQL session.
  3. Change a sample order date once and verify all associated line records reflect the parent change.
  4. Update one fictional delivery status and confirm only the intended primary-key row changes.

Answer & Explanations

Correct answer: A

A.

Query a test reporting view and confirm it excludes protected payment-token columns. This tests the targeted action: Use a view to expose a controlled reusable projection of sensitive transaction records. The reason is: A view provides a defined query interface and can omit fields that consumers should not see. The reported case is: At Harborview Banking external auditors require a restricted account activity projection.

B.

Connect from an allowed test application identity and verify a disallowed client cannot open the SQL session. This tests a separate situation: At Meadowbank Health only an approved application subnet should query a managed SQL database. The observed case is: At Harborview Banking external auditors require a restricted account activity projection. Use this acceptance check instead: Query a test reporting view and confirm it excludes protected payment-token columns.

C.

Change a sample order date once and verify all associated line records reflect the parent change. This tests a separate situation: At Cedarbrook Manufacturing order header details repeat across line items. The observed case is: At Harborview Banking external auditors require a restricted account activity projection. Use this acceptance check instead: Query a test reporting view and confirm it excludes protected payment-token columns.

D.

Update one fictional delivery status and confirm only the intended primary-key row changes. This tests a separate situation: At Harborpoint Deliveries only one tracking record needs a status correction. The observed case is: At Harborview Banking external auditors require a restricted account activity projection. Use this acceptance check instead: Query a test reporting view and confirm it excludes protected payment-token columns.

Question 392

At Harborview Banking external auditors require a restricted account activity projection. Which shortcut most directly threatens the intended data outcome?

  1. Choose Azure SQL Database while demanding custom guest OS drivers inside its managed service.
  2. Use an INNER JOIN when the request explicitly includes customers with zero orders.
  3. Put COUNT(*) in a row-level WHERE clause and expect every database to accept it.
  4. Give every reporting user direct access to all underlying columns for convenience.

Answer & Explanations

Correct answer: D

A.

Choose Azure SQL Database while demanding custom guest OS drivers inside its managed service. This concerns another issue: At Cedarwood Manufacturing a legacy SQL workload needs a specific supported OS-level extension. In the stated case—At Harborview Banking external auditors require a restricted account activity projection—reject: Give every reporting user direct access to all underlying columns for convenience. The safer response is: Use a view to expose a controlled reusable projection of sensitive transaction records.

B.

Use an INNER JOIN when the request explicitly includes customers with zero orders. This concerns another issue: At Westbridge Retail retention analysts need every customer including nonbuyers. In the stated case—At Harborview Banking external auditors require a restricted account activity projection—reject: Give every reporting user direct access to all underlying columns for convenience. The safer response is: Use a view to expose a controlled reusable projection of sensitive transaction records.

C.

Put COUNT(*) in a row-level WHERE clause and expect every database to accept it. This concerns another issue: At Meadowcrest Insurance analysts need branches exceeding an incident threshold. In the stated case—At Harborview Banking external auditors require a restricted account activity projection—reject: Give every reporting user direct access to all underlying columns for convenience. The safer response is: Use a view to expose a controlled reusable projection of sensitive transaction records.

D.

Give every reporting user direct access to all underlying columns for convenience. The scenario is: At Harborview Banking external auditors require a restricted account activity projection. The likely failure is: Confidential fields become unnecessarily exposed. Instead: Use a view to expose a controlled reusable projection of sensitive transaction records.

Question 393

At Meadowline Manufacturing purchase quantities must be positive. Which design or Azure data approach best fits this requirement?

  1. Use SQL Server on Azure Virtual Machines when explicit control of the database engine and operating system is essential.
  2. Apply NOT NULL and CHECK constraints when a field has mandatory business-valid ranges.
  3. Remove partial dependencies from a composite-key order-line table when normalizing to second normal form.
  4. Choose explicit INSERT, UPDATE and DELETE operations for adding, modifying and removing transactional rows.

Answer & Explanations

Correct answer: B

A.

Use SQL Server on Azure Virtual Machines when explicit control of the database engine and operating system is essential. This addresses a different situation: At Cedarwood Manufacturing a legacy SQL workload needs a specific supported OS-level extension. The present case is: At Meadowline Manufacturing purchase quantities must be positive. The relevant action here is: Apply NOT NULL and CHECK constraints when a field has mandatory business-valid ranges.

B.

Apply NOT NULL and CHECK constraints when a field has mandatory business-valid ranges. This works because: Relational constraints reject invalid rows at the database boundary independent of application forms. The scenario is: At Meadowline Manufacturing purchase quantities must be positive. Verify the outcome by: Try a synthetic order with negative quantity and verify an enforced check rejects it.

C.

Remove partial dependencies from a composite-key order-line table when normalizing to second normal form. This addresses a different situation: At Cedarbrook Manufacturing order header details repeat across line items. The present case is: At Meadowline Manufacturing purchase quantities must be positive. The relevant action here is: Apply NOT NULL and CHECK constraints when a field has mandatory business-valid ranges.

D.

Choose explicit INSERT, UPDATE and DELETE operations for adding, modifying and removing transactional rows. This addresses a different situation: At Harborpoint Deliveries only one tracking record needs a status correction. The present case is: At Meadowline Manufacturing purchase quantities must be positive. The relevant action here is: Apply NOT NULL and CHECK constraints when a field has mandatory business-valid ranges.

Question 394

At Meadowline Manufacturing purchase quantities must be positive. The team proposes this approach: Apply NOT NULL and CHECK constraints when a field has mandatory business-valid ranges. Which technical principle explains the choice?

  1. A relational join links rows through corresponding key values and inner joins retain matches only.
  2. The IaaS model leaves OS, SQL Server configuration and much patch responsibility with the customer.
  3. WHERE filters individual rows before projection into the result set.
  4. Relational constraints reject invalid rows at the database boundary independent of application forms.

Answer & Explanations

Correct answer: D

A.

A relational join links rows through corresponding key values and inner joins retain matches only. That explains a separate situation: At Cedarcrest Finance invoices must display the correct customer account. The current case is: At Meadowline Manufacturing purchase quantities must be positive. The actual mechanism is: Relational constraints reject invalid rows at the database boundary independent of application forms.

B.

The IaaS model leaves OS, SQL Server configuration and much patch responsibility with the customer. That explains a separate situation: At Cedarwood Manufacturing a legacy SQL workload needs a specific supported OS-level extension. The current case is: At Meadowline Manufacturing purchase quantities must be positive. The actual mechanism is: Relational constraints reject invalid rows at the database boundary independent of application forms.

C.

WHERE filters individual rows before projection into the result set. That explains a separate situation: At Pineport Commerce support needs orders placed on one business day. The current case is: At Meadowline Manufacturing purchase quantities must be positive. The actual mechanism is: Relational constraints reject invalid rows at the database boundary independent of application forms.

D.

Relational constraints reject invalid rows at the database boundary independent of application forms. This principle supports the intervention: Apply NOT NULL and CHECK constraints when a field has mandatory business-valid ranges. The relevant scenario is: At Meadowline Manufacturing purchase quantities must be positive. Verify the result by: Try a synthetic order with negative quantity and verify an enforced check rejects it.

Question 395

At Meadowline Manufacturing purchase quantities must be positive. After implementing this approach—Apply NOT NULL and CHECK constraints when a field has mandatory business-valid ranges—which result would most directly confirm success?

  1. Try a synthetic order with negative quantity and verify an enforced check rejects it.
  2. Update one fictional delivery status and confirm only the intended primary-key row changes.
  3. Run a synthetic date-range query and confirm no out-of-range orders appear.
  4. Connect from an allowed test application identity and verify a disallowed client cannot open the SQL session.

Answer & Explanations

Correct answer: A

A.

Try a synthetic order with negative quantity and verify an enforced check rejects it. This tests the targeted action: Apply NOT NULL and CHECK constraints when a field has mandatory business-valid ranges. The reason is: Relational constraints reject invalid rows at the database boundary independent of application forms. The reported case is: At Meadowline Manufacturing purchase quantities must be positive.

B.

Update one fictional delivery status and confirm only the intended primary-key row changes. This tests a separate situation: At Harborpoint Deliveries only one tracking record needs a status correction. The observed case is: At Meadowline Manufacturing purchase quantities must be positive. Use this acceptance check instead: Try a synthetic order with negative quantity and verify an enforced check rejects it.

C.

Run a synthetic date-range query and confirm no out-of-range orders appear. This tests a separate situation: At Pineport Commerce support needs orders placed on one business day. The observed case is: At Meadowline Manufacturing purchase quantities must be positive. Use this acceptance check instead: Try a synthetic order with negative quantity and verify an enforced check rejects it.

D.

Connect from an allowed test application identity and verify a disallowed client cannot open the SQL session. This tests a separate situation: At Meadowbank Health only an approved application subnet should query a managed SQL database. The observed case is: At Meadowline Manufacturing purchase quantities must be positive. Use this acceptance check instead: Try a synthetic order with negative quantity and verify an enforced check rejects it.

Question 396

At Meadowline Manufacturing purchase quantities must be positive. Which shortcut most directly threatens the intended data outcome?

  1. Write email = NULL and assume the comparison identifies missing email values.
  2. Choose Azure SQL Database while demanding custom guest OS drivers inside its managed service.
  3. Depend only on one web form to prevent invalid quantities from every API.
  4. Put all contact numbers in one semicolon-delimited customer column.

Answer & Explanations

Correct answer: C

A.

Write email = NULL and assume the comparison identifies missing email values. This concerns another issue: At Willowport Health incomplete patient contact records need review. In the stated case—At Meadowline Manufacturing purchase quantities must be positive—reject: Depend only on one web form to prevent invalid quantities from every API. The safer response is: Apply NOT NULL and CHECK constraints when a field has mandatory business-valid ranges.

B.

Choose Azure SQL Database while demanding custom guest OS drivers inside its managed service. This concerns another issue: At Cedarwood Manufacturing a legacy SQL workload needs a specific supported OS-level extension. In the stated case—At Meadowline Manufacturing purchase quantities must be positive—reject: Depend only on one web form to prevent invalid quantities from every API. The safer response is: Apply NOT NULL and CHECK constraints when a field has mandatory business-valid ranges.

C.

Depend only on one web form to prevent invalid quantities from every API. The scenario is: At Meadowline Manufacturing purchase quantities must be positive. This undermines the mechanism: Relational constraints reject invalid rows at the database boundary independent of application forms. Instead: Apply NOT NULL and CHECK constraints when a field has mandatory business-valid ranges.

D.

Put all contact numbers in one semicolon-delimited customer column. This concerns another issue: At Meadowport Services customers often provide multiple contact phones. In the stated case—At Meadowline Manufacturing purchase quantities must be positive—reject: Depend only on one web form to prevent invalid quantities from every API. The safer response is: Apply NOT NULL and CHECK constraints when a field has mandatory business-valid ranges.

Question 397

At Pinebrook Hospitals clinical inventory counts cannot be negative at receipt. Which design or Azure data approach best fits this requirement?

  1. Distinguish automatic service availability from application transaction retry and failover handling.
  2. Use a SELECT query with a WHERE predicate to retrieve only qualifying orders.
  3. Use a foreign key between order lines and their parent orders to enforce a valid relationship.
  4. Apply NOT NULL and CHECK constraints when a field has mandatory business-valid ranges.

Answer & Explanations

Correct answer: D

A.

Distinguish automatic service availability from application transaction retry and failover handling. This addresses a different situation: At Pinecrest Payments database failover should not charge a card twice. The present case is: At Pinebrook Hospitals clinical inventory counts cannot be negative at receipt. The relevant action here is: Apply NOT NULL and CHECK constraints when a field has mandatory business-valid ranges.

B.

Use a SELECT query with a WHERE predicate to retrieve only qualifying orders. This addresses a different situation: At Pineport Commerce support needs orders placed on one business day. The present case is: At Pinebrook Hospitals clinical inventory counts cannot be negative at receipt. The relevant action here is: Apply NOT NULL and CHECK constraints when a field has mandatory business-valid ranges.

C.

Use a foreign key between order lines and their parent orders to enforce a valid relationship. This addresses a different situation: At Silvercrest Commerce all invoice lines must belong to an existing order. The present case is: At Pinebrook Hospitals clinical inventory counts cannot be negative at receipt. The relevant action here is: Apply NOT NULL and CHECK constraints when a field has mandatory business-valid ranges.

D.

Apply NOT NULL and CHECK constraints when a field has mandatory business-valid ranges. This works because: Relational constraints reject invalid rows at the database boundary independent of application forms. The scenario is: At Pinebrook Hospitals clinical inventory counts cannot be negative at receipt. Verify the outcome by: Try a synthetic order with negative quantity and verify an enforced check rejects it.

Question 398

At Pinebrook Hospitals clinical inventory counts cannot be negative at receipt. The team proposes this approach: Apply NOT NULL and CHECK constraints when a field has mandatory business-valid ranges. Which technical principle explains the choice?

  1. A view provides a defined query interface and can omit fields that consumers should not see.
  2. Serverless can scale compute according to activity and support auto-pause where configured and supported.
  3. Relational constraints reject invalid rows at the database boundary independent of application forms.
  4. SQL result ordering is not guaranteed without an explicit sort clause.

Answer & Explanations

Correct answer: C

A.

A view provides a defined query interface and can omit fields that consumers should not see. That explains a separate situation: At Cedarcrest Travel analysts need booking summaries without card tokens. The current case is: At Pinebrook Hospitals clinical inventory counts cannot be negative at receipt. The actual mechanism is: Relational constraints reject invalid rows at the database boundary independent of application forms.

B.

Serverless can scale compute according to activity and support auto-pause where configured and supported. That explains a separate situation: At Pineport Research an internal reporting database is idle most evenings. The current case is: At Pinebrook Hospitals clinical inventory counts cannot be negative at receipt. The actual mechanism is: Relational constraints reject invalid rows at the database boundary independent of application forms.

C.

Relational constraints reject invalid rows at the database boundary independent of application forms. This principle supports the intervention: Apply NOT NULL and CHECK constraints when a field has mandatory business-valid ranges. The relevant scenario is: At Pinebrook Hospitals clinical inventory counts cannot be negative at receipt. Verify the result by: Try a synthetic order with negative quantity and verify an enforced check rejects it.

D.

SQL result ordering is not guaranteed without an explicit sort clause. That explains a separate situation: At Cedarbank Logistics dispatch lists must show oldest outstanding shipments first. The current case is: At Pinebrook Hospitals clinical inventory counts cannot be negative at receipt. The actual mechanism is: Relational constraints reject invalid rows at the database boundary independent of application forms.

Question 399

At Pinebrook Hospitals clinical inventory counts cannot be negative at receipt. After implementing this approach—Apply NOT NULL and CHECK constraints when a field has mandatory business-valid ranges—which result would most directly confirm success?

  1. Compare a large synthetic database growth and read workload against eligible Hyperscale limits.
  2. Try a synthetic order with negative quantity and verify an enforced check rejects it.
  3. Query a sample customer without an email address using IS NULL and verify it appears.
  4. Query synthetic customers and orders and verify an unmatched order is not returned by the inner join.

Answer & Explanations

Correct answer: B

A.

Compare a large synthetic database growth and read workload against eligible Hyperscale limits. This tests a separate situation: At Harborcrest Finance a long-lived transaction archive has rapid table growth. The observed case is: At Pinebrook Hospitals clinical inventory counts cannot be negative at receipt. Use this acceptance check instead: Try a synthetic order with negative quantity and verify an enforced check rejects it.

B.

Try a synthetic order with negative quantity and verify an enforced check rejects it. This tests the targeted action: Apply NOT NULL and CHECK constraints when a field has mandatory business-valid ranges. The reason is: Relational constraints reject invalid rows at the database boundary independent of application forms. The reported case is: At Pinebrook Hospitals clinical inventory counts cannot be negative at receipt.

C.

Query a sample customer without an email address using IS NULL and verify it appears. This tests a separate situation: At Willowport Health incomplete patient contact records need review. The observed case is: At Pinebrook Hospitals clinical inventory counts cannot be negative at receipt. Use this acceptance check instead: Try a synthetic order with negative quantity and verify an enforced check rejects it.

D.

Query synthetic customers and orders and verify an unmatched order is not returned by the inner join. This tests a separate situation: At Cedarcrest Finance invoices must display the correct customer account. The observed case is: At Pinebrook Hospitals clinical inventory counts cannot be negative at receipt. Use this acceptance check instead: Try a synthetic order with negative quantity and verify an enforced check rejects it.

Question 400

At Pinebrook Hospitals clinical inventory counts cannot be negative at receipt. Which shortcut most directly threatens the intended data outcome?

  1. Assume newly inserted records will always appear at the bottom of an un-ordered query.
  2. Select SQL Server only because both systems support SQL-like queries and assume drivers are interchangeable.
  3. Depend only on one web form to prevent invalid quantities from every API.
  4. Concatenate untrusted search input directly into a SELECT string.

Answer & Explanations

Correct answer: C

A.

Assume newly inserted records will always appear at the bottom of an un-ordered query. This concerns another issue: At Cedarbank Logistics dispatch lists must show oldest outstanding shipments first. In the stated case—At Pinebrook Hospitals clinical inventory counts cannot be negative at receipt—reject: Depend only on one web form to prevent invalid quantities from every API. The safer response is: Apply NOT NULL and CHECK constraints when a field has mandatory business-valid ranges.

B.

Select SQL Server only because both systems support SQL-like queries and assume drivers are interchangeable. This concerns another issue: At Meadowline Commerce a storefront relies on an existing MySQL schema. In the stated case—At Pinebrook Hospitals clinical inventory counts cannot be negative at receipt—reject: Depend only on one web form to prevent invalid quantities from every API. The safer response is: Apply NOT NULL and CHECK constraints when a field has mandatory business-valid ranges.

C.

Depend only on one web form to prevent invalid quantities from every API. The scenario is: At Pinebrook Hospitals clinical inventory counts cannot be negative at receipt. This undermines the mechanism: Relational constraints reject invalid rows at the database boundary independent of application forms. Instead: Apply NOT NULL and CHECK constraints when a field has mandatory business-valid ranges.

D.

Concatenate untrusted search input directly into a SELECT string. This concerns another issue: At Silverport Retail a support page searches names containing apostrophes. In the stated case—At Pinebrook Hospitals clinical inventory counts cannot be negative at receipt—reject: Depend only on one web form to prevent invalid quantities from every API. The safer response is: Apply NOT NULL and CHECK constraints when a field has mandatory business-valid ranges.

Microsoft Azure Data Fundamentals (DP-900) Practice Tests