DP-203 · Question #99
You configure monitoring for a Microsoft Azure SQL Data Warehouse implementation. The implementation uses PolyBase to load data from comma-separated value (CSV) files stored in Azure Data Lake Gen2…
The correct answer is C. Cannot execute the query "Remote Query" against OLE DB provider "SQLNCLI11": for linked. Error message: Cannot execute the query "Remote Query" Possible Reason: The reason this error happens is because each file has different schema. The PolyBase external table DDL when pointed to a directory recursively reads all the files in that directory. When a column or data…
Question
You configure monitoring for a Microsoft Azure SQL Data Warehouse implementation. The implementation uses PolyBase to load data from comma-separated value (CSV) files stored in Azure Data Lake Gen2 using an external table. Files with an invalid schema cause errors to occur. You need to monitor for an invalid schema error. For which error should you monitor?
Options
- AEXTERNAL TABLE access failed due to internal error: 'Java exception raised on call to
- BEXTERNAL TABLE access failed due to internal error: 'Java exception raised on call to
- CCannot execute the query "Remote Query" against OLE DB provider "SQLNCLI11": for linked
- DEXTERNAL TABLE access failed due to internal error: 'Java exception raised on call to
How the community answered
(34 responses)- A3% (1)
- B15% (5)
- C76% (26)
- D6% (2)
Explanation
Error message: Cannot execute the query "Remote Query" Possible Reason: The reason this error happens is because each file has different schema. The PolyBase external table DDL when pointed to a directory recursively reads all the files in that directory. When a column or data type mismatch happens, this error could be seen in SSMS. https://docs.microsoft.com/en-us/sql/relational-databases/polybase/polybase-errors-and-possible-
Topics
Community Discussion
No community discussion yet for this question.