Free Microsoft 070-773 Exam Dumps Questions & Answers

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a Microsoft SQL Server instance that has R Services (In-Database) installed.
You need to monitor the R jobs that are sent to SQL Server.
Solution: You call a function from the RevoPemaR package.
Does this meet the goal?

• A.  No
• B.  Yes

You have a Microsoft SQL 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.  rxImportToXdf and specify specify the CSV file as the input
• B.  RxSqlServerData and specify the CSV file path in the connection string
• C.  read.csv and specify the CSV file path as the parameter
• D.  rxDataStep and specify the CSV file path as the inFile argument

You are planning the compute contexts for your environment.
You need to execute rx-function calls in parallel.
What are three possible compute contexts that you can use to achieve this goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

• A.  local sequential
• B.  local parallel
• C.  SQL
• D.  Spark
• E.  Map Reduce

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You need to evaluate the significance of coefficients that are produced by using a model that was estimated already.
Which function should you use?

• A.  rxLinMod
• B.  rxTweedie
• C.  rxTransform
• D.  summary
• E.  stepAic
• F.  rxDataStep
• G.  rxPredict
• H.  rxLogit

You need to use the ScaleR distributed processing in an Apache Hadoop environment.
Which data source should you use?

• A.  XDF data files
• B.  ODBC data
• C.  Microsoft SQL Server database
• D.  Teradata database