Microsoft 70-775 Online Practice Questions and Exam Preparation

Microsoft 70-775 Online Questions & Answers

• Question 21:

  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.

  Select and Place:

  

  

• Question 22:

  You are configuring the Hive views on an Azure HDInsight cluster that is configured to use Kerberos.

  You plan to use the YARN logs to troubleshoot a query that runs against Apache Hadoop.

  You need to view the method, the service, and the authenticated account used to run the query.

  Which method call should you view in the YARN logs?

  A. HQL
  B. WebHDFS
  C. HDFS C* API
  D. Ambari RESR API
  D. Ambari RESR API

• Question 23:

  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
  C. an Azure Data Lake Store account by using the Azure portal

• Question 24:

  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 are implementing a batch processing solution by using Azure HDInsight.

  You have a table that contains sales data.

  You plan to implement a query that will return the number of orders by zip code.

  You need to minimize the execution time of the queries and to maximize the compression level of the resulting data.

  What should you do?

  A. Use a shuffle join in an Apache Hive query that stores the data in a JSON format.
  B. Use a broadcast join in an Apache Hive query that stores the data in an ORC format.
  C. Increase the number of spark.executor.cores in an Apache Spark job that stores the data in a text format.
  D. Increase the number of spark.executor.instances in an Apache Spark job that stores the data in a text format.
  E. Decrease the level of parallelism in an Apache Spark job that stores the data in a text format.
  F. Use an action in an Apache Oozie workflow that stores the data in a text format.
  G. Use an Azure Data Factory linked service that stores the data in Azure Data Lake.
  H. Use an Azure Data Factory linked service that stores the data in an Azure DocumentDB database.
  B. Use a broadcast join in an Apache Hive query that stores the data in an ORC format.

• Question 25:

  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
  A. ORC

• Question 26:

  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 are implementing a batch processing solution by using Azure HDInsight.

  You plan to import 300 TB of data.

  You plan to use one job that has many concurrent tasks to import the data in memory.

  You need to maximize the amount of concurrent tasks for the job.

  What should you do?

  A. Use a shuffle join in an Apache Hive query that stores the data in a JSON format.
  B. Use a broadcast join in an Apache Hive query that stores the data in an ORC format.
  C. Increase the number of spark.executor.cores in an Apache Spark job that stores the data in a text format.
  D. Increase the number of spark.executor.instances in an Apache Spark job that stores the data in a text format.
  E. Decrease the level of parallelism in an Apache Spark job that stores the data in a text format.
  F. Use an action in an Apache Oozie workflow that stores the data in a text format.
  G. Use an Azure Data Factory linked service that stores the data in Azure Data Lake.
  H. Use an Azure Data Factory linked service that stores the data in an Azure DocumentDB database.
  C. Increase the number of spark.executor.cores in an Apache Spark job that stores the data in a text format.

• Question 27:

  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
  C. the Hive ORC library is imported to Spark and the ORC-formatted data stored in Apache Hive tables becomes accessible

• Question 28:

  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
  C. Apache Storm and Apache HBase

• Question 29:

  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 are implementing a batch processing solution by using Azure HDInsight.

  You have data stored in Azure.

  You need to ensure that you can access the data by using Azure Active Directory (Azure AD) identities.

  What should you do?

  A. Use a shuffle join in an Apache Hive query that stores the data in a JSON format.
  B. Use a broadcast join in an Apache Hive query that stores the data in an ORC format.
  C. Increase the number of spark.executor.cores in an Apache Spark job that stores the data in a text format.
  D. Increase the number of spark.executor.instances in an Apache Spark job that stores the data in a text format.
  E. Decrease the level of parallelism in an Apache Spark job that stores the data in a text format.
  F. Use an action in an Apache Oozie workflow that stores the data in a text format.
  G. Use an Azure Data Factory linked service that stores the data in Azure Data Lake.
  H. Use an Azure Data Factory linked service that stores the data in an Azure DocumentDB database.
  G. Use an Azure Data Factory linked service that stores the data in Azure Data Lake.

• Question 30:

  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 analysts can query the logistics data by using JDBC APIs and SQL APIs.

  Which technology should you implement?

  A. Apache Phoenix
  B. Apache Spark
  C. Apache Storm
  D. Apache Hive
  A. Apache Phoenix