DRAG DROP You have data in an on-premises Microsoft SQL Server database. You must ingest the data in Microsoft Azure Blob Storage from the on-premises SQL Server database by using Azure Data Factory. You need to identify which tasks must…
DRAG DROP You have raw data in Microsoft Azure Blob storage. Each data file is 10 KB and is the XML format. • You identify the following requirements for the data: • The data must be converted into a flat…
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…
Overview: Relecloud is a social media company that processes hundreds of millions of social media posts per day and sells advertisements to several hundred companies. Relecloud has a Microsoft SQL Server database named DB1 that stores information about the advertisers.…
DRAG DROP You are creating a retail analytics system for a company that manufactures equipment. The company manufactures thousands of IoT devices that report their status over the Internet. You need to recommend a solution to visualize notifications from the…
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…
HOTSPOT Your company has several thousand sensors deployed. You have a Microsoft Azure Stream Analytics job that receives two data streams Input1 and Input2 from an Azure event hub. The data streams are portioned by using a column named SensorName.…
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…
A company named Fabricam, Inc, has a web app hosted in Microsoft Azure. Millions of users visit the app daily. All of the user visits are logged in Azure Blob storage. Data analysts at Fabrikam built a dashboard that processes…
HOTSPOT Overview: Relecloud is a social media company that processes hundreds of millions of social media posts per day and sells advertisements to several hundred companies. Relecloud has a Microsoft SQL Server database named DB1 that stores information about the…