New Microsoft 70-775: Perform Data Engineering On Microsoft Azure Hdinsight Exam Questions And Answers (Latest 2023/2024) Complete Solutions 2023

QUESTIONS AND ANSWERS (LATEST 2023/2024) COMPLETE SOLUTIONS 2023 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. The architecture of the infrastructure is shown in the exhibit. (Click the Exhibit button.) 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. 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: 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: 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 C. Apache Storm and Apache HBase D. Apache Pig and Apache HCatalog Answer: C QUESTION 24 Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You are building a security tracking solution in Apache Kafka to parse security logs. The security logs record an entry each time a user attempts to access an application. Each log entry contains the IP address used to make the attempt and the country from which the attempt originated. You need to receive notifications when an IP address from outside of the United States is used to access the application. Solution: Create a consumer and a broker. Create a file import process to send messages. Run the producer. Does this meet the goal? A. Yes B. No Answer: B QUESTION 25 You have an Apache Spark cluster in Azure HDInsight. You plan to join a large table and a lookup table. You need to minimize data transfers during the join operation. What should you do? A. Use the reduceByKey function. B. Use a Broadcast variable. C. Repartition the data. D. Use the DISK_ONLY storage level. Answer: B Explanation: QUESTION 26 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 have an initial dataset that contains the crime data from major cities. You plan to build training models from the training data. You plan to automate the process of adding more data to the training models and to constantly tune the models by using the additional data, including data that is collected in near real-time. The system will be used to analyze event data gathered from many different sources, such as Internet of Things (IoT) devices, live video surveillance, and traffic activities, and to generate predictions of an increased crime risk at a particular time and place. You have an incoming data stream from Twitter and an incoming data stream from Facebook,