70-776 Exam Questions

You are building a Microsoft Azure Stream Analytics job definition that includes inputs, queries, and outputs. You need to create a job that automatically provides the highest leve...

You manage an on-premises data warehouse that uses Microsoft SQL Server. The data warehouse contains 100 TB of data. The data is partitioned by month. One TB of data is added to th...

You plan to use Microsoft Azure Data factory to copy data daily from an Azure SQL data warehouse to an Azure Data Lake Store. You need to define a linked service for the Data Lake...

You have a Microsoft Azure Data Lake Store and an Azure Active Directory tenant. You are developing an application that will access the Data Lake Store by using end-user credential...

You are developing an application that uses Microsoft Azure Stream Analytics. You have data structures that are defined dynamically. You want to enable consistency between the logi...

You need to use the Cognition.Vision.FaceDetector() function in U-SQL to analyze images. Which attribute can you detect by using the function?

You have a Microsoft Azure SQL data warehouse that contains information about community events. An Azure Data Factory job writes an updated CSV file in Azure Blob storage to Commun...

You have a Microsoft Azure Data Lake Analytics service. You need to write a U-SQL query to extract from a CSV file all the users who live in Boston, and then to save the results in...

You have an on-premises deployment of Active Directory named contoso.com. You plan to deploy a Microsoft Azure SQL data warehouse. You need to ensure that the data warehouse can be...

Note: This question is part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a diffe...

You have a Microsoft Azure SQL data warehouse. The following statements are used to define file formats in the data warehouse. You have an external PolyBase table named file_factPo...

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 plan to deploy a Microsoft Azure virtual machine that will a host data warehouse. The data warehouse will contain a 10-TB database. You need to provide the fastest read and wri...

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 fact table named PowerUsage that has 10 billion rows. PowerUsage contains data about customer power usage during the last 12 months. The usage data is collected every mi...

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 an extract, transformation, and load (ETL) process for a Microsoft Azure SQL data warehouse. You run the following statements to create the logon and user for an account t...

You have a Microsoft Azure Data Lake Analytics service. You plan to configure diagnostic logging. You need to use Microsoft Operations Management Suite (OMS) to monitor the IP addr...

You plan to add a file from Microsoft Azure Data Lake Store to Azure Data Catalog. You run the Data Catalog tool and select Data Lake Store as the data source. Which information sh...

You have a Microsoft Azure SQL data warehouse that has a fact table named FactOrder. FactOrder contains three columns named CustomerId, OrderId, and OrderDateKey. FactOrder is hash...

You need to define an input dataset for a Microsoft Azure Data Factory pipeline. Which properties should you include when you define the dataset?

You have a file in a Microsoft Azure Data Lake Store that contains sales data. The file contains sales amounts by salesperson, by city, and by state. You need to use U-SQL to calcu...

You have an on-premises data warehouse that uses Microsoft SQL Server 2016. All the data in the data warehouse comes from text files stored in Azure Blob storage. The text files ar...

You have a Microsoft Azure Data Factory that recently ran several activities in parallel. You receive alerts indicating that there are insufficient resources. From the Activity Win...

Note: This question is part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a diffe...

You are developing an application by using the Microsoft .NET SDK. The application will access data from a Microsoft Azure Data Lake folder. You plan to authenticate the applicatio...

You ingest data into a Microsoft Azure event hub. You need to export the data from the event hub to Azure Storage and to prepare the data for batch processing tasks in Azure Data L...

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

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 have a Microsoft Azure SQL data warehouse. You have an Azure Data Lake Store that contains data from ORC, RC, Parquet, and delimited text files. You need to load the data to th...

Note: This question is part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a diffe...

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 sensor devices that report data to Microsoft Azure Stream Analytics. Each sensor reports data several times per second. You need to create a live dashboard in Microsoft Po...

You have a Microsoft Azure SQL data warehouse that has 10 compute nodes. You need to export 10 TB of data from a data warehouse table to several new flat files in Azure Blob storag...

You plan to use Microsoft Azure Event Hubs to ingest sensor data. You plan to use Azure Stream Analytics to analyze the data in real time and to send the output directly to Azure D...

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 are using a Microsoft Azure Stream Analytics query language. You are outputting data from an input click stream. You need to ensure that when you consecutively receive two rows...

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

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 SQL data warehouse named DW1 that is used only from Monday to Friday. You need to minimize Data Warehouse Unit (DWU) usage during the weekend. What shoul...

You have a Microsoft Azure Data Lake Analytics service. You have a CSV file that contains employee salaries. You need to write a U-SQL query to load the file and to extract all the...

You have a Microsoft Azure Data Lake Analytics service and an Azure Data Lake Store. You need to use Python to submit a U-SQL job. Which Python module should you install?

You have a Microsoft Azure Data Lake Analytics service. You need to provide a user with the ability to monitor Data Lake Analytics jobs. The solution must minimize the number of pe...

You plan to use Microsoft Azure Event Hubs to ingest data. You plan to use Azure Stream Analytics to analyze the data in real time and to send the output directly to Azure Data Lak...

You have an on-premises Microsoft SQL Server instance. You plan to copy a table from the instance to a Microsoft Azure Storage account. You need to ensure that you can copy the tab...

You are using Cognitive capabilities in U-SQL to analyze images that contain different types of objects. You need to identify which objects might be people. Which two reference ass...