Pinpoint 70-774 Exam Questions and Answers 2021

NEW QUESTION 1
The manager of a call center reports that staffing the center is difficult because the number of calls is unpredictable. You have historical data that contains information about the calls.
You need to build an Azure Machine Learning experiment to predict the number of total calls each hour. Which model should you use?

• A. Multiclass Logistic Regression
• B. Boosted Decision Tree Regression
• C. Decision Forest Regression
• D. Poisson Regression

Answer: D

NEW QUESTION 2
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 3
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 process some data by using Azure Machine Learning Studio. You have an intermediate dataset. The dataset has a column that contains date values stored in a format of MM/DD/YYYY.
ft You need to split the column into three separate columns by year, month, and day.
Which module should you use?

• A. Edit Metadata
• B. Normalize Data
• C. Clean Missing Data
• D. Import Data
• E. Execute Python Script
• F. Clip Values
• G. Clip Values
• H. Execute Python Script

Answer: A

NEW QUESTION 4
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 section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have an Azure ML experiment that contains an intermediate dataset. You need to explore data from the intermediate dataset by using Jupyter.
Solution: You add a web service input to retrieve the data for the data source, and then add the Execute R Script module.
Does this meet the goal?

• A. Yes
• B. No

Answer: B

NEW QUESTION 5
You work for a company that has retail department stores.
You are developing an Azure Machine Learning experiment to predict seasonal sales. You need to address a model overfitting issue by using the following two solutions:
• Solution 1: Controls the penalty for complexity, which, when successful, prevents overfitting
• Solution 2: Separates model selection from testing, causing a more conservative estimate of generalization Which method should you use for each solution? To answer, drag the appropriate methods to the correct
solutions. Each method 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.

Answer:

Explanation:

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

• A. Outputting a file to a network location.
• B. Performing interactive debugging of a Python script.
• C. Saving the results of a Python script run in a Machine Learning environment to a local file.
• D. Visualizing univariate and multivariate summaries by using Python code.

Answer: D

Explanation: References:
https://docs.microsoft.com/en-us/azure/machine-learning/studio/execute-python-scripts

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

Answer: ABC

NEW QUESTION 8
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 9
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 use Azure platform tools to detect and analyze food items in smart refrigerators. To provide families with an integrated experience for grocery shopping and cooking, the refrigerators will connect to other smart appliances, such as stoves and microwave ovens, on a LAN.
You plan to build an object recognition model by using the Microsoft Cognitive Toolkit. The object recognition model will receive input from the connected devices and send results to applications.
The training data will be derived from more than 10 TB of images. You will convert the raw images to the sparse format.
End of repeated scenario.
The image files to train the object recognition model are stored in a Microsoft SQL Server 2021 Standard edition database on an Azure virtual machine (VM).
You need to support R packages that can use full parallel threading and processing for RevoScaleR.
How should you implement R? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Answer:

Explanation:

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
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 section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have an Azure ML experiment that contains an intermediate dataset. You need to explore data from the intermediate dataset by using Jupyter.
Solution: You add a Convert to CSV module to the Azure ML experiment and then open the module output in a new notebook.
Does this meet the goal?

• A. Yes
• B. No

Answer: A

NEW QUESTION 12
You need to create a training set for use with a linear regression model, and then to test the training set.
How should you create the training set? To answer, drag the appropriate modules to the correct locations. Each module 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.

Answer:

Explanation: C:UserswkDesktopmudassarUntitled.jpg

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

• A. Principal Component Analysis
• B. K-Means Clustering
• C. Normalize Data
• D. Group Data into Bins

Answer: A

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

• A. importing Python modules from a ZIP file for execution in a Machine Learning experiment
• B. performing interactive debugging of a Python script
• C. saving the results of a Python script run in a Machine Learning environment to a local file
• D. returning multiple data frames

Answer: A

NEW QUESTION 15
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 dataset that contains a column named Column1. Some of the values in Column1 are empty. You need to replace the empty values by using probabilistic Principal Component Analysis (PCA). The
solution must use a native module.
Which module should you use?

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

Answer: B

NEW QUESTION 16
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 17
You plan to use the Import Data module to import data from a web URL by using HTTP. Which file format can you use as the source of the import operation?

• A. Optimized Row Columnar (ORQ
• B. Extensible Markup Language (XML)
• C. comma-separated value (CSV)
• D. JavaScript Object Notation (JSON)

Answer: D