Online Access Free 070-775 Practice Test

You have an Apache Spark cluster in Azure HDInsight.
You execute the following command.

What is the result of running the command?

• A.the Hive ORC library is imported to Spark and external tables in ORC format are created
• B.the Hive ORC library is imported to Spark and the ORC-formatted data stored in Apache Hive tables becomes accessible
• C.the Spark library is imported and the data is loaded to an Apache Hive table
• D.the Spark library is imported and Scala functions are executed

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 table that contains sales dat
a.
You plan to implement a query that will return the number of orders by zip code.
You need to minimize the execution time of the queries and to maximize the compression level of the resulting data.
What should you do?

• A.Use an Azure Data Factory linked service that stores the data in an Azure DocumentDB database.
• B.Decrease the level of parallelism in an Apache Spark job that stores the data in a text format.
• C.Increase the number of spark.executor.cores in an Apache Spark job that stores the data in a text format.
• D.Use an Azure Data Factory linked service that stores the data in Azure Data Lake.
• E.Use a broadcast join in an Apache Hive query that stores the data in an ORC format.
• F.Increase the number of spark.executor.instances in an Apache Spark job that stores the data in a text format.
• G.Use a shuffle join in an Apache Hive query that stores the data in a JSON format.
• H.Use an action in an Apache Oozie workflow that stores the data in a text format.

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 are implementing a batch processing solution by using Azure HDInsight.
You plan to import 300 TB of data.
You plan to use one job that has many concurrent tasks to import the data in memory.
You need to maximize the amount of concurrent tanks for the job.
What should you do?

• A.Decrease the level of parallelism in an Apache Spark job that Mores the data in a text format.
• B.Increase the number of spark.executor.cores in an Apache Spark job that stores the data in a text format.
• C.Use a broadcast join in an Apache Hive query that stores the data in an ORC format.
• D.Increase the number of spark.executor.instances in an Apache Spark job that stores the data in a text format.
• E.Use a shuffle join in an Apache Hive query that stores the data in a JSON format.
• F.Use an action in an Apache Oozie workflow that stores the data in a text format.
• G.Use an Azure Data Factory linked service that stores the data In an Azure DocumentDB database.
• H.Use an Azure Data Factory linked service that stores the data in Azure Data lake.

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.

Correct Answer:

Hbase > disable 'sales'
Hbase > alter 'sales'
'customerfamily',
{NAME => 'customeraddr',
IN_MEMORY => false},
Hbase > enable 'sales'

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?

• A.Use an Azure PowerShell script to create a premium HDInsight cluster. Specify Apache HBase as the cluster type and use Linux as the operating system.
• B.Use an Azure PowerShell script to create and configure a premium HDInsight cluster. Specify Apache Hadoop as the cluster type and use Linux as the operating system.
• C.Use an Azure portal to create a standard HDInsight cluster. Specify Apache HBase as the cluster type and use Linux as the operating system.
• D.Use the Azure portal to create a standard HDInsight cluster. Specify Apache Spark as the cluster type and use Linux as the operating system.
• E.Use an Azure PowerShell script to create a standard HDInsight cluster. Specify Apache Storm as the cluster type and use Windows as the operating system.
• F.Use an Azure portal to create a standard HDInsight cluster. Specify Apache Interactive Hive as the cluster type and use Linux as the operating system.
• G.Use an Azure PowerShell script to create a standard HDInsight cluster. Specify Apache HBase as the cluster type and use Windows as the operating system.