Microsoft 70-475 Online Practice Questions and Exam Preparation

Microsoft 70-475 Online Questions & Answers

• Question 21:

  DRAG DROP

  You have a web app that accepts user input, and then uses a Microsoft Azure Machine Learning model to predict a characteristic of the user.

  You need to perform the following operations:

  Track the number of web app users from month to month.

  Track the number of successful predictions made during the last minute.

  Create a dashboard showcasing the analytics for the predictions and the web app usage.

  Which lambda layer should you query for each operation? To answer, drag the appropriate layers to the correct operations. Each layer 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:

  

  

  ---

  Lambda architecture is a data-processing architecture designed to handle massive quantities of data by taking advantage of both batch- and stream-processing methods. This approach to architecture attempts to balance latency, throughput,

  and fault-tolerance by using batch processing to provide comprehensive and accurate views of batch data, while simultaneously using real-time stream processing to provide views of online data. The two view outputs may be joined before

  presentation

  Box 1: Speed

  The speed layer processes data streams in real time and without the requirements of fix-ups or completeness. This layer sacrifices throughput as it aims to minimize latency by providing real-time views into the most recent data.

  Box 2: Batch

  The batch layer precomputes results using a distributed processing system that can handle very large quantities of data. The batch layer aims at perfect accuracy by being able to process all available data when generating views.

  Box 3: Serving

  Output from the batch and speed layers are stored in the serving layer, which responds to ad-hoc queries by returning precomputed views or building views from the processed data.

  Reference: https://en.wikipedia.org/wiki/Lambda_architecture

• Question 22:

  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

  the others might not have a correct solution.

  After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

  You plan to implement a new data warehouse.

  You have the following information regarding the data warehouse:

  The first data files for the data warehouse will be available in a few days.

  Most queries that will be executed against the data warehouse are ad-hoc.

  The schemas of data files that will be loaded to the data warehouse change often.

  One month after the planned implementation, the data warehouse will contain 15 TB of data.

  You need to recommend a database solution to support the planned implementation.

  Solution: You recommend a Microsoft SQL server on a Microsoft Azure virtual machine.

  Does this meet the goal?

  A. Yes
  B. No
  B. No

• Question 23:

  HOTSPOT

  You are planning a solution that will have multiple data files stored in Microsoft Azure Blob storage every hour. Data processing will occur once a day at midnight only.

  You create an Azure data factory that has blob storage as the input source and an Azure HDInsight activity that uses the input to create an output Hive table.

  You need to identify a data slicing strategy for the data factory.

  What should you identify? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  

  ---

  Box 1: Daily

  Data processing will occur once a day at midnight only.

  Box 2: ../{Year}/{Month}/{Day}/{Hour}

• Question 24:

  HOTSPOT

  You plan to design a solution to gather data from 5,000 sensors that are deployed to multiple machines. The sensors generate events that contain data on the health status of the machines.

  You need to create a new Microsoft Azure event hub to collect the event data.

  Which command should you run? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  

  ---

  Set-AzureSBNameSpace

  Box 1: Add-Type -Path "C:\temp\Microsoft.ServiceBus.dll"

  Make sure to reference the latest version of the \Microsoft.ServiceBus.dll by using the Add-Type -Path command.

  Box 2: New-AzureSBNamespace -Name $Namespace -NameSpaceType Messaging

  To create a new Azure Service Bus namespace you can use the New-AzureSBNamespace PowerShell cmdlet

  Box 3: Get-AzureSBNamespace -Name $Namespace -NameSpaceType Messaging

  Example:

  Write-Output "Creating the [$Namespace] namespace in the [$Location] region..."

  New-AzureSBNamespace -Name $Namespace -Location $Location -CreateACSNamespace $CreateACSNamespace -NamespaceType Messaging

  $CurrentNamespace = Get-AzureSBNamespace -Name $Namespace

  Write-Host "The [$Namespace] namespace in the [$Location] region has been successfully created."

  Box 4: New-Object -TypeName Microsoft.ServiceBus.Messaging.EventHubDescription

  References:

  https://blogs.msdn.microsoft.com/paolos/2014/12/01/how-to-create-a-service-bus-namespace-and-an-event-hub-using-a-powershell-script/

