Microsoft 70-475 Online Practice Questions and Exam Preparation

Microsoft 70-475 Online Questions & Answers

• Question 51:

  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 an Apache Hadoop system.

  Does this meet the goal?

  A. Yes
  B. No
  A. Yes

• Question 52:

  A company named Fabrikam, Inc. has a web app. Millions of users visit the app daily.

  Fabrikam performs a daily analysis of the previous day's logs by scheduling the following Hive query.

  CREATE EXTERNAL TABLE IF NOT EXISTS UserActivity (...) Partitioned BY (LogDate string) Location MSCK REPAIR TABLE UserActivity; Select ... From UserActivity where LogDate = "{date}";

  You need to recommend a solution to gather the log collections from the web app.

  What should you recommend?

  A. Generate a single directory that contains multiple files for each day. Name the file by using the syntax of {date}_{randomsuffix}.txt.
  B. Generate a directory that is named by using the syntax of "LogDate={date}" and generate a set of files for that day.
  C. Generate a directory each day that has a single file.
  D. Generate a single directory that has a single file for each day.
  B. Generate a directory that is named by using the syntax of "LogDate={date}" and generate a set of files for that day.

  ---

  By default, all the data files for a table are located in a single directory. Partitioning is a technique for physically dividing the data during loading, based on values from one or more columns, to speed up queries that test those columns. References: https://www.cloudera.com/documentation/enterprise/5-8-x/topics/impala_partitioning.html#partitioning

• Question 53:

  You have a Microsoft Azure Stream Analytics job that contains several pipelines.

  The Stream Analytics job is configured to trigger an alert when the sale of products in specific categories exceeds a specified threshold.

  You plan to change the product-to-category mappings next month to meet future business requirements.

  You need to create the new product-to-category mappings to prepare for the planned change. The solution must ensure that the Stream Analytics job only uses the new product-to-category mappings when the mappings are ready to be

  activated.

  Which naming structure should you use for the file that contains the product-to-category mappings?

  A. Use any date after the day the file becomes active.
  B. Use any date before the day the categories become active.
  C. Use the date and hour that the categories are to become active.
  D. Use the current date and time.
  C. Use the date and hour that the categories are to become active.

• Question 54:

  You are designing a solution based on the lambda architecture.

  You need to recommend which technology to use for the serving layer.

  What should you recommend?

  A. Apache Storm
  B. Kafka
  C. Microsoft Azure DocumentDB
  D. Apache Hadoop
  C. Microsoft Azure DocumentDB

  ---

  The Serving Layer is a bit more complicated in that it needs to be able to answer a single query request against two or more databases, processing platforms, and data storage devices. Apache Druid is an example of a cluster-based tool that can marry the Batch and Speed layers into a single answerable request.

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

• Question 55:

  DRAG DROP

  You need to create a new Microsoft Azure data factory by using Azure PowerShell. The data factory will have a pipeline that copies data to and from Azure Storage.

  Which four cmdlets should you use in sequence? To answer, move the appropriate cmdlets from the list of cmdlets to the answer area and arrange them in the correct order.

  Select and Place:

  

  

  ---

  Perform these operations in the following order:

  1. Create a data factory.

  2. Create linked services.

  3. Create datasets.

  4. Create a pipeline.

  Step 1: New-AzureRMDataFactory

  Create a data factory

  The New-AzureRmDataFactory cmdlet creates a data factory with the specified resource group name and location.

  Step 2: New-AzureRMDataFactoryLinkedService

  Create linked services in a data factory to link your data stores and compute services to the data factory.

  The New-AzureRmDataFactoryLinkedService cmdlet links a data store or a cloud service to Azure Data Factory.

  Step 3: New-AzureRMDataFactoryDataset

  You define a dataset that represents the data to copy from a source to a sink. It refers to the Azure Storage linked service you created in the previous step.

  The New-AzureRmDataFactoryDataset cmdlet creates a dataset in Azure Data Factory.

  Step 4: New-AzureRMDataFactoryPipeline

  You create a pipeline.

  The New-AzureRmDataFactoryPipeline cmdlet creates a pipeline in Azure Data Factory.

  References:

  https://docs.microsoft.com/en-us/azure/data-factory/quickstart-create-data-factory-powershell

  https://docs.microsoft.com/en-us/powershell/module/azurerm.datafactories/new-azurermdatafactory

• Question 56:

  Your company has thousands of Internet-connected sensors.

  You need to recommend a computing solution to perform a real-time analysis of the date generated by the sensors.

  Which computing solution should you include in the recommendation?

  A. Microsoft Azure Stream Analytics
  B. Microsoft Azure Notification Hubs
  C. Microsoft Azure Cognitive Services
  D. Microsoft Azure HDInsight HBase cluster
  D. Microsoft Azure HDInsight HBase cluster

  ---

  HDInsight HBase is offered as a managed cluster that is integrated into the Azure environment. The clusters are configured to store data directly in Azure Storage or Azure Data Lake Store, which provides low latency and increased elasticity in performance and cost choices. This enables customers to build interactive websites that work with large datasets, to build services that store sensor and telemetry data from millions of end points, and to analyze this data with Hadoop jobs. HBase and Hadoop are good starting points for big data project in Azure; in particular, they can enable real-time applications to work with large datasets.

  Reference: https://docs.microsoft.com/en-us/azure/hdinsight/hdinsight-hbase-overview https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-introduction

• Question 57:

  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 extend the dashboard of the health tracking application to summarize fields across several users.

  You need to recommend a file format for the activity data in Azure that meets 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. ORC
  B. TSV
  C. CSV
  D. JSON
  E. XML
  E. XML

  ---

  From scenario: 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.

  XML is a good file format for filtering and processing of fields.

• Question 58:

  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 have a Microsoft Azure subscription that includes Azure Data Lake and Cognitive Services.

  An administrator plans to deploy an Azure Data Factory.

  You need to ensure that the administrator can create the data factory.

  Solution: You add the user to the SQL DB Contributor role.

  Does this meet the goal?

  A. Yes
  B. No
  B. No

  ---

  You should use Data Factory Contributor role or the Owner Role instead.

  References: https://docs.microsoft.com/en-us/azure/data-factory/concepts-roles-permissions

• Question 59:

  DRAG DROP

  You plan to deploy Microsoft Azure HDInsight clusters for business analytics and data pipelines. The clusters must meet the following requirements:

  Business users must use a language that is similar to SQL.

  The authoring of data pipelines must occur in a dataflow language.

  You need to identify which language must be used for each requirement.

  Which languages should you identify? To answer, drag the appropriate languages to the correct requirements. Each language 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.

  Select and Place:

  

  

• Question 60:

  You are using a Microsoft Azure Data Factory pipeline to copy data to an Azure SQL database.

  You need to prevent the insertion of duplicate data for a given dataset slice.

  Which two actions should you perform? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. Set the External property to true.
  B. Add a column named SliceIdentifierColumnName to the output dataset.
  C. Set the SqlWriterCleanupScript property to true.
  D. Remove the duplicates in post-processing.
  E. Manually delete the duplicate data before running the pipeline activity.
  B. Add a column named SliceIdentifierColumnName to the output dataset.
  C. Set the SqlWriterCleanupScript property to true.