What should you use from sp_execute_external_script?

You have a Microsoft SQI Server instance that has R Services (In Database) installed. The server has a comma separated values (CSV) file stored in the local file system.

For analytic purposes, you need to read the CSV file into a database table in the SQL Server instance.

You connect to the SQL Server instance by using SQL Server Management Studio.

What should you use from sp_execute_external_script?
A . RxSqIServerData and specify the CSV file path in the connecting string.
B . rxDataStep and specify the CSV lite path as the inFile argument
C . rxImportToXdf and specify the CSV file as the input
D . read.csv and specify the CSV file path as the parameter.

View Answer

Answer: D