Microsoft DP-700 Practice Test 34
Question 330
A streaming connector reports data-conversion errors for a numeric field. Which fix addresses the root cause?
- Compare incoming and outgoing throughput and processing errors for the affected nodes.
- Correct field typing or transformation to handle invalid text-to-number conversions.
- Renew the relevant source or destination connection authorization and resume the affected node.
- Inspect the filter predicate on the affected stream branch and its output counts.
Explanation
Correct Answer
B:A conversion exception is about value/schema compatibility, not necessarily a missing network connection. Test representative malformed numeric values.
Incorrect Answers
A:Backlog arises when processing or destination capacity lags arrival; node-level rates identify the limiting stage.
C:Authentication failures prevent connector operations; throughput tuning cannot authorize a revoked identity.
D:An overrestrictive filter can silently discard valid events even while upstream throughput remains healthy.
Question 331
An Eventstream destination receives no records after a new filter was deployed. What should be checked?
- Publish the Eventstream's edited definition to activate the new routing.
- Renew the relevant source or destination connection authorization and resume the affected node.
- Inspect the filter predicate on the affected stream branch and its output counts.
- Compare incoming payload encoding and schema against the configured source deserializer.
Explanation
Correct Answer
C:An overrestrictive filter can silently discard valid events even while upstream throughput remains healthy. Send events that should pass and fail the predicate.
Incorrect Answers
A:Unpublished canvas changes do not become the running stream graph.
B:Authentication failures prevent connector operations; throughput tuning cannot authorize a revoked identity.
D:Deserialization errors occur before downstream analytics when message bytes cannot be interpreted as configured.
Question 332
An Eventstream edit changes destination routing but live events continue to the old address. What step is required?
- Correct field typing or transformation to handle invalid text-to-number conversions.
- Compare incoming and outgoing throughput and processing errors for the affected nodes.
- Publish the Eventstream's edited definition to activate the new routing.
- Compare incoming payload encoding and schema against the configured source deserializer.
Explanation
Correct Answer
C:Unpublished canvas changes do not become the running stream graph. Verify the published destination receives a test event.
Incorrect Answers
A:A conversion exception is about value/schema compatibility, not necessarily a missing network connection.
B:Backlog arises when processing or destination capacity lags arrival; node-level rates identify the limiting stage.
D:Deserialization errors occur before downstream analytics when message bytes cannot be interpreted as configured.
Question 333
An Eventstream reports source messages arriving but destination output failures rising. Which view is most useful?
- Adjust eventstream field mapping or Manage Fields operations to the new schema.
- Inspect destination-node Runtime logs and Data insights metrics.
- Publish the Eventstream's edited definition to activate the new routing.
- Correct field typing or transformation to handle invalid text-to-number conversions.
Explanation
Correct Answer
B:Node-specific logs distinguish output connector failure from source delivery, revealing which edge of the graph is broken. Correlate destination error timestamps with source throughput.
Incorrect Answers
A:Transformations referencing old field names can drop or misroute data even if source transport is healthy.
C:Unpublished canvas changes do not become the running stream graph.
D:A conversion exception is about value/schema compatibility, not necessarily a missing network connection.
Question 334
A streaming node repeatedly pauses due to an authentication error after token expiry. What should be repaired?
- Publish the Eventstream's edited definition to activate the new routing.
- Inspect the filter predicate on the affected stream branch and its output counts.
- Inspect destination-node Runtime logs and Data insights metrics.
- Renew the relevant source or destination connection authorization and resume the affected node.
Explanation
Correct Answer
D:Authentication failures prevent connector operations; throughput tuning cannot authorize a revoked identity. Test the credential and watch node status recovery.
Incorrect Answers
A:Unpublished canvas changes do not become the running stream graph.
B:An overrestrictive filter can silently discard valid events even while upstream throughput remains healthy.
C:Node-specific logs distinguish output connector failure from source delivery, revealing which edge of the graph is broken.
Question 335
A destination's records are missing because the source event schema now uses renamed fields. What should be updated?
- Compare incoming and outgoing throughput and processing errors for the affected nodes.
- Adjust eventstream field mapping or Manage Fields operations to the new schema.
- Renew the relevant source or destination connection authorization and resume the affected node.
- Correct field typing or transformation to handle invalid text-to-number conversions.
Explanation
Correct Answer
B:Transformations referencing old field names can drop or misroute data even if source transport is healthy. Compare raw and derived schema for the renamed field.
Incorrect Answers
A:Backlog arises when processing or destination capacity lags arrival; node-level rates identify the limiting stage.
C:Authentication failures prevent connector operations; throughput tuning cannot authorize a revoked identity.
D:A conversion exception is about value/schema compatibility, not necessarily a missing network connection.
Question 336
An Eventstream's backlog keeps increasing during a traffic burst. What should be measured before scaling it?
- Correct field typing or transformation to handle invalid text-to-number conversions.
- Adjust eventstream field mapping or Manage Fields operations to the new schema.
- Inspect the filter predicate on the affected stream branch and its output counts.
- Compare incoming and outgoing throughput and processing errors for the affected nodes.
Explanation
Correct Answer
D:Backlog arises when processing or destination capacity lags arrival; node-level rates identify the limiting stage. Measure sustained rate and error trends over several intervals.
Incorrect Answers
A:A conversion exception is about value/schema compatibility, not necessarily a missing network connection.
B:Transformations referencing old field names can drop or misroute data even if source transport is healthy.
C:An overrestrictive filter can silently discard valid events even while upstream throughput remains healthy.
Question 337
A warehouse query fails with invalid column name after a schema deployment. Which first action is correct?
- Correct the join grain or preaggregate the many side before summing.
- Ensure the staging source has a single intended current record per merge key.
- Populate the required NOT NULL column or apply an approved default in the target design.
- Inspect the warehouse's current schema and fix the outdated column reference.
Explanation
Correct Answer
D:SQL binding uses existing object metadata; a missing column cannot be corrected by increasing warehouse capacity. Validate the query against the deployed schema.
Incorrect Answers
A:Row multiplication is a relational logic error; adding memory does not restore additive correctness.
B:Multiple source matches to one target key make an upsert ambiguous and can fail or produce wrong results.
C:Required-column constraints prevent inserting incomplete records; bypassing validation would hide missing business data.
Question 338
A query fails because a numeric amount is compared to text using an invalid implicit conversion. What should be corrected?
- Ensure the staging source has a single intended current record per merge key.
- Inspect the warehouse's current schema and fix the outdated column reference.
- Review the service principal's effective warehouse and table permissions.
- Use explicit compatible data-type conversion and reject invalid source values.
Explanation
Correct Answer
D:A conversion error is driven by incompatible values or types, not by a missing SQL index alone. Test sample numeric and malformed text values.
Incorrect Answers
A:Multiple source matches to one target key make an upsert ambiguous and can fail or produce wrong results.
B:SQL binding uses existing object metadata; a missing column cannot be corrected by increasing warehouse capacity.
C:Different identities can have different item and SQL grants; successful execution by an owner proves little about the pipeline identity.
Question 339
A T-SQL insert fails because a required target column has no value. Which data or schema issue should be repaired?
- Populate the required NOT NULL column or apply an approved default in the target design.
- Review the service principal's effective warehouse and table permissions.
- Ensure the staging source has a single intended current record per merge key.
- Correct the join grain or preaggregate the many side before summing.
Explanation
Correct Answer
A:Required-column constraints prevent inserting incomplete records; bypassing validation would hide missing business data. Attempt the insert with the corrected column mapping.
Incorrect Answers
B:Different identities can have different item and SQL grants; successful execution by an owner proves little about the pipeline identity.
C:Multiple source matches to one target key make an upsert ambiguous and can fail or produce wrong results.
D:Row multiplication is a relational logic error; adding memory does not restore additive correctness.
Question 340
A warehouse statement reports a duplicate key or matching-row conflict during MERGE. What source-side rule should be inspected?
- Inspect the warehouse's current schema and fix the outdated column reference.
- Ensure the staging source has a single intended current record per merge key.
- Review the service principal's effective warehouse and table permissions.
- Correct the join grain or preaggregate the many side before summing.
Explanation
Correct Answer
B:Multiple source matches to one target key make an upsert ambiguous and can fail or produce wrong results. Count duplicate business keys before rerunning MERGE.
Incorrect Answers
A:SQL binding uses existing object metadata; a missing column cannot be corrected by increasing warehouse capacity.
C:Different identities can have different item and SQL grants; successful execution by an owner proves little about the pipeline identity.
D:Row multiplication is a relational logic error; adding memory does not restore additive correctness.