• Question 25:

  HOTSPOT

  You have the following Hive query.

  CREATE TABLE UserVisits (username string, urlvisited string, time date);

  LOAD DATA INPATH `wasb:///Logs' OVERWRITE INTO TABLE UserVisits;

  Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the script.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  

  ---

  Box 1: moves the contents of Logs to the UserVisits table directory

  The LOAD DATA statement streamlines the ETL process for an internal Impala table by moving a data file or all the data files in a directory from an HDFS location into the Impala data directory for that table.

  Box 2: Managed

  The default kind of table produced by the CREATE TABLE statement is known as an internal table. (Its counterpart is the external table, produced by the CREATE EXTERNAL TABLE syntax.). Internal tables are managed by Impala, and use directories inside the designated Impala work area.

  References:

  https://www.cloudera.com/documentation/enterprise/5-2-x/topics/impala_load_data.html

  https://www.cloudera.com/documentation/enterprise/5-8-x/topics/impala_tables.html#tables

• Question 26:

  You need to automate the creation of a new Microsoft Azure data factory.

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

  NOTE: Each correct selection is worth one point.

  A. Azure PowerShell cmdlets
  B. the SOAP service
  C. T-SQL statements
  D. the REST API
  E. the Microsoft .NET Framework class library
  A. Azure PowerShell cmdlets
  D. the REST API
  E. the Microsoft .NET Framework class library

  ---

  You can create a pipeline with a copy activity that moves data to/from an Azure Table Storage by using different tools/APIs.

  The easiest way to create a pipeline is to use the Copy Wizard. See Tutorial: Create a pipeline using Copy Wizard for a quick walkthrough on creating a pipeline using the Copy data wizard. You can also use the following tools to create a

  pipeline: Azure portal, Visual Studio, Azure PowerShell, Azure Resource Manager template, .NET API, and REST API.

  Reference: https://docs.microsoft.com/en-us/azure/data-factory/data-factory-azure-table-connector

• Question 27:

  Your company builds hardware devices that contains sensors.

  You need to recommend a solution to process the sensor data and to write back configuration changes to the devices.

  What should you include in the recommendation?

  A. Microsoft Azure Event Hubs
  B. API apps in Microsoft Azure App Service
  C. Microsoft Azure Notification Hubs
  D. Microsoft Azure IoT Hub
  D. Microsoft Azure IoT Hub

  ---

  IoT Hub is a managed service, hosted in the cloud, that acts as a central message hub for bi-directional communication between your IoT application and the devices it manages.

  Configure and control your devices. You can manage your devices connected to IoT Hub with an array of built-in functionality.

  Store, synchronize, and query device metadata and state information for all your devices.

  Set device state either per-device or based on common characteristics of devices.

  Automatically respond to a device-reported state change with message routing integration.

  References:

  https://docs.microsoft.com/en-us/azure/iot-hub/about-iot-hub

• Question 28:

  DRAG DROP

  You have a Microsoft Azure HDInsight cluster for analytics workloads. You have a C# application on a local computer. You plan to use Azure Data Factory to run the C# application in Azure.

  You need to create a data factory that runs C# application by using HDInsight.

  In which order should you perform the actions? To answer, move all actions from the list of actions to the answer area and arrange them in the correct order. NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.

  Select and Place:

  

  

  ---

  Step 1: Derive the C# class from the IDotNetActivity interface

  Step 2: Implement the Execute method of the IDotNetActivity interface.

  Implement (Add) the Execute method of the IDotNetActivity interface to the MyDotNetActivity class

  Step 3: Build the C# application in Microsoft Visual Studio

  Compile the project. Click Build from the menu and click Build Solution.

  Step 4: Zip the build files and upload the ZIP file to an Azure storage account.

  Create a zip file MyDotNetActivity.zip that contains all the binaries in the project folder. Include the MyDotNetActivity.pdb file so that you get additional details such as line number in the source code that caused the issue if there was a failure.

  Step 5: Create a pipeline..

  You have created a custom activity and uploaded the zip file with binaries to a blob container in a general-purpose Azure Storage Account. Now you create an Azure data factory with a pipeline that uses the custom activity.

  References:

  https://github.com/MicrosoftDocs/azure-docs/blob/master/articles/data-factory/v1/data-factory-use-custom-activities.md

• Question 29:

  HOTSPOT

  You have a pipeline that contains an input dataset in Microsoft Azure Table Storage and an output dataset in Azure Blob storage. You have the following JSON data.

  

  Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the JSON data. NOTE: Each correct selection is worth one point.

  Hot Area:

  

  

  ---

  Box 1: Every three days at 10.00

  anchorDateTime defines the absolute position in time used by the scheduler to compute dataset slice boundaries.

  "frequency": "",

  "interval": "

  Box 2: Every minute up to three times.

  retryInterval is the wait time between a failure and the next attempt. This setting applies to present time. If the previous try failed, the next try is after the retryInterval period.

  Example: 00:01:00 (1 minute)

  Example: If it is 1:00 PM right now, we begin the first try. If the duration to complete the first validation check is 1 minute and the operation failed, the next retry is at 1:00 + 1min (duration) + 1min (retry interval) = 1:02 PM.

  For slices in the past, there is no delay. The retry happens immediately.

  retryTimeout is the timeout for each retry attempt.

  maximumRetry is the number of times to check for the availability of the external data.

  Reference: https://docs.microsoft.com/en-us/azure/data-factory/data-factory-create-datasets

• Question 30:

  DRAG DROP

  You have a financial model deployed to an application named finance1. The data from the financial model is stored in several data files.

  You need to implement a batch processing architecture for the financial model.

  You upload the data files and finance1 to a Microsoft Azure Storage account.

  Which three components should you create in sequence next? To answer, move the appropriate components from the list of components to the answer area and arrange them in the correct order.

  Select and Place:

  

  

  ---

  Create a Batch pool of compute nodes in your Batch account, a job to run the workload on the pool, and tasks in the job.

  The following diagram shows steps in a common Batch workflow, with a client application or hosted service using Batch to run a parallel workload.

  

  References: https://docs.microsoft.com/en-us/azure/batch/batch-technical-overview