Which services should you include in the design?

You need to design the solution for the government planning department.

Which services should you include in the design?
A . Azure Synapse Analytics and Elastic Queries
B . Azure SQL Database and Polybase
C . Azure Synapse Analytics and Polybase
D . Azure SQL Database and Elastic Queries

View Answer

Answer: C

Explanation:

PolyBase is a new feature in SQL Server 2016. It is used to query relational and non-relational databases (NoSQL) such as CSV files.

Scenario: Traffic data must be made available to the Government Planning Department for the purpose of modeling changes to the highway system. The traffic data will be used in conjunction with other data such as information about events such as sporting events, weather conditions, and population statistics. External data used during the modeling is stored in on-premises SQL Server 2016 databases and CSV files stored in an Azure Data Lake Storage Gen2 storage account.

Reference: https://www.sqlshack.com/sql-server-2016-polybase-tutorial/