Microsoft 70-475 Online Practice Questions and Exam Preparation

Microsoft 70-475 Online Questions & Answers

• Question 91:

  You are designing an application that will perform real-time processing by using Microsoft Azure Stream Analytics.

  You need to identify the valid outputs of a Stream Analytics job.

  What are three possible outputs that you can use? Each correct answer presents a complete solution.

  NOTE: Each correct selection is worth one point.

  A. Microsoft Power BI
  B. Azure SQL Database
  C. a Hive table in Azure HDInsight
  D. Azure Blob storage
  E. Azure Redis Cache
  A. Microsoft Power BI
  B. Azure SQL Database
  D. Azure Blob storage

  ---

  References: https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-define-outputs

• Question 92:

  Overview:

  Litware, Inc. is a company that manufactures personal devices to track physical activity and other health-related data.

  Litware has a health tracking application that sends health-related data from a user's personal device to Microsoft Azure.

  Litware has three development and commercial offices. The offices are located in the United States, Luxembourg, and India.

  Litware products are sold worldwide. Litware has commercial representatives in more than 80 countries.

  Existing Environment:

  In addition to using desktop computers in all of the offices, Litware recently started using Microsoft Azure resources and services for both development and operations.

  Litware has an Azure Machine Learning solution.

  Litware recently extended its platform to provide third-party companies with the ability to upload data from devices to Azure. The data can be aggregated across multiple devices to provide users with a comprehensive view of their global

  health activity.

  While the upload from each device is small, potentially more than 100 million devices will upload data daily by using an Azure event hub. Each health activity has a small amount of data, such as activity type, start date/time, and end date/time.

  Each activity is limited to a total of 3 KB and includes a customer identification key.

  In addition to the Litware health tracking application, the users' activities can be reported to Azure by using an open API.

  The developers at Litware perform Machine Learning experiments to recommend an appropriate health activity based on the past three activities of a user.

  The Litware developers train a model to recommend the best activity for a user based on the hour of the day.

  Requirements:

  Litware plans to extend the existing dashboard features so that health activities can be compared between the users based on age, gender, and geographic region.

  Minimize the costs associated with transferring data from the event hub to Azure Storage.

  Litware identifies the following technical requirements:

  Data from the devices must be stored for three years in a format that enables the fast processing of date fields and filtering.

  The third-party companies must be able to use the Litware Machine Learning models to generate recommendations to their users by using a third-party application.

  Any changes to the health tracking application must ensure that the Litware developers can run the experiments without interrupting or degrading the performance of the production environment.

  Activity tracking data must be available to all of the Litware developers for experimentation. The developers must be prevented from accessing the private information of the users.

  When the Litware health tracking application asks users how they feel, their responses must be reported to Azure.

  You need to recommend a permanent Azure Storage solution for the activity data. The solution must meet the technical requirements.

  What is the best recommendation to achieve the goal? More than one answer choice may achieve the goal. Select the BEST answer.

  A. Azure SQL Database
  B. Azure Queue storage
  C. Azure Blob storage
  D. Azure Event Hubs
  A. Azure SQL Database

  ---

  From scenario: While the upload from each device is small, potentially more than 100 million devices will upload data daily by using an Azure event hub. Each health activity has a small amount of data, such as activity type, start date/time, and end date/time. Each activity is limited to a total of 3 KB and includes a customer identification key.

• Question 93:

  You are designing a solution for an Internet of Things (IoT) project.

  You need to recommend a data storage solution for the project. The solution must meet the following requirements:

  Allow data to be queried in real-time as it streams into the solution

  Provide the lowest amount of latency for loading data into the solution.

  What should you include in the recommendation?

  A. a Microsoft Azure SQL database that has In-Memory OLTP enabled
  B. a Microsoft Azure HDInsight Hadoop cluster
  C. a Microsoft Azure HDInsight R Server cluster
  D. a Microsoft Azure Table Storage solution
  A. a Microsoft Azure SQL database that has In-Memory OLTP enabled

  ---

  References: https://azure.microsoft.com/en-gb/blog/in-memory-oltp-in-azure-sql-database/

• Question 94:

  DRAG DROP

  You are automating the deployment of a Microsoft Azure Data Factory solution. The data factory will interact with a file stored in Azure Blob storage.

  You need to use the REST API to create a linked service to interact with the file.

  How should you complete the request body? To answer, drag the appropriate code elements to the correct locations. Each code may be used once, more than once, or not at all. You may need to drag the slit bar between panes or scroll to

  view content.

  NOTE: Each correct selection is worth one point.

  Select and Place:

  

  

