70-775 無料問題集「Microsoft Perform Data Engineering on Microsoft Azure HDInsight」
HOTSPOT
You install the Microsoft Hive ODBC Driver on a computer that runs Windows 10 and has the 64-bit version of Microsoft Office 2016 installed.
You deploy a new Apache Interactive Hive cluster in Azure HDInsight. The cluster is hosted at myHDICluster.azurehdinsight.net and contains a Hive table name hivesampletable that has 200,000 rows.
You plan to use HiveQL exclusively for the queries. The queries will return from 6,000 to 10,000 rows 90 percent of the time.
You need to configure a data source to ensure that you can use Microsoft Excel to access the dat a. The solution must ensure that the Hive queries execute as quickly as possible.
How should you configure the Advanced Options from the Microsoft Hive ODBC Driver DSN Setup dialog box? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You install the Microsoft Hive ODBC Driver on a computer that runs Windows 10 and has the 64-bit version of Microsoft Office 2016 installed.
You deploy a new Apache Interactive Hive cluster in Azure HDInsight. The cluster is hosted at myHDICluster.azurehdinsight.net and contains a Hive table name hivesampletable that has 200,000 rows.
You plan to use HiveQL exclusively for the queries. The queries will return from 6,000 to 10,000 rows 90 percent of the time.
You need to configure a data source to ensure that you can use Microsoft Excel to access the dat a. The solution must ensure that the Hive queries execute as quickly as possible.
How should you configure the Advanced Options from the Microsoft Hive ODBC Driver DSN Setup dialog box? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正解：
References: https://docs.microsoft.com/en-us/azure/hdinsight/hdinsight-connect-excel-hive-odbc- driver
DRAG DROP
You have a customer who recently created a new Azure subscription.
You need to create an Azure HDInsight cluster for the customer.
Which four components should you create in sequence? To answer, move the appropriate components from the list of components to the answer area and arrange them in the correct order.
You have a customer who recently created a new Azure subscription.
You need to create an Azure HDInsight cluster for the customer.
Which four components should you create in sequence? To answer, move the appropriate components from the list of components to the answer area and arrange them in the correct order.
正解：
References: https://docs.microsoft.com/en-us/azure/data-lake-store/data-lake-store-hdinsight-hadoop- use-portal
You use YARN to manage the resources for a Spark Thrift Server running on a Linux-based Apache Spark cluster in Azure HDInsight.
You discover that the cluster does not fully utilize the resources. You want to increase resource allocation.
You need to increase the number of executors and the allocation of memory to the Spark Thrift Server driver.
Which two parameters should you modify? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You discover that the cluster does not fully utilize the resources. You want to increase resource allocation.
You need to increase the number of executors and the allocation of memory to the Spark Thrift Server driver.
Which two parameters should you modify? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
正解：C、E
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
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 plan to import 300 TB of dat
a.
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 tasks for the job.
What should you do?
You are implementing a batch processing solution by using Azure HDInsight.
You plan to import 300 TB of dat
a.
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 tasks for the job.
What should you do?
正解：D
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
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 an enterprise data warehouse that will support in-memory analytics. The data warehouse must support connections that use the Microsoft Hive ODBC Driver and Beeline. The data warehouse will be managed by using Apache Amrabi only.
What should you do?
You need to deploy an enterprise data warehouse that will support in-memory analytics. The data warehouse must support connections that use the Microsoft Hive ODBC Driver and Beeline. The data warehouse will be managed by using Apache Amrabi only.
What should you do?
正解：E
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
