Microsoft MCSA 70-774 Exam Dumps FREE

1. Note: This question is part of a series of questions that present the same Scenario. Each question I 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 correct solution.
You need to remove rows that have an empty value in a specific column. The solution must use a native module. Which module should you use?

2. Note: This question is part of a series of questions that present the same Scenario. Each question I 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 correct solution.
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?

3. Note: This question is part of a series of questions that present the same Scenario. Each question I 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 correct solution.
You have a dataset that contains a column named Column1. Column1 is empty.
You need to omit Column1 from the dataset. The solution must use a native module. Which module should you use?

4. Note: This question is part of a series of questions that present the same Scenario. Each question I 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 correct solution.
You need to use only one percent of an Apache hive Data table by conducting random sampling by groups.
Which module should you use?

5. From the Cortana intelligence Gallery, you deploy a solution.
You need to modify the solution.
What should you use?

6. You are building an Azure Machine Learning workflow by using Azure Machine Learning Studio.
You create an Azure notebook that supports the Microsoft Cognitive Toolkit.
You need to ensure that the stochastic gradient descent (SGO) configuration maximizes the samples per second and supports parallel modeling that is managed by a parameter server.
Which SGD algorithm should you use?

7. 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 Serve to identify which factors contributes 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 28 GB Of memory.
Which type of Azure HDInsight cluster should you use to produce results as quickly as possible?

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?

9. You are performing exploratory analysis of files that are encoded in a complex proprietary format. The format requires disk intensive access to several dependent files in HDFS.
You need to build an Azure Machine Learning model by using a canopy clustering algorithm. You must ensure that changes to proprietary file formats can be maintained by using the least amount of effort.
Which Machine Learning library should you use?

10. 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 tor 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 plan to configure the resources for part of a workflow that will be used to preprocess data from files stored in Azure Blob storage. You plan to use Python to preprocess and store the data in Hadoop.
You need to get the data into Hadoop as quickly as possible.
Which three actions should you perform? Each correct answer presents pan of the solution.
NOTE: Each correct selection is worth one point.

11. 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 tor 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?

12. You have an Azure Machine Learning experiment. You discover that a model causes many errors in a production dataset. The model causes only few errors in the Training data.
What is the cause of the errors?

13. You are building an Azure Machine Learning Solution for an Online retailer.
When a customer selects a product, you need to recommend products that the customer might like to purchase at the same time. The recommendation should be based on what other customers purchased the same product.
Which model should you use?

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

15. You have a dataset that is missing values in a column named Column3. Column3 is correlated to two columns named Column4 and Column5.
You need to improve the accuracy of the dataset, while minimizing data loss.
What should you do?

16. 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?

17. You are building an Azure Machine Learning Experiment.
You need to transform 47 numeric columns into a set of 10 linearly uncorrelated features.
Which module should you add to the experiment?

18. 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.

19. You plan to use Azure Machine Learning to develop a predictive model. You plan to include an Execute Python Script module.
What capability does the module provide?

20. 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?