Microsoft 70-773 Online Practice Questions and Exam Preparation

Microsoft 70-773 Online Questions & Answers

• Question 21:

  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
  A. RxSpark on the Hadoop cluster

• Question 22:

  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 appropriate values to the correct targets. Each value 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 23:

  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
  C. 5

• Question 24:

  HOTSPOT

  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 plan to score some data to create data features to address empty rows.

  You have the following R code.

  

  You need to transform the data and overwrite the current dataset.

  Which R code segment should you use? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  

• Question 25:

  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
  D. read.csv and specify the CSV file path as the parameter

• Question 26:

  HOTSPOT

  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 sort the data from the dataset sample and to remove duplicates by using wkswork1.

  Which R code segment should you use? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  

• Question 27:

  You have one-class support vector machines (SVMs).

  You have a large dataset, but you do not have enough training time to fully test the model.

  What is an alternative method to validate the model?

  A. Use Principal Components Analysis (PCA)-Based Anomaly Detection.
  B. Replace the SVMs with two-class SVMs.
  C. Perform feature selection.
  D. Use outlier detection.
  A. Use Principal Components Analysis (PCA)-Based Anomaly Detection.

• Question 28:

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

• Question 29:

  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 call a function from the RevoPemaR package.

  Does this meet the goal?

  A. Yes
  B. No
  B. No

• Question 30:

  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 data source that is larger than memory.

  You need to visualize the distribution of the values for a variable in the data source.

  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
  B. the rxHistogram function