Online Access Free 070-774 Practice Test

You have the following HiveQL query in an Import Data module.

Which type of operation is being performed?

• A.random sampling by groups
• B.sampling a bucketized table
• C.uniform random sampling
• D.stratified sampling

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.Execute Python Script
• B.Edit Metadata
• C.Tune Model Hyperparameters
• D.Select Columns in Dataset
• E.Import Data
• F.Normalize Data
• G.Clip Values
• H.Clean Missing Data

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 save the output of the Score Model modules as a combined set, and then use the Project Columns module to select the MAE.
Does this meet the goal?

• A.Yes
• B.No

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 an endpoint to the Computer vision API.
Does this meet the goal?

• A.Yes
• B.No

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.Select Columns in Dataset
• C.Import Data
• D.SMOTE