Mlfacets free to share the latest Microsoft Certification 70-775 exam dumps and online downloads from
Microsoft certification 70-775 PDF from pass4itsure microsoft Exam Experts.
Pass4itsure.com not only provides practical Microsoft Certification 70-775 questions, but also provides a detailed answer, Pass4itsure.com is
the final source of preparation through the Microsoft Certification 70-775 Exam. Pass4itsure 70-775 PDF dumps! Welcome to download the newest
Pass4itsure 70-775 VCE dumps: https://www.pass4itsure.com/70-775.html (35 Q&As)
[PDF]Â Free Microsoft Certification 70-775 dumps download from Google Drive:
https://drive.google.com/open?id=1P4YH3eScmxZ3u84AE8E6S9bNfz5BqqRe
[PDF] Free full Microsoft dumps download from Google Drive:
https://drive.google.com/open?id=1VBDzuasBbmByXUKyUaZejR3hFzTke722
Exam 70-775: Perform Data Engineering on Microsoft Azure HDInsight:
https://www.microsoft.com/en-us/learning/exam-70-775.aspx
Pass4itsure offers the latest Microsoft Certification 70-775 practice test free of charge (14Q&As)
QUESTION 1
You have an Azure HDInsight cluster.
You need to store data in a file format that maximizes compression and increases read performance.
Which type of file format should you use?
A. ORC
B. Apache Parquet
C. Apache Avro
D. Apache Sequence
Correct Answer: A
Explanation
Explanation/Reference:
References: http://www.semantikoz.com/blog/orc-intelligent-big-data-file-format-hadoop- hive/
QUESTION 2
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series.
Information and details provided in a question apply only to that question.
You need to deploy an HDInsight cluster that will provide in-memory processing, interactive queries, and micro-batch stream processing. The cluster has the following requirements:
What should you do?
A. Use an Azure PowerShell script to create and configure a premium HDInsight cluster.
Specify Apache Hadoop as the cluster type and use Linux as the operating system.
B. Use the Azure portal to create a standard HDInsight cluster. Specify Apache Spark as the cluster type and use Linux as the operating system.
C. Use an Azure PowerShell script to create a standard HDInsight cluster. Specify Apache HBase as the cluster type and use Windows as the operating system.
D. Use an Azure PowerShell script to create a standard HDInsight cluster. Specify Apache Storm as the cluster type and use Windows as the operating system.
E. Use an Azure PowerShell script to create a premium HDInsight cluster. Specify Apache HBase as the cluster type and use Linux as the operating system.
F. Use an Azure portal to create a standard HDInsight cluster. Specify Apache Interactive Hive as the cluster type and use Linux as the operating system.
G. Use an Azure portal to create a standard HDInsight cluster. Specify Apache HBase as the cluster type and use Linux as the operating system.
Correct Answer: B
Explanation
Explanation/Reference:
References: https://docs.microsoft.com/en-us/azure/hdinsight/hdinsight-apache-spark- overview
QUESTION 3
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:
The data sources in the batch layer share a common storage container. The following data sources are used:
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
Correct Answer: D
Explanation
Explanation/Reference:
References: https://docs.microsoft.com/en-us/azure/hdinsight/hdinsight-apache-spark-livy- rest-interface
QUESTION 4
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:
The data sources in the batch layer share a common storage container. The following data sources are used:
The business analysts report that they experience performance issues when they run the monitoring queries.
You troubleshoot the performance issues and discover that the intermediate tables generated when the analysts run the queries cause pressure for the Java Virtual Machine (JVM) garbage collection per job.
Which configuration settings should you modify to alleviate the performance issues?A. spark.sql.inMemoryColumnarStorage.batchSize
B. spark.sql.broadcastTimeout
C. spark.sql.files.openCostInBytes
D. spark.sql.shuffle.partitions
Correct Answer: D
Explanation
QUESTION 5
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, which are event-based only, rather than time-based. You also have a time interval stream every 10 seconds.
The data is in a key/value pair format. The value field represents a 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 for the various tasks associated to the processing pipeline.
You are planning a storage strategy for a large amount of analytic data used for the crime data analytics system. The initial data load involves over 100 billion records, and more than two billion records will be added daily.
You already created an Apache Hadoop cluster in HDInsight premium.
You need to implement the storage strategy to meet the following requirements:
What should you create?
A. a virtual machine (VM) by using the Data Science Virtual Machine template for Windows that has premium storage, a G-series size, and uses Microsoft SQL Server 2016 to store the data
B. an Azure Data Lake Analytics service by using Azure PowerShell
C. an Azure Data Lake Store account by using the Azure portal
D. an Azure Blob storage account by using the Azure portal
Correct Answer: C
Explanation
Explanation/Reference:
References: https://docs.microsoft.com/en-us/azure/data-lake-store/data-lake-store-get- started-portal
QUESTION 6
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
B. OXPS, binary, text and JSON
C. XML, Apache Avro, text, and ORC
D. text, JSON, Apache Avro, and Apache Parquet
Correct Answer: D
Explanation
Explanation/Reference:
References: https://docs.microsoft.com/en-us/azure/data-factory/supported-file-formats- and-compression-codecs
QUESTION 7
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 new topics. Create a file import process to send messages. Start the consumer and run the producer.
Does this meet the goal?
A. Yes
B. No
Correct Answer: A
Explanation
QUESTION 8
You have an Apache Spark cluster in Azure HDInsight.
You execute the following command
What is the result of running the command?
A. the Hive ORC library is imported to Spark and external tables in ORC format are created
B. the Spark library is imported and the data is loaded to an Apache Hive table
C. the Hive ORC library is imported to Spark and the ORC-formatted data stored in Apache Hive tables becomes accessible
D. the Spark library is imported and Scala functions are executed
Correct Answer: C
Explanation
QUESTION 9
DRAG DROP
You have an Apache Hive cluster in Azure HDInsight.
You need to tune a Hive query to meet the following requirements:
How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value 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.
Explanation
Explanation/Reference:
QUESTION 10
DRAG DROP
You are evaluating the use of Azure HDInsight clusters for various workloads.
Which type of HDInsight cluster should you create for each workload? To answer, drag the appropriate cluster types to the correct workloads. Each cluster type 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
Explanation
Explanation/Reference:
QUESTION 11
DRAG DROP
You have a text file named Data/examples/product.txt that contains product information.
You need to create a new Apache Hive table, import the product information to the table, and then read the top 100 rows of the table.
Which four code segments should you use in sequence? To answer, move the appropriate code segments from the list of code segments to the answer area and arrange them in the correct order
Explanation
Explanation/Reference:
QUESTION 12
DRAG DROP
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:
The data sources in the batch layer share a common storage container. The following data sources are used:
The business analysts require queries to monitor the sales data. The queries must be faster and more interactive than the batch layer queries.
You need to create a new infrastructure to support the queries. The solution must ensure that you can tune the cache policies of the queries.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Explanation/Reference:
QUESTION 13
DRAG DROP
You have an Apache HBase cluster in Azure HDInsight. The cluster has a table named sales that contains a column family named customerfamily.
You need to add a new column family named customeraddr to the sales table.
How should you complete the command? To answer, drag the appropriate values to the correct targets. Each value 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.
Explanation
Explanation/Reference:
QUESTION 14
DRAG DROP
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 targets. 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.
Explanation
Explanation/Reference:
Summarize:Mlfacets free to share the latest Microsoft Certification 70-775 exam dumps and online downloads
from Microsoft certification 70-775 PDF from pass4itsure microsoft Exam Experts.
Download Latest Microsoft Certification 70-775 VCE Dumps From Pass4itsure: https://www.pass4itsure.com/70-775.html
(Exam databases are regularly updated throughout the year to include the latest questions and answers from the microsoft 70-775 exam)
[PDF] Free Microsoft Certification 70-775 dumps download from Google Drive:
https://drive.google.com/open?id=1P4YH3eScmxZ3u84AE8E6S9bNfz5BqqRe
[PDF] Free full Microsoft dumps download from Google Drive:
https://drive.google.com/open?id=1VBDzuasBbmByXUKyUaZejR3hFzTke722
Pass4itsure Promo Code 15% Off
related: https://www.passpundit.com/2017/07/13/guaranteed-oracle-database-12c-1z0-068-dumps/