Microsoft 70-773: Analyzing Big Data with Microsoft R Exam

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 create an events trace configuration file and place the file in the same directory as the BXLServer process.

Does this meet the goal?

• Yes

• No

You have a dataset.

You need to repeatedly split randomly the dataset so that 80 percent of the data is used as a training set and the remaining 20 percent is used as a test set.

Which method should you use?

• threshold

• binary classification

• imputation

• cross validation

• pruning

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 register an Extended Events package.

Does this meet the goal?

• Yes

• No

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?

• the rxCrossTabs function

• the rxHistogram function

• the rxSummary function

• the rxQuantile function

• the rxCube function

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.

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?

• rxDataStep(varsToDrop = NULL)

• rxDataStep(transforms = `removeMissing')

• rxDataStep(transformFunc = `removeMissing')

• rxDataStep(removeMissingsOnRead = FALSE, removeMissing = TRUE)

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.

You have the following R code.

Which function determines the variable?

• transformVars

• rxXdfDataFrame

• createRandomSample

• transformFunc

You need to evaluate the significance of coefficients that are

produced by using a model that was estimated already.

Which function should you use?

• rxPredict

• rxLogit

• summary

• rxLinMod

• rxTweedie

You use dplyrXdf, and you discover that after you exit the session, the output files that were created were deleted.

You need to prevent the files from being deleted.

Solution: You use rxSetComputeContext with the local parameter before performing operations that save results.

Does this meet the goal?

• Yes

• No

You need to use the ScaleR distributed processing in an Apache Hadoop environment.

Which data source should you use?

• Microsoft SQL Server database

• XDF data files

• ODBC data

• Teradata database

You perform an analysis that produces the decision tree shown in the exhibit.

How many leaf nodes are there on the tree?

• 2

• 3

• 5

• 7