Microsoft 70-773 Online Practice Questions and Exam Preparation

Microsoft 70-773 Online Questions & Answers

• Question 11:

  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. RxComputeContext
  B. RxHadoopMR
  C. rxExec
  D. RxLocalParallel
  C. rxExec

• Question 12:

  You have an Apache Hadoop Hive data warehouse. RevoScalerR 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.
  D. Execute a Hive query that sorts the data, and then reads the results.

• Question 13:

  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
  D. the rxQuantile function

• Question 14:

  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(transforms = `removeMissing')
  C. rxDataStep(transformFunc = `removeMissing')
  D. rxDataStep(removeMissingsOnRead = FALSE, removeMissing = TRUE)
  D. rxDataStep(removeMissingsOnRead = FALSE, removeMissing = TRUE)

• Question 15:

  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
  D. cross validation

• Question 16:

  You plan to analyze data on a local computer. To improve performance, you plan to alternate the operation between a Microsoft SQL Server and the local computer.

  You need to run complex code on the SQL Server, and then revert to the local compute context.

  Which R code segment should you use?

  A. sqlCompute
  B. sqlCompute
  C. sqlCompute
  D. sqlCompute
  D. sqlCompute

• Question 17:

  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.
  A. Assign a value to the first 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.

• Question 18:

  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.

  Select and Place:

  

  

• Question 19:

  You need to build a model that looks at the probability of an outcome. You must regulate between L1 and L2. Which classification method should you use?

  A. Two-Class Neutral Network
  B. Two-Class Support Vector Machine
  C. Two-Class Decision Forest
  D. Two-Class Logistic Regression
  D. Two-Class Logistic Regression

• Question 20:

  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
  H. the ggplot2 package