Microsoft 70-773 Exam Questions 2021

NEW QUESTION 1
Note: This Question is part of a series of Questions that use the same or similar answer choices. An answer choice may be correct 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

Answer: E

NEW QUESTION 2
Note: This question Is part of a series of questions that use the same or similar answer choice. 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 coefficient that are produced by using a model that was estimated already.
Which function should you use?

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

Answer: D

Explanation: https://docs.microsoft.com/en-us/r-server/r/how-to-revoscaler-linear-model

NEW QUESTION 3
DRAG DROP
You need to set the compute context for three different target environments.
Which Statement should you use for each environment? To answer, drag the appropriate statements to the correct execution contexts. Each statement 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.

Answer:

Explanation:

NEW QUESTION 4
You are running a parallel function that uses the following R code segment. (Line numbers are included for reference only.)

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

Answer: C

NEW QUESTION 5
Note: This question Is part of a series of questions that use the same or similar answer choice. 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?

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

Answer: H

NEW QUESTION 6
You have following regression forest.

Which variable contributes the most to the dependent variable?

• A. stack.loss
• B. Water.Temp
• C. Air.Flow
• D. Acid.Conc

Answer: A

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

• A. threshold
• B. binary classification
• C. imputation
• D. cross validation
• E. pruning

Answer: D

NEW QUESTION 8
You have an Apache Hadoop Hive data warehouse. RevoScaleR is not installed. You need to sort the data according to the variables in the dataset.
What should you do?

• A. Connect to the database by using an ODBC connection, and then use the rxSort function.
• B. Create a table in the ORC file format.
• C. Connect to the database by using an ODBC connection, and then use the rxDataStep function.
• D. Execute a Hive query that sorts the data, and then reads the results.

Answer: D

NEW QUESTION 9
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 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

Answer: C

NEW QUESTION 10
You have cloud and on-premises resources that include Microsoft SQL Server and a big data environment in Apache Hadoop.
You have 50 billion fact records.
You need to build time series models to execute forecasting reports on the fact records. What should you use?

• A. RxSpark on the Hadoop cluster
• B. RxHadoopMR on the Hadoop cluster
• C. RxLocalseq on the SQL Server database
• D. RxLocalParallel on the SQL Server database

Answer: A

NEW QUESTION 11
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, whale others might not have a correct solution-After you answer a question in this section, 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. Yes
• B. No

Answer: B

NEW QUESTION 12
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 .impropriate values to the correct targets. Each value may be used once, more than once, or not .You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

NEW QUESTION 13
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, whale others might not have a correct solution-After you answer a question in this section, 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 register an Extended Events package.
Does this meet the goal?

• A. Yes
• B. No

Answer: A

NEW QUESTION 14
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, whale others might not have a correct solution-After you answer a question in this section, 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

Answer: B

NEW QUESTION 15
You need to run a larger data tree model by using rsDForest. The model must use cross validation.
Which rxDForest option should you use?

• A. maxSurrogate
• B. maxNumBins
• C. maxDepth
• D. maxCompete
• E. xVal

Answer: E

Explanation: https://docs.microsoft.com/en-us/r-server/r/how-to-revoscaler-decision-tree

NEW QUESTION 16
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, whale others might not have a correct solution-After you answer a question in this section, 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 persist verb.
Does this meet the goal?

• A. Yes
• B. No

Answer: A

NEW QUESTION 17
Note: This question Is part of a series of questions that use the same or similar answer choice. 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 build a model that uses xyz regression.
You need to estimate a model that predicts a binary variable.
Which function should you use?

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

Answer: B

Explanation: https://docs.microsoft.com/en-us/r-server/r/how-to-revoscaler-logistic- regression