exam questions

Exam DP-201 All Questions

View all questions & answers for the DP-201 exam

Exam DP-201 topic 2 question 12 discussion

Actual exam question from Microsoft's DP-201
Question #: 12
Topic #: 2
[All DP-201 Questions]

HOTSPOT -
A company stores large datasets in Azure, including sales transactions and customer account information.
You must design a solution to analyze the data. You plan to create the following HDInsight clusters:

You need to ensure that the clusters support the query requirements.
Which cluster types should you recommend? To answer, select the appropriate configuration in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: Interactive Query -
Choose Interactive Query cluster type to optimize for ad hoc, interactive queries.

Box 2: Hadoop -
Choose Apache Hadoop cluster type to optimize for Hive queries used as a batch process.
Note: In Azure HDInsight, there are several cluster types and technologies that can run Apache Hive queries. When you create your HDInsight cluster, choose the appropriate cluster type to help optimize performance for your workload needs.
For example, choose Interactive Query cluster type to optimize for ad hoc, interactive queries. Choose Apache Hadoop cluster type to optimize for Hive queries used as a batch process. Spark and HBase cluster types can also run Hive queries.
Reference:
https://docs.microsoft.com/bs-latn-ba/azure/hdinsight/hdinsight-hadoop-optimize-hive-query?toc=%2Fko-kr%2Fazure%2Fhdinsight%2Finteractive-query%
2FTOC.json&bc=%2Fbs-latn-ba%2Fazure%2Fbread%2Ftoc.json

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
M0e
Highly Voted 4 years, 8 months ago
HDInsight is not covered in the exam any more.
upvoted 10 times
...
REZ82
Highly Voted 5 years ago
Cluster types in HDInsight https://docs.microsoft.com/bs-latn-ba/azure/hdinsight/hdinsight-overview#cluster-types-in-hdinsight
upvoted 6 times
...
H_S
Most Recent 4 years, 3 months ago
NOT ANY MORE IN THE DP-201
upvoted 1 times
...
Deepu1987
4 years, 4 months ago
The given soln is correct Interactive qury - In-memory caching for interactive and faster Hive queries hadoop - A framework that uses HDFS, YARN resource management, and a simple MapReduce programming model to process and analyze batch data in parallel. We're receiving qns on this topic until dp-201 is removed
upvoted 2 times
...
chaoxes
4 years, 6 months ago
Answer is correct. Sales: Interactive Queries In-memory caching for interactive and faster Hive queries. Accounts: Hadoop A framework that uses HDFS, YARN resource management, and a simple MapReduce programming model to process and analyze batch data in parallel. Source: https://docs.microsoft.com/bs-latn-ba/azure/hdinsight/hdinsight-overview#cluster-types-in-hdinsight
upvoted 6 times
...
syu31svc
4 years, 6 months ago
Answer is correct
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...