Azure Synapse SQL Pool – Implement Polybase
Evaluate Your Project Knowledge
What is the purpose of creating external data source?
Since using polybase we are reading the contents of the file stored in Azure Data Lake, so by creating a external data source we are specifying the details of the Azure Data Lake account
Creating a external table is mandatory to read the data stored in Azure Data Lake account.
In an external table, we specify the field format of the file
Using polybase, data from the Customer.txt file will be loaded in the external table
Incorrect. The data is not physically loaded into the external table.
Is the following sequence to configure polybase correct or not?
Create master Key;
create database scoped credential
create external data source
create external file format
create external table
InCorrect Answer ! This is the correct sequence of events.
The external table can be used to join(inner/left/right) with other normal tables in a SQL statement.
The external tables behaves similar to a normal table. Except you cannot update or delete records in it. But you can join it with any other normal tables