PrepAway - Latest Free Exam Questions & Answers

Category: 70-773

Briefing 70-773: Analyzing Big Data with Microsoft R

Which R code segment should you use?

DRAG DROP
You are using rxPredict for a logistic regression model.
You need to obtain prediction standard errors and confidence intervals.
Which R code segment should you use? To answer, drag the appropriate values to the correct targets. Each
value may be used once, more than once, or not at all. You may need to drag the split bar between panes or
scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

Which function should insert at line 02?

You are running a parallel function that uses the following R code segment. (Line numbers are included for
reference only.)
01 cp <- 0.01 xval <- 0 maxdepth <- 5
02
03 (form, data = “segmentationDataBig”, maxDepth = maxdepth, cp = cp, xval = xval, blocksPerRead = 250
You need to complete the R code. The solution must support chunking.
Which function should insert at line 02?

How should you transfer the data from the Oracle database?

You plan to read data from an Oracle database table and to store the data in the file system for later processing
by dplyrXdf. The size of the data is larger than the memory on the server to be used for modelling.
You need to ensure that the data can be processed by dplyrXdf in the least amount of time possible.
How should you transfer the data from the Oracle database?

What should you use from sp_execute_external_script?

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?

Which function should you use?

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 estimate a model where the outcome variable is continuous, is in the range of [0, inf], and has a
substantial mass at an exact value of 0.
Which function should you use?

Which function should you use?

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 generate a residual based on two columns. The solution must build a trend indicator.
Which function should you use?


Page 3 of 41234