70-475 Exam Questions

Which technology should you recommend to meet the technical requirement for analyzing the social media data?

Users report that when they access data that is more than one year old from a dashboard, the response time is slow. You need to resolve the issue that causes the slow response when...

You need to recommend a data handling solution to support the planned changes to the dashboard. The solution must meet the privacy requirements. What is the best recommendation to...

You need to recommend a data transfer solution to support the business goals. What should you recommend?

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

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 go...

You have structured data that resides in Microsoft Azure Blob Storage. You need to perform a rapid interactive analysis of the data and to generate visualizations of the data. What...

Your company has thousands of Internet-connected sensors. You need to recommend a computing solution to perform a real-time analysis of the data generated by the sensors. Which com...

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 q...

A company named Fabrikam, Inc. has a Microsoft Azure web app. Billions of users visit the app daily. The web app logs all user activity by using text files in Azure Blob storage. E...

You have a Microsoft Azure Data Factory pipeline. You discover that the pipeline fails to execute because data is missing. You need to rerun the failure in the pipeline. Which cmdl...

You are designing a solution that will use Apache HBase on Microsoft Azure HDInsight. You need to design the row keys for the database to ensure that client traffic is directed ove...

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?

You need to recommend a platform architecture for a big data solution that meets the following requirements: - Supports batch processing - Provides a holding area for a 3-petabyte...

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. NO...

You are designing an Apache HBase cluster on Microsoft Azure HDInsight. You need to identify which nodes are required for the cluster. Which three nodes should you identify? Each c...

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

Your company has two Microsoft Azure SQL databases named db1 and db2. You need to move data from a table in db1 to a table in db2 by using a pipeline in Azure Data Factory. You cre...

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 q...

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 q...

You have a Microsoft Azure subscription that contains an Azure Data Factory pipeline. You have an RSS feed that is published on a public website. You need to configure the RSS feed...

You have an Apache Storm cluster. The cluster will ingest data from a Microsoft Azure event hub. The event hub has the characteristics described in the following table. You are des...

You are designing an Internet of Things (IoT) solution intended to identify trends. The solution requires the real-time analysis of data originating from sensors. The results of th...

You are designing an Azure Data Lake managed cluster for your organization's realtime data processing. The streaming data could range from 10 MB to 100 GB per message. You need to...

You are creating an Azure Machine Learning experiment to predict the types of music your new customers will consume based on historical data about previous clients' music preferenc...

You are creating a Data Factory workflow. The workflow must run a stored procedure from a SQL database, perform a Hive query, and copy data from an on-premises SQL database into an...

Your app uses an Azure File Share. The app must be able to list, view, and modify files, but it cannot delete them. The app must set the permissions to expire one day in the future...

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 q...

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 q...

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 q...

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 q...

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 q...

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 q...

You have a Microsoft Azure data factory. You assign administrative roles to the users in the following table. You discover that several new data factory instances were created. You...

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 tw...

Your company supports multiple Microsoft Azure subscriptions. You plan to deploy several virtual machines to support the services in Azure. You need to automate the management of a...

The settings used for slice processing are described in the following table. If the slice processing fails, you need to identify the number of retries that will be performed before...

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

You have a Microsoft Azure Machine Learning Solution that contains several Azure Data Factory pipeline jobs. You discover that the jobs for a dataset named CustomerSalesData fails....

You have a data warehouse that contains the sales data of several customers. You plan to deploy a Microsoft Azure data factory to move additional sales data to the data warehouse....

You have an Apache Hadoop system that contains 5 TB of data. You need to create queries to analyze the data in the system. The solution must ensure that the queries execute as quic...

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 document...

You have a Microsoft Azure Machine Learning application named App1 that is used by several departments in your organization. App 1 connects to an Azure database named DB1. DB1 cont...

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

You are building a streaming data analysis solution that will process approximately 1 TB of data weekly. You plan to use Microsoft Azure Stream Analytics to create alerts on real-t...

A company named Fabrikam, Inc. plans to monitor financial markets and social networks, and then to correlate global stock movements to social network activity. You need to recommen...

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 th...

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 requiremen...

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 ca...

You are developing a solution to ingest data in real-time from manufacturing sensors. The data will be archived. The archived data might be monitored after it is written. You need...