What is the purpose of creating external data source

Azure Synapse SQL Pool – Implement Polybase

Evaluate Your Project Knowledge

 

Question 1

What is the purpose of creating external data source?

1 / 1 point

 

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

================================================

Question 2

Creating a external table is mandatory to read the data stored in Azure Data Lake account.

1 / 1 point

In an external table, we specify the field format of the file

================================================

Question 3

Using polybase, data from the Customer.txt file will be loaded in the external table

1 / 1 point

Incorrect. The data is not physically loaded into the external table.

================================================

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

1 / 1 point

InCorrect Answer ! This is the correct sequence of events.

================================================

Question 5

The external table can be used to join(inner/left/right) with other normal tables in a SQL statement.

1 / 1 point

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

Other Questions Of This Category