Question 460 A products endpoint returns hundreds of thousands of rows in one call. The selected Azure SQL environment supports the integration feature and is configured for it. What should the engineer choose? Use a DAB configuration file and environment-specific settings Use DAB filtering and sorting rather than downloading all records Configure DAB pagination for a large result set Configure a Data API builder entity for REST access Explanation Correct Answer C:This implementation avoids unbounded response payloads and improves client navigation. Incorrect Answers A:This choice makes endpoint behavior reproducible across deployments. This does not meet the need for a method that avoids unbounded response payloads and improves client navigation. B:This choice pushes supported query constraints to the service. This does not meet the need for a method that avoids unbounded response payloads and improves client navigation. D:This choice exposes an approved table or view through configured REST routes. This does not meet the need for a method that avoids unbounded response payloads and improves client navigation.
Question 461 A mobile sync service needs identifiers of rows changed since its last token. What is the most appropriate design decision? Use Azure Functions SQL trigger bindings for event-driven processing when supported Use Azure Monitor and Log Analytics for centralized diagnostics Use Change Tracking when only changed keys and versions are needed Use Azure Logic Apps for low-code orchestration of SQL change workflows Explanation Correct Answer C:This implementation fits because it reports which rows changed without full before/after values. That addresses the stated technical constraint. Incorrect Answers A:This alternative runs approved code as SQL changes become visible. This does not meet the need for a method that reports which rows changed without full before/after values. B:That technique aggregates logs and metrics for alerting and investigation. This does not meet the need for a method that reports which rows changed without full before/after values. D:This option coordinates connectors and conditional business steps. This does not meet the need for a method that reports which rows changed without full before/after values.
Question 462 A configured GraphQL entity points to a table renamed last sprint. Which solution best satisfies the stated constraint? Configure GraphQL relationships between authorized entities Set a supported DAB cache policy only for safe repeatable responses Validate DAB metadata/object mappings during startup Use a token-authentication provider with validated identities Explanation Correct Answer C:This approach finds misnamed source objects before clients encounter failures. Incorrect Answers A:That technique exposes supported parent-child navigation in a typed schema. This does not meet the need for a method that finds misnamed source objects before clients encounter failures. B:This choice lowers database load while considering authorization and staleness. This does not meet the need for a method that finds misnamed source objects before clients encounter failures. D:This choice rejects requests without a trusted issuer and audience. This does not meet the need for a method that finds misnamed source objects before clients encounter failures.
Question 463 A cloud function must react to changed SQL rows without polling from a web request. Which approach would you recommend? Use Azure Logic Apps for low-code orchestration of SQL change workflows Use Azure Functions SQL trigger bindings for event-driven processing when supported Use Change Data Capture for historical row-change capture when supported Use Azure Monitor and Log Analytics for centralized diagnostics Explanation Correct Answer B:This approach runs approved code as SQL changes become visible. Incorrect Answers A:This choice coordinates connectors and conditional business steps. This does not meet the need for a method that runs approved code as SQL changes become visible. C:That technique records committed insert, update and delete changes from eligible tables. This does not meet the need for a method that runs approved code as SQL changes become visible. D:That technique aggregates logs and metrics for alerting and investigation. This does not meet the need for a method that runs approved code as SQL changes become visible.
Question 464 A service repeatedly rescans a million rows to find a few modified records. The selected Azure SQL environment supports the integration feature and is configured for it. Which solution best satisfies the stated constraint? Use Change Event Streaming where available for continuous event dissemination Use structured, versioned API contracts for external data consumers Choose event-driven delta processing rather than polling full tables Use managed connectivity and least-privilege service identities for integrations Explanation Correct Answer C:This implementation lowers unnecessary source load and update lag when supported. Incorrect Answers A:That technique publishes SQL change events for downstream consumers. This does not meet the need for a method that lowers unnecessary source load and update lag when supported. B:This alternative prevents breaking changes to the published database API. This does not meet the need for a method that lowers unnecessary source load and update lag when supported. D:This option controls what each Azure integration component can do. This does not meet the need for a method that lowers unnecessary source load and update lag when supported.
Question 465 A client needs orders together with their related order-line records. Which approach would you recommend? Use a token-authentication provider with validated identities Validate DAB metadata/object mappings during startup Configure GraphQL relationships between authorized entities Set a supported DAB cache policy only for safe repeatable responses Explanation Correct Answer C:Configure GraphQL relationships between authorized entities fits because it exposes supported parent-child navigation in a typed schema. That addresses the stated technical constraint. Incorrect Answers A:This choice rejects requests without a trusted issuer and audience. This does not meet the need for a method that exposes supported parent-child navigation in a typed schema. B:This choice finds misnamed source objects before clients encounter failures. This does not meet the need for a method that exposes supported parent-child navigation in a typed schema. D:This option lowers database load while considering authorization and staleness. This does not meet the need for a method that exposes supported parent-child navigation in a typed schema.
Question 466 A DAB endpoint is internet reachable but must accept only organizational access tokens. What is the most appropriate design decision? Disable unwanted DAB operations even when the table exists Use DAB field projection to limit returned information Configure GraphQL relationships between authorized entities Use a token-authentication provider with validated identities Explanation Correct Answer D:This choice rejects requests without a trusted issuer and audience. Incorrect Answers A:This alternative reduces attack surface and unintended writes. This does not meet the need for a method that rejects requests without a trusted issuer and audience. B:That technique exposes only selected response fields to approved clients. This does not meet the need for a method that rejects requests without a trusted issuer and audience. C:This option exposes supported parent-child navigation in a typed schema. This does not meet the need for a method that rejects requests without a trusted issuer and audience.
Question 467 A business process sends review notifications after approved database events. Which implementation is the best fit? Use Azure Logic Apps for low-code orchestration of SQL change workflows Send application and request telemetry to Application Insights where supported Use Change Data Capture for historical row-change capture when supported Use Azure Monitor and Log Analytics for centralized diagnostics Explanation Correct Answer A:This implementation fits because it coordinates connectors and conditional business steps. That addresses the stated technical constraint. Incorrect Answers B:This choice traces failures and latency across API calls. This does not meet the need for a method that coordinates connectors and conditional business steps. C:That technique records committed insert, update and delete changes from eligible tables. This does not meet the need for a method that coordinates connectors and conditional business steps. D:That technique aggregates logs and metrics for alerting and investigation. This does not meet the need for a method that coordinates connectors and conditional business steps.
Question 468 An integration pipeline must process source table row changes in commit order. The selected Azure SQL environment supports the integration feature and is configured for it. Which solution is most directly applicable? Send application and request telemetry to Application Insights where supported Use Azure Monitor and Log Analytics for centralized diagnostics Use Change Data Capture for historical row-change capture when supported Use Change Tracking when only changed keys and versions are needed Explanation Correct Answer C:This implementation records committed insert, update and delete changes from eligible tables. Incorrect Answers A:This choice traces failures and latency across API calls. This does not meet the need for a method that records committed insert, update and delete changes from eligible tables. B:This alternative aggregates logs and metrics for alerting and investigation. This does not meet the need for a method that records committed insert, update and delete changes from eligible tables. D:That technique reports which rows changed without full before/after values. This does not meet the need for a method that records committed insert, update and delete changes from eligible tables.
Question 469 A public role may read a catalog but must never edit it. What is the most appropriate design decision? Configure a Data API builder entity for REST access Configure DAB pagination for a large result set Configure entity-level role permissions for Data API builder Use a DAB configuration file and environment-specific settings Explanation Correct Answer C:Configure entity-level role permissions for Data API builder fits because it restricts read, create, update and delete per caller role. That addresses the stated technical constraint. Incorrect Answers A:This alternative exposes an approved table or view through configured REST routes. This does not meet the need for a method that restricts read, create, update and delete per caller role. B:That technique avoids unbounded response payloads and improves client navigation. This does not meet the need for a method that restricts read, create, update and delete per caller role. D:This choice makes endpoint behavior reproducible across deployments. This does not meet the need for a method that restricts read, create, update and delete per caller role.
Question 470 A Logic App needs read access to one SQL schema but currently uses admin credentials. Which implementation is the best fit? Use structured, versioned API contracts for external data consumers Choose event-driven delta processing rather than polling full tables Use idempotent event consumers with stable event identifiers Use managed connectivity and least-privilege service identities for integrations Explanation Correct Answer D:This choice controls what each Azure integration component can do. Incorrect Answers A:That technique prevents breaking changes to the published database API. This does not meet the need for a method that controls what each Azure integration component can do. B:This option lowers unnecessary source load and update lag when supported. This does not meet the need for a method that controls what each Azure integration component can do. C:This alternative avoids duplicate effects during at-least-once delivery. This does not meet the need for a method that controls what each Azure integration component can do.