Exam DP-200 topic 2 question 34 discussion

Actual exam question from Microsoft's DP-200

Question #: 34
Topic #: 2

HOTSPOT -
A company plans to develop solutions to perform batch processing of multiple sets of geospatial data.
You need to implement the solutions.
Which Azure services should you use? To answer, select the appropriate configuration in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer

Suggested Answer:

Box 1: HDInsight Tools for Visual Studio
Azure HDInsight Tools for Visual Studio Code is an extension in the Visual Studio Code Marketplace for developing Hive Interactive Query, Hive Batch Job and
PySpark Job against Microsoft HDInsight.

Box 2: Hive View -
You can use Apache Ambari Hive View with Apache Hadoop in HDInsight. The Hive View allows you to author, optimize, and run Hive queries from your web browser.

Box 3: HDInsight REST API -
Azure HDInsight REST APIs are used to create and manage HDInsight resources through Azure Resource Manager.
References:
https://visualstudiomagazine.com/articles/2019/01/25/vscode-hdinsight.aspx https://docs.microsoft.com/en-us/azure/hdinsight/hadoop/apache-hadoop-use-hive-ambari-view https://docs.microsoft.com/en-us/rest/api/hdinsight/

by zenomas at March 28, 2020, 5:08 a.m.

Comments

Submit Cancel

Luke97

Highly Voted 5 years ago

I think box 3 should also be HDInsight Tools for VS. "Azure HDInsight Tools for Visual Studio Code is an extension in the Visual Studio Code Marketplace for developing Hive Interactive Query, Hive Batch Job and PySpark Job against Microsoft HDInsight." https://marketplace.visualstudio.com/items?itemName=mshdinsight.azure-hdinsight

upvoted 16 times

...

Manue

Highly Voted 5 years, 1 month ago

Honestly, I think quesions and answes make no sense at all. "Hive View" is not a tool to run interactive queries and batch processes. On the other hand, "REST API" is not a tool to designed to develop "batch applications". It's very hard to try to make sense of these questions/answers...

upvoted 15 times

...

dangal95

Most Recent 4 years, 1 month ago

I think that the third answer should also be HDInsight Tools for Visual Studio simply because the questions starts with "Develop..." which means we need to develop the batch job (and possibly push it) to the cluster. The HDInsight API only lets us publish batch jobs through pre-existing JARs which container the batch processing logic / code within itself.

upvoted 1 times

...

syu31svc

4 years, 6 months ago

I would say HDInsight Tools for Visual Studio is the answer for both the 1st and 3rd dropdown Hive view is answer for the 2nd dropdown https://docs.microsoft.com/en-us/azure/hdinsight/hdinsight-for-vscode https://docs.microsoft.com/en-us/azure/hdinsight/hadoop/apache-hadoop-use-hive-ambari-view

upvoted 3 times

syu31svc

4 years, 6 months ago

On second thought, Azure HDInsight REST APIs for batch processing of applications that use HDInsight https://docs.microsoft.com/en-us/rest/api/hdinsight/hdinsight-application

upvoted 2 times

...

wyxh

5 years, 1 month ago

Hive View is designed to help you author, optimize, and execute queries. With Hive Views you can: Browse databases. Write queries or browse query results in full-screen mode, which can be particularly helpful with complex queries or large query results. Manage query execution jobs and history. View existing databases, tables, and their statistics. Create/upload tables and export table DDL to source control. View visual explain plans to learn more about query plan.

upvoted 5 times

...

zenomas

5 years, 2 months ago

I think box 1 and box 3 need to switch. - Visual Studio is a development environment where development is done. - REST API is used to call from the application being developed to HDInsight Cluster to perform actions. Any thoughts!

upvoted 6 times

Leonido

5 years, 1 month ago

Don't think so. The only native application in the list is VS code, and REST api could be used to create a job processing.

upvoted 1 times

...