Microsoft 70-774 Dumps 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 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

Answer: D

NEW 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 have a non-tabular file that is saved in Azure Blob storage.
You need to download the file locally, access the data in the file, and then format the data as a dataset. Which module should you use?

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

Answer: E

Explanation: References:
https://msdn.microsoft.com/en-us/library/azure/mt674698.aspx

NEW QUESTION 3
You are building an Azure Machine Learning experiment.
You need to transform a string column that has 47 distinct values into a binary indicator column. The solution must use the One-vs-All Multiclass model.
Which module should you use?

• A. Select Column Transform
• B. Convert to Indicator Values
• C. Group Categorical Values
• D. Edit Metadata

Answer: B

NEW QUESTION 4
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.

Answer:

Explanation: References:
https://docs.microsoft.com/en-us/sql/advanced-analytics/tutorials/rtsql-r-and-sql-data-types-and-data-objects

NEW QUESTION 5
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 designing an Azure Machine Learning workflow.
You have a dataset that contains two million large digital photographs. You plan to detect the presence of trees in the photographs.
You need to ensure that your model supports the following:
Solution: You create a Machine Learning experiment that implements the Multiclass Neural Network module. Does this meet the goal?

• A. Yes
• B. No

Answer: A

NEW QUESTION 6
You have data about the following:
• Users
• Movies
• User ratings of the movies
You need to predict whether a user will like a particular movie. Which Matchbox recommender should you use?

• A. Rating Prediction
• B. Related Users
• C. Item Recommendation
• D. Related Items

Answer: A

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

Answer: A

Explanation: References:
https://msdn.microsoft.com/en-us/library/azure/dn905915.aspx

NEW QUESTION 8
From the Cortana Intelligence Gallery, you deploy a solution. You need to modify the solution.
What should you use?

• A. Azure Stream Analytics
• B. Microsoft Power BI Desktop
• C. Azure Machine Learning Studio
• D. R Tools for Visual Studio

Answer: C

Explanation: References:
https://docs.microsoft.com/en-us/azure/machine-learning/studio/gallery-experiments

NEW QUESTION 9
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 connect the Score Model modules from each trained model as inputs for the Evaluate Model
module, and use the Execute R Script module.
Does this meet the goal?

• A. Yes
• B. No

Answer: A

Explanation: References:
https://msdn.microsoft.com/en-us/library/azure/dn905915.aspx

NEW QUESTION 10
You are building an Azure Machine Learning experiment.
You need to transform a string column into a label column for a Multiclass Decision Jungle module. Which module should you use?

• A. Select Columns Transform
• B. Group Categorical Values
• C. Convert to Indicator Values
• D. Edit Metadata

Answer: D

NEW QUESTION 11
You are analyzing taxi trips in New York City. You leverage the Azure Data Factory to create data pipelines and to orchestrate data movement.
You plan to develop a predictive model for 170 million rows (37 GB) of raw data in Apache Hive by using Microsoft R Server to identify which factors contribute to the passenger tipping behavior.
All of the platforms that are used for the analysis are the same. Each worker node has eight processor cores and 26 GB of memory.
Which type of Azure HDInsight cluster should you use to produce results as quickly as possible?

• A. Hadoop
• B. HBase
• C. Interactive Hive
• D. Spark

Answer: D

Explanation: References:
https://azure.microsoft.com/en-gb/blog/general-availability-of-hdinsight-interactive-query-blazing-fast-data-war

NEW QUESTION 12
You have an Execute R Script module that has one input from either a Partition and Sample module or a Web service input module.
You need to preprocess tweets by using R. The solution must meet the following requirements:
How should you complete the R code? 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 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 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.
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.
You need to alter the list of columns that will be used for predicting fraud for an input web service endpoint. The columns from the original data source must be retained while running the Machine Learning experiment.
Which module should you add after the web service input module and before the prediction module?

• A. Edit Metadata
• B. Import Data
• C. SMOTE
• D. Select Columns in Dataset

Answer: D

NEW QUESTION 14
You need to integrate code and formatted text into an Azure Machine Learning experiment that enables interactive execution.
What should you use?

• A. a Jupyter notebook
• B. Azure Stream Analytics
• C. an Execute Python Script module
• D. an Execute R Script module

Answer: A

NEW QUESTION 15
You are building a classification experiment in Azure Machine Learning.
You need to ensure that you can use the Evaluate Model module the experiment.
Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

• A. Connect the input of the Score Model modules to the output of the Evaluate Model module.
• B. Connect the input of the Score Model modules to the output of the Train Model modules and the output Split Data modules.
• C. Connect the output of the Score Model modules to the input of the Evaluate Model module.
• D. Connect the output of the Score Model modules to the input of the Train Model modules and the input of the Split Data modules.

Answer: AB

NEW QUESTION 16
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 plan to predict flight delays that are 30 minutes or more.
You need to build a training model that accurately fits the data. The solution must minimize over fitting and minimize data leakage.
Which attribute should you remove?

• A. OriginAirportID
• B. DepDel
• C. DepDel30
• D. Carrier
• E. DestAirportID

Answer: C