Microsoft Perform Data Engineering on Microsoft Azure HDInsight - 070-775 Exam Practice Test

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 are implementing a batch processing solution by using Azure HDInsight.
You have a workflow that retrieves data by using a U-SQL query.
You need to provide the ability to query and combine data from multiple data sources.
What should you do?

You have an Apache Hive table that contains one billion rows.
You plan to use queries that will filter the data by using the WHERE clause. The values of the columns will be known only while the data loads into a Hive table.
You need to decrease the query runtime.
What should you configure?

You have an array of integers in Apache Spark.
You need to save the data to an Apache Parquet file.
Which methods should you use?

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 deploy a domain-joined HDInsight cluster for query and analytics batch jobs. The cluster will be managed by using HDInsight applications. Apache Oozie will be used for scheduling jobs.
What should you do?

DRAG DROP
You have a domain-joined Azure HDInsight cluster.
You plan to assign permissions to several support staff.
You need to assign roles to the staff so that they can perform specific tasks. The solution must use the principle of least privilege.
Which role should you assign for each task? To answer, drag the appropriate roles to the correct targets.
Each role 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.

DRAG DROP
You have an Apache HBase cluster in Azure HDInsight. The cluster has a table named sales that contains a column family named customerfamily.
You need to add a new column family named customeraddr to the sales table.
How should you complete the command? 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 between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

DRAG DROP
You are evaluating the use of Azure HDInsight clusters for various workloads.
Which type of HDInsight cluster should you create for each workload? To answer, drag the appropriate cluster types to the correct workloads. Each cluster type 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.