<< Prev Question Next Question >>

Question 32/35

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 data. 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.
Hot Area:

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (35q)
Question 1: Note: This question is part of a series of questions that us...
Question 2: DRAG DROP You have an Apache Hive cluster in Azure HDInsight...
Question 3: Note: This question is part of a series of questions that us...
Question 4: You plan to copy data from Azure Blob storage to an Azure SQ...
Question 5: Note: This question is part of a series of questions that us...
Question 6: Note: This question is part of a series of questions that us...
Question 7: You are configuring the Hive views on an Azure HDInsight clu...
Question 8: Note: This question is part of a series of questions that us...
Question 9: You have an Apache Spark cluster in Azure HDInsight. You exe...
Question 10: You have an Apache Spark cluster in Azure HDInsight. You pla...
Question 11: DRAG DROP You have a domain-joined Azure HDInsight cluster. ...
Question 12: You use YARN to manage the resources for a Spark Thrift Serv...
Question 13: Note: This question is part of a series of questions that us...
Question 14: Note: This question is part of a series of questions that us...
Question 15: You have an Apache Hive table that contains one billion rows...
Question 16: DRAG DROP Note: This question is part of a series of questio...
Question 17: Note: This question is part of a series of questions that pr...
Question 18: Note: This question is part of a series of questions that us...
Question 19: DRAG DROP You have a text file named Data/examples/product.t...
1 commentQuestion 20: Note: This question is part of a series of questions that us...
Question 21: Note: This question is part of a series of questions that us...
Question 22: Note: This question is part of a series of questions that pr...
Question 23: Note: This question is part of a series of questions that us...
Question 24: You have an Apache Hadoop cluster in Azure HDInsight that ha...
Question 25: Note: This question is part of a series of questions that us...
Question 26: DRAG DROP You are evaluating the use of Azure HDInsight clus...
Question 27: You have an Azure HDInsight cluster. You need to store data ...
Question 28: Note: This question is part of a series of questions that us...
Question 29: Note: This question is part of a series of questions that us...
Question 30: You have an Azure HDInsight cluster. You need a build a solu...
Question 31: DRAG DROP You have a domain-joined Apache Hadoop cluster in ...
Question 32: HOTSPOT You install the Microsoft Hive ODBC Driver on a comp...
Question 33: Note: This question is part of a series of questions that pr...
Question 34: DRAG DROP You have an Apache HBase cluster in Azure HDInsigh...
Question 35: Note: This question is part of a series of questions that pr...