Online Access Free 070-773 Exam Questions

You have a dataset that has multiple blocks and only numeric variables.
You are computing in a local compute context.
You plan to lag a variable named x to create a new variable named x_lagged by using a transform function. You will create a new element in the output of the function.
You need to minimize the number of missing values.
Which three actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A.Use rxSet to store the last value of x in the current block.
• B.Use rxGet to retrieve the first value of x in the next block to be processed.
• C.Use rxGet to retrieve a value stored in processing of the prior block.
• D.Assign a value to the first value of x_lagged in the current block.
• E.Use rxSet to store the last value of x_lagged in the current block.

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

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 calculate a measure of central tendency and variability for the variables in a dataset that is grouped by using another categorical variable.
What should you use?

• A.the rxSummary function
• B.the rxQuantile function
• C.the ggplot2 package
• D.the rxCube function
• E.the summary function
• F.the rxCrossTabs function
• G.the rxHistogram function
• H.the Describe package

You have a slow Map Reduce job.
You need to optimize the job to control the number of mapper and runner tasks.
Which function should you use?

• A.rxExec
• B.RxHadoopMR
• C.RxComputeContext
• D.RxLocalParallel

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.
Start of repeated scenario
You are developing a Microsoft R Open solution that will leverage the computing power of the database server for some of your datasets.
You are performing feature engineering and data preparation for the datasets.
The following is a sample of the dataset.

End of repeated scenario.
You need to analyze the dataset without the missing values. The solution must not remove the missing values from the dataset.
Which R code segment should you use?

• A.rxDataStep(varsToDrop = NULL)
• B.rxDataStep(transformFunc = 'removeMissing')
• C.rxDataStep(transforms = 'removeMissing')
• D.rxDataStep(removeMissingsOnRead = FALSE, removeMissing = TRUE)