You deploy Microsoft Data Management Gateway. You plan to use the Import Data module in Azure Machine Learning Studio to import data from an on- premises Microsoft SQL Server instance. Which…

The correct answer is C. Run a Transact-SQL query and use SQL views to filter the data as the data is being read. After the gateway connection is established, you can then specify additional properties, such as the server and database names, authentication method, and a database query. You can create a view or define a query that generates only the rows you need…

Prepare data for modeling

Question

You deploy Microsoft Data Management Gateway. You plan to use the Import Data module in Azure Machine Learning Studio to import data from an on- premises Microsoft SQL Server instance. Which operation can you perform?

Options

AWrite the data back to the on-premises SQL Server instance.
BFilter the data as the data is being read by using the Import Data module.
CRun a Transact-SQL query and use SQL views to filter the data as the data is being read.
DAccess the on-premises SQL Server instance without using credentials, and then import the data.

How the community answered

(32 responses)

A
3% (1)
B
16% (5)
C
75% (24)
D
6% (2)

Explanation

After the gateway connection is established, you can then specify additional properties, such as the server and database names, authentication method, and a database query. You can create a view or define a query that generates only the rows you need. https://docs.microsoft.com/en-us/azure/machine-learning/studio-module-reference/import-from- on-premises-sql-server-database

Topics

#Import Data#Data Management Gateway#on-premises SQL Server#Transact-SQL

Community Discussion

No community discussion yet for this question.

Full 70-774 Practice