Question

When configuring Azure SQL Data Warehouse to access text files in an Azure Storage container, which of the following features is used?

Linked Servers

Azure table storage

OPENQUERY

Ploy base

Answer 1

Answer:

if u want answer then follow me

Answer 2

When configuring Azure SQL Data Warehouse to access text files in an Azure Storage container Poly base feature is used.

• Build a data repository in the Azure gateway and set up a server-level firewall control in the Azure gateway

• Join to the data warehouse with SSMS and Build a user-designated for readying data.

• Perform external tables that use Azure blob as the data source

• Use the CTAS T-SQL record to load data into your data repository and view the course of data as it is piling

• Produce a year of data in the time dimension and sales fact table and generate statistics on the recently stored data.