Question 290
A database architect reviews two implementation risks. A team shares raw production error logs containing customer emails with a public model to get a quick explanation of a deadlock. An AI assistant claims a SQL function exists in every SQL Server version despite documentation showing platform-specific availability. Which course of action addresses the stated issues?
Explanation
Correct Answer
First, useful diagnostics do not justify exporting protected customer data into an unauthorized tool. Second, generated statements should not be assumed portable across database versions and services.
Incorrect Answers
Check the target platform and version documentation and run compatibility tests before accepting generated syntax; do not use approved telemetry handling and redact sensitive identifiers before supplying diagnostic context to an eligible assistant: use approved telemetry handling and redact sensitive identifiers before supplying diagnostic context to an eligible assistant.
Use approved telemetry handling and redact sensitive identifiers before supplying diagnostic context to an eligible assistant; define the trust model and tenant context explicitly, then test every allowed and denied access case before deployment: generated statements should not be assumed portable across database versions and services.
Document migration impact and rollback strategy and require standard review and integration tests before merge; check the target platform and version documentation and run compatibility tests before accepting generated syntax: useful diagnostics do not justify exporting protected customer data into an unauthorized tool.



Developing AI-Enabled Database Solutions (DP-800) Practice Tests