You are working on Azure Data Lake Store Gen1. Suddenly, you realize the need to know the schema of the external data. Which of the following plug-in would you use to know the external data schema?

Question

Options

• AIpv4_lookup
• BMysql_request
• CPivot
• DNarrow
• Einfer_storage_schema

• A
  11% (5)
• C
  4% (2)
• D
  2% (1)
• E
  82% (37)

Explanation

infer_storage_schema is the plug-in that helps infer the schema based on the external file contents; when the external data schema is unknown. Option A is incorrect. The ipv4_lookup plugin checks for an IPv4 value in a lookup table and returns the matched rows. Option B is incorrect. The mysql_request plugin transfers a SQL query to a MySQL Server network endpoint and returns the 1st row set in the result. Option C is incorrect. Pivot plug-in is used to rotate a table by changing the unique values from 1 column in the input table into a number of different columns in the output table and perform aggregations wherever needed on any remaining column values that are desired in the final Option D is incorrect. This plug-in is used to unpivot a wide table into a table with only three Option E is correct. infer_storage_schema plug-in can be used to infer the schema of external data and return it as a CSL schema string. https://docs.microsoft.com/en-us/azure/data-explorer/kusto/management/external-tables- azurestorage-azuredatalake https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/inferstorageschemaplugin

No community discussion yet for this question.