Guarantee All Exams 100% Pass One Time!
2021 NEW Microsoft 70-775: Perform
Data Engineering on Microsoft Azure
HDInsight Exam Questions and Answers
QUESTION 21
Note: This question is part of a series of questions that use the same scenario. For
your convenience, the scenario is repeated in each question. Each question
presents a different goal and answer choices, but the text of the scenario is exactly
the same in each question in this series.
You are planning a big data infrastructure by using an Apache Spark cluster in Azure
HDInsight. The cluster has 24 processor cores and 512 GB of memory.
This study resource
The architecture of the infrastructure is shown in the exhibit. (Click the Exhibit
button.)
was
The architecture will be used by the following users:
Support analysts who run applications that will use REST to submit Spark jobs.
Business analysts who use JDBC and ODBC client applications from a real-time view.
The business analysts run monitoring queries to access aggregate results for 15
minutes. The results will be referenced by subsequent queries.
, Guarantee All Exams 100% Pass One Time!
Data analysts who publish notebooks drawn from batch layer, serving layer, and
speed layer queries. All of the notebooks must support native interpreters for
data sources that are batch processed. The serving layer queries are written in
Apache Hive and must support multiple sessions. Unique GUIDs are used across
the data sources, which allow the data analysts to use Spark SQL.
The data sources in the batch layer share a common storage container. The
following data sources are used:
Hive for sales data
Apache HBase for operations data
HBase for logistics data by using a single region server
You need to ensure that the support analysts can develop embedded analytics
applications by using the least amount of development effort.
Which technology should you implement?
A. Zeppelin
B. Jupyter
C. Apache Ambari
D. Livy
Answer: D
Explanation:
https://docs.microsoft.com/en-us/azure/hdinsight/hdinsight-apache-spark-livy-rest-
interface
QUESTION 22
You have an Apache Hive table that contains one billion rows.
You plan to use queries that will filter the data by using the WHERE clause. The
values of the columns will be known only while the data loads into a Hive table.
You need to decrease the query
runtime. What should you
configure?
A. static partitioning
B. bucket sampling
C. parallel execution
D. dynamic partitioning
Answer: C
Explanation:
https://www.qubole.com/blog/5-tips-for-efficient-hive-queries/
QUESTION 23
You have an Azure HDInsight cluster.
You need a build a solution to ingest real-time streaming data into a nonrelational
distributed database.
What should you use to build the solution?
A. Apache Hive and Apache Kafka
B. Spark and Phoenix
2021 NEW Microsoft 70-775: Perform
Data Engineering on Microsoft Azure
HDInsight Exam Questions and Answers
QUESTION 21
Note: This question is part of a series of questions that use the same scenario. For
your convenience, the scenario is repeated in each question. Each question
presents a different goal and answer choices, but the text of the scenario is exactly
the same in each question in this series.
You are planning a big data infrastructure by using an Apache Spark cluster in Azure
HDInsight. The cluster has 24 processor cores and 512 GB of memory.
This study resource
The architecture of the infrastructure is shown in the exhibit. (Click the Exhibit
button.)
was
The architecture will be used by the following users:
Support analysts who run applications that will use REST to submit Spark jobs.
Business analysts who use JDBC and ODBC client applications from a real-time view.
The business analysts run monitoring queries to access aggregate results for 15
minutes. The results will be referenced by subsequent queries.
, Guarantee All Exams 100% Pass One Time!
Data analysts who publish notebooks drawn from batch layer, serving layer, and
speed layer queries. All of the notebooks must support native interpreters for
data sources that are batch processed. The serving layer queries are written in
Apache Hive and must support multiple sessions. Unique GUIDs are used across
the data sources, which allow the data analysts to use Spark SQL.
The data sources in the batch layer share a common storage container. The
following data sources are used:
Hive for sales data
Apache HBase for operations data
HBase for logistics data by using a single region server
You need to ensure that the support analysts can develop embedded analytics
applications by using the least amount of development effort.
Which technology should you implement?
A. Zeppelin
B. Jupyter
C. Apache Ambari
D. Livy
Answer: D
Explanation:
https://docs.microsoft.com/en-us/azure/hdinsight/hdinsight-apache-spark-livy-rest-
interface
QUESTION 22
You have an Apache Hive table that contains one billion rows.
You plan to use queries that will filter the data by using the WHERE clause. The
values of the columns will be known only while the data loads into a Hive table.
You need to decrease the query
runtime. What should you
configure?
A. static partitioning
B. bucket sampling
C. parallel execution
D. dynamic partitioning
Answer: C
Explanation:
https://www.qubole.com/blog/5-tips-for-efficient-hive-queries/
QUESTION 23
You have an Azure HDInsight cluster.
You need a build a solution to ingest real-time streaming data into a nonrelational
distributed database.
What should you use to build the solution?
A. Apache Hive and Apache Kafka
B. Spark and Phoenix
