70-773 PDF preview

Question 1

Single choice

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 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 dplyrXdf with the outFile parameter and specify a path other than the working directory for dplyrXdf.

Does this meet the goal?

A.

Yes

B.

No

Question 2

Single choice

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 have a dataset that contains the physical characteristics of people. You need to visualize a relationship between height and weight for a subset of observations in the dataset.

What should you use?

A.

the Describe package

B.

the rxHistogram function

C.

the rxSummary function

D.

the rxQuantile function

E.

the rxCube function

F.

the summary function

G.

the rxCrossTabs function

H.

the ggplot2 package

Question 3

Single choice

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.

RxSqlServerData and specify the CSV file path in the connection string

B.

rxDataStep and specify the CSV file path as the inFile argument

C.

rxImportToXdf and specify specify the CSV file as the input

D.

read.csv and specify the CSV file path as the parameter

Question 4

Single choice

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

Does this meet the goal?

A.

Yes

B.

No

Question 5

Single choice

You perform an analysis that produces the decision tree shown in the exhibit. (Click the Exhibit button.)

How many leaf nodes are there on the tree?

A.

2

B.

3

C.

5

D.

7

Question 6

Single choice

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 have the following R code.

Which function determines the variable?

A.

transformVars

B.

rxXdfDataFrame

C.

createRandomSample

D.

transformFunc

Question 7

Single choice

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 get all of the deciles for a variable in a data frame.

What should you use?

A.

the Describe package

B.

the rxHistogram function

C.

the rxSummary function

D.

the rxQuantile function

E.

the rxCube function

F.

the summary function

G.

the rxCrossTabs function

H.

the ggplot2 package

Question 8

Single choice

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

Which data source should you use?

A.

Microsoft SQL Server database

B.

XDF data files

C.

ODBC data

D.

Teradata database

Question 9

Multiple choice

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.

Assign a value to the first value of x_lagged in the current block.

B.

Use rxSet to store the last value of x_lagged in the current block.

C.

Use rxSet to store the last value of x in the current block.

D.

Use rxGet to retrieve the first value of x in the next block to be processed.

E.

Use rxGet to retrieve a value stored in processing of the prior block.

Question 10

Single choice

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
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?

A.

rxBTrees

B.

rxExec

C.

rxDForest

D.

rxDTree

Microsoft 70-773 - Questions & Answers