Microsoft 70-775 - Perform Data Engineering on Microsoft Azure HDInsight Exam

Page:    1 / 7   
Total 35 questions

You have a domain-joined Azure HDInsight cluster.
You plan to assign permissions to several support staff.
You need to assign roles to the staff so that they can perform specific tasks.
The solution must use the principle of least privilege.
Which role should you assign for each task? To answer, drag the appropriate roles to the correct tasks. Each role may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.




Answer :

You plan to copy data from Azure Blob storage to an Azure SQL database by using
Azure Data factory. Which file formats can you use?

  • A. binary, JSON, Apache Parquet, and ORC JSON
  • C. XML, Apache Avro, text, and ORC
  • D. text, JSON, Apache Avro, and Apache Parquet


Answer : A

You have on 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 : A

You are evaluating the use of Azure HDInsight clusters for various workloads.
Which type of HDInsight cluster should you create for each workloads?




Answer :

Explanation:
https://www.blue-granite.com/blog/how-to-choose-the-right-hdinsight-cluster

Note: This question is part of a series of questions that present the same Scenario.
Each question I 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 correct solution.
Start of Repeated Scenario:
initial data 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 training 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) increased crime risk at a particular time and ptace. incoming data stream from
Facebook. which are event-based only, rather than time-based. You also have a time interval stream every 10 seconds. number that defines how many times a hashtag occurs within a Facebook post or how many times a tweet that contains a specific hashtag is retweeted.
You must use the appropriate data storage, stream analytics techniques, and Azure
HDInsight cluster types tor the various tasks associated to the processing pipeline.
End of repeated Scenario.
You plan to consolidate all of the stream into a single timeline, even though none of the streams report events at the same interval.
You need to aggregate the data from the feeds to align with the time interval stream. The result must be the sim of all values for each within a 10 second interval, with the keys being the hashtags.
Which function should you use?

  • A. countByWindow
  • B. reduccByWindow
  • C. reduceByKeyAndWindow
  • D. countByValueAndWindow
  • E. updateStateByKey


Answer : C

Page:    1 / 7   
Total 35 questions