• Question 95:

  DRAG DROP

  You plan to deploy a Microsoft Azure Data Factory pipeline to run an end-to-end data processing workflow.

  You need to recommend which Azure Data Factory features must be used to meet the following requirements:

  Track the run status of the historical activity.

  Enable alerts and notifications on events and metrics.

  Monitor the creation, updating, and deletion of Azure resources.

  Which features should you recommend? To answer, drag the appropriate features to the correct requirements. Each feature 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.

  Select and Place:

  

  

  ---

  Box 1: Azure Hdinsight logs Box 2: Azure Data Factory alerts Box 3: Azure Data Factory events

  Reference: https://docs.microsoft.com/en-us/azure/log-analytics/log-analytics-azure-storage

• Question 96:

  You are designing an Internet of Thing: (IoT) solution intended to identify trends. The solution requires the real-time analysis of data originating from sensors. The results of the analysis will be stored in a SQL database.

  You need to recommend a data processing solution that uses the Transact-SQL language.

  Which data processing solution should you recommend?

  A. Microsoft Azure Stream Analytics
  B. Microsoft SQL Server Integration Services (SSIS)
  C. Microsoft Azure Machine Learning
  D. Microsoft Azure HDInsight Hadoop clusters
  A. Microsoft Azure Stream Analytics

• Question 97:

  You have a web application that generates several terabytes (TB) of financial documents each day. The application processes the documents in batches.

  You need to store the documents in Microsoft Azure. The solution must ensure that a user can restore the previous version of a document.

  Which type of storage should you use for the documents?

  A. Azure Cosmos DB
  B. Azure File Storage
  C. Azure Data Lake
  D. Azure Blob storage
  A. Azure Cosmos DB

• Question 98:

  DRAG DROP

  You plan to deploy a storage solution to store the output of stream analytics.

  You plan to store the data for the following three types of data streams: Unstructured JSON data Exploratory analytics Pictures

  You need to implement a storage solution for the data stream types.

  Which storage solution should you implement for each data stream type? To answer, drag the appropriate storage solutions to the correct data stream types. Each storage solution may be used once, more than once, or not at all. You may need to drag the split bar between the panes or scroll to view content.

  NOTE: Each correct selection is worth one point.

  Select and Place:

  

  

  ---

  Box 1: Azure Data Lake Store

  Stream Analytics supports Azure Data Lake Store. Azure Data Lake Store is an enterprise-wide hyper-scale repository for big data analytic workloads. Data Lake Store enables you to store data of any size, type and ingestion speed for

  operational and exploratory analytics. Stream Analytics has to be authorized to access the Data Lake Store.

  Box 2: Azure Cosmos DB

  Stream Analytics can target Azure Cosmos DB for JSON output, enabling data archiving and low-latency queries on unstructured JSON data.

  Box 3: Azure Blob Storage

  Blob storage offers a cost-effective and scalable solution for storing large amounts of unstructured data in the cloud.

  Incorrect Asnwers:

  Azure SQL Database:

  Azure SQL Database can be used as an output for data that is relational in nature or for applications that depend on content being hosted in a relational database. Stream Analytics jobs write to an existing table in an Azure SQL Database.

  Azure Service Bus Queue:

  Service Bus Queues offer a First In, First Out (FIFO) message delivery to one or more competing consumers. Typically, messages are expected to be received and processed by the receivers in the temporal order in which they were added to

  the queue, and each message is received and processed by only one message consumer.

  Azure Table Storage

  Azure Table storage offers highly available, massively scalable storage, so that an application can automatically scale to meet user demand. Table storage is Microsoft's NoSQL key/attribute store, which one can leverage for structured data

  with fewer constraints on the schema. Azure Table storage can be used to store data for persistence and efficient retrieval.

  References: https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-define-outputs

• Question 99:

  HOTSPOT

  You have a Microsoft Azure Stream Analytics solution.

  You need to identify which types of windows must be used to group the following types of events:

  Events that have random time intervals and are captured in a single fixed-size window

  Events that have random time intervals and are captured in overlapping windows

  Which window type should you identify for each event type? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  

  ---

  Box 1. A sliding Window

  Box 2: A sliding Window

  With a Sliding Window, the system is asked to logically consider all possible windows of a given length and output events for cases when the content of the window actually changes ?that is, when an event entered or existed the window.

  Reference: https://blogs.technet.microsoft.com/machinelearning/2015/06/01/the-azure-stream-analytics-query-language/

• Question 100:

  You have data pushed to Microsoft Azure Blob storage every few minutes.

  You want to use an Azure Machine Learning web service to score the data hourly.

  You plan to deploy the data factory pipeline by using a Microsoft.NET application.

  You need to create an output dataset for the web service.

  Which three properties should you define? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. Source
  B. LinkedServiceName
  C. TypeProperties
  D. Availability
  E. External
  A. Source
  B. LinkedServiceName
  C. TypeProperties