Azure Synapse SQL Pool – Implement Polybase
Evaluate Your Project Knowledge
1.
Question 1
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
================================================
2.
Question 2
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
================================================
3.
Question 3
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.
================================================
4.
Question 4
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.
================================================
5.
Question 5
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