Free Microsoft 70-774 Exam Dumps Questions & Answers

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

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.  Rattle
• B.  R Tools for Visual Studio
• C.  Vowpal Wabbit
• D.  XgBoost

You need to identify which columns are more predictive by using a statistical method.
Which module should you use?

• A.  Principal Component Analysis
• B.  Filter Based Feature Selection
• C.  Group Data into Bins
• D.  Tune Model Hyperparameters

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

You have an Apache Spark cluster in Azure HDinsight. The cluster includes 200 TB in five Apache Hive tables that have multiple foreign key relationships.
You have an Azure Machine Learning model that was built by using SPARK Accelerated Failure Time (AFT) Survival Regression Model (spark-survreg).
You need to prepare the Hive data into a single table as input for the Machine Learning model. The Hive data must be prepared in the least amount of time possible.
What should you use to prepare the data?

• A.  a Hive user-defined function (UDF)
• B.  the GPU
• C.  Java Mapreduce jobs
• D.  Spark SQL