Microsoft 70-774 Online Practice Questions and Exam Preparation

Microsoft 70-774 Online Questions & Answers

• Question 1:

  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.

  A travel agency named Margie's Travel sells airline tickets to customers in the United States.

  Margie's Travel wants you to provide insights and predictions on flight delays. The agency is considering implementing a system that will communicate to its customers as the flight departure nears about possible delays due to weather

  conditions. The flight data contains the following attributes:

  The weather data contains the following attributes: AirportID, ReadingDate (YYYY/MM/DD HH), SkyConditionVisibility, WeatherType, WindSpeed, StationPressure, PressureChange, and HourlyPrecip.

  You need to use historical data about on-time flight performance and the weather data to predict whether the departure of a scheduled flight will be delayed by more than 30 minutes.

  Which method should you use?

  A. clustering
  B. linear regression
  C. classification
  D. anomaly detection
  C. classification

• Question 2:

  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 transform the columns in a dataset. The resulting data must be mean centered and have a variance of L The solution must use a native module.

  Which module should you use?

  A. Execute Python Script
  B. Import Data
  C. Edit Metadata
  D. Select Columns in Dataset
  E. Clean Missing Data
  F. Tune Model Hyperparameters
  G. Clip Values
  H. Normalize Data
  H. Normalize Data

• Question 3:

  You have the following three training datasets for a restaurant:

  You must recommend restaurant to a particular user based only on the users features.

  You need to use a Matchbox Recommender to make recommendations.

  How many input parameters should you specify?

  A. 1
  B. 2
  C. 3
  D. 4
  B. 2

• Question 4:

  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 plan to create a predictive analytics solution for credit risk assessment and fraud prediction in Azure Machine Learning. The Machine Learning workspace for the solution will be shared with other users in your organization. You will add assets to projects and conduct experiments in the workspace.

  The experiments will be used for training models that will be published to provide scoring from web services.

  The experiment for fraud prediction will use Machine Learning modules and APIs to train the models and will predict probabilities in an Apache Hadoop ecosystem.

  End of repeated scenario.

  The users will use different data sources that follow a standard format. The users will receive results in a standard format by using the fraud prediction web service. The results will be saved to a location specified by the users.

  You need to provide the users with the ability to get results for different risk tolerances without affecting the calculation of the model. Which three modules should be configured to use the Web Service Parameters? Each correct answer

  presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. Evaluate Model
  B. Import Data
  C. Select Columns in Dataset
  D. Export Data
  E. Time Series Anomaly Detection
  A. Evaluate Model
  B. Import Data
  D. Export Data

• Question 5:

  HOTSPOT

  You need to use R code in a Transact-SQL statement to merge the repeating values 1 through 6 with Col1 in a table.

  Which statement should you use? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  

• Question 6:

  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 change a column name to a friendly name. The solution must use a native module. Which module should you use?

  A. Normalize Data
  B. Select Columns in Dataset
  C. Import Data
  D. Edit Metadata
  E. Tune Model Hyperparameters
  F. Clean Missing Data
  G. Clip Values
  H. Execute Python Script
  D. Edit Metadata

• Question 7:

  You have an Azure Machine Learning environment.

  You are evaluating whether to use R code or Python.

  Which three actions can you perform by using both R code and Python in the Machine Learning environment? Each correct answer presents a complete solution.

  NOTE: Each correct selection is worth one point.

  A. Preprocess, cleanse, and group data.
  B. Score a training model.
  C. Create visualizations.
  D. Create an untrained model that can be used with the Train Model module.
  E. Implement feature ranking.
  A. Preprocess, cleanse, and group data.
  B. Score a training model.
  C. Create visualizations.

• Question 8:

  You plan to use the Data Science Virtual Machine for development, but you are unfamiliar with R scripts.

  You need to generate R code for an experiment.

  Which IDE should you use?

  A. XgBoost
  B. Rattle
  C. Vowpal Wabbit
  D. R Tools for Visual Studio
  C. Vowpal Wabbit

• Question 9:

  You are building an Azure Machine Learning experiment.

  You are preparing the output of a Boosted Decision Tree Regression module. You add a Normalize Data module to the experiment.

  You need to ensure that the range of the transformation method produces an output on a scale of -1 to 1.

  Which transformation method should you use?

  A. MinMax
  B. TanH
  C. Logistic
  D. Zscore E. LogNormal
  D. Zscore E. LogNormal

• Question 10:

  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 are working on an Azure Machine Learning experiment.

  You have the dataset configured as shown in the following table.

  

  You need to ensure that you can compare the performance of the models and add annotations to the results.

  Solution: You consolidate the output of the Score Model modules by using the Add Rows module, and then use the Execute R Script module. Does this meet the goal?

  A. Yes
  B. No
  A. Yes