Microsoft 70-773 Online Practice Questions and Exam Preparation

Microsoft 70-773 Online Questions & Answers

• Question 31:

  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
  A. transformVars

• Question 32:

  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 evaluate the significance of coefficients 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
  D. rxLinMod

• Question 33:

  You have the following regression forest.

  

  Which variable contributes the most to the dependent variable?

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

• Question 34:

  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
  D. rxDTree

• Question 35:

  You have a dataset that has a character variable. You need to create a bag of counts of n-grams. Which function should you use?

  A. featurizeText()
  B. categoricalHash()
  C. concat()
  D. selectFeatures()
  E. categorical()
  A. featurizeText()

• Question 36:

  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
  A. Yes

• Question 37:

  You plan to read data from an Oracle database table and to store the data in the file system for later processing by dplyrXdf. The size of the data is larger than the memory on the server to be used for modelling.

  You need to ensure that the data can be processed by dplyrXdf in the least amount of time possible.

  How should you transfer the data from the Oracle database?

  A. Define a data source to the Oracle database server by using RxOdbcData. Use rxImport to save the data to a comma-separated values (CSV) file.
  B. Use the RODBC library, connect to the Oracle database server by using odbcConnect, and then use rxDataStep to export the data to a comma-separated values (CSV) file.
  C. Define a data source to the Oracle database server by using RxOdbcData, and then use rxImport to save the data to an XDF file.
  D. Use the RODBC library, connect to the Oracle database server by using odbcConnect, and then use rxSplit to save the data to multiple comma-separated values (CSV) file.
  C. Define a data source to the Oracle database server by using RxOdbcData, and then use rxImport to save the data to an XDF file.

• Question 38:

  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 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
  B. rxLogit

• Question 39:

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

  Does this meet the goal?

  A. Yes
  B. No
  A. Yes