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 the analysis will be stored in a SQL database.You need to recommend a data processing solution that uses the Transact-SQL language.Which data processing solution should you recommend?
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 as a data source for the pipeline.Which type of linked service should you use?
DRAG DROP -You manage a Microsoft Azure HDInsight Hadoop cluster. All of the data for the cluster is stored in Azure Premium Storage.You need to prevent all users from accessing the data directly. The solution must allow only the HDInsight service to access the data.Which five actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.Select and Place:
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 designing the Storm application topology.You need to ingest data from all of the partitions. The solution must maximize the throughput of the data ingestion.Which setting should you use?
DRAG DROP -Your company has a Microsoft Azure environment that contains an Azure HDInsight Hadoop cluster and an Azure SQL data warehouse. The Hadoop cluster contains text files that are formatted by using UTF-8 character encoding.You need to implement a solution to ingest the data to the SQL data warehouse from the Hadoop cluster. The solution must provide optimal read performance for the data after ingestion.Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.Select and Place:
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?
