You develop data engineering solutions for a company.
You need to deploy a Microsoft Azure Stream Analytics job for an IoT solution. The solution must:
* Minimize latency.
* Minimize bandwidth usage between the job and IoT device.
Which four 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.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

You develop data engineering solutions for a company.
A project requires an in-memory batch data processing solution.
You need to provision an HDInsight cluster for batch processing of data on Microsoft Azure.
How should you complete the PowerShell segment? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:
Box 1: New-AzStorageContainer
# Example: Create a blob container. This holds the default data store for the cluster.
New-AzStorageContainer `
-Name $clusterName `
-Context $defaultStorageContext
$sparkConfig = New-Object "System.Collections.Generic.Dictionary``2[System.String,System.String]"
$sparkConfig.Add("spark", "2.3")
Box 2: Spark
Spark provides primitives for in-memory cluster computing. A Spark job can load and cache data into memory and query it repeatedly. In-memory computing is much faster than disk-based applications than disk-based applications, such as Hadoop, which shares data through Hadoop distributed file system (HDFS).
Box 3: New-AzureRMHDInsightCluster
# Create the HDInsight cluster. Example:
New-AzHDInsightCluster `
-ResourceGroupName $resourceGroupName `
-ClusterName $clusterName `
-Location $location `
-ClusterSizeInNodes $clusterSizeInNodes `
-ClusterType $"Spark" `
-OSType "Linux" `
Box 4: Spark
HDInsight is a managed Hadoop service. Use it deploy and manage Hadoop clusters in Azure. For batch processing, you can use Spark, Hive, Hive LLAP, MapReduce.
References:
https://docs.microsoft.com/bs-latn-ba/azure/hdinsight/spark/apache-spark-jupyter-spark-sql-use-powershell
https://docs.microsoft.com/bs-latn-ba/azure/hdinsight/spark/apache-spark-overview

Comment: *

Name: *

Email: *

Verification: *

SIMULATION

Use the following login credentials as needed:
Azure Username: xxxxx
Azure Password: xxxxx
The following information is for technical support purposes only:
Lab Instance: 10277521
You plan to deploy an integration runtime named Runtime1 to an Azure virtual machine.
You need to create an Azure Data Factory V2, and then prepare the required Data Factory resources for App1.
To complete this task, sign in to the Azure portal.

• A.Step 1: Create an Azure Data Factory V2
  1. Go to the Azure portal.
  2. Select Create a resource on the left menu, select Analytics, and then select Data Factory.
  
  4. On the New data factory page, enter a name.
  5. For Subscription, select your Azure subscription in which you want to create the data factory.
  6. For Resource Group, use one of the following steps:
  
  
  7. For Version, select V2.
  8. For Location, select the location for the data factory.
  9. Select Create.
  10. After the creation is complete, you see the Data Factory page.
  Step 2: Setup of the Integration Runtime Runtime1
  High-level steps for creating a linked self-hosted IR
  1. In the self-hosted IR Runtime to be shared, click Connections and Grant permission to another Data Factory. .
  
  2. Select the data factory you just created.
  
  Note the resource ID of the self-hosted IR to be shared.
  
  3. In the data factory to which the permissions were granted, create a new self-hosted IR (linked) and enter the resource ID.
  
  
• B.Step 1: Create an Azure Data Factory V2
  1. Go to the Azure portal.
  2. Select Create a resource on the left menu, select Analytics, and then select Data Factory.
  
  4. On the New data factory page, enter a name.
  5. For Subscription, select your Azure subscription in which you want to create the data factory.
  6. For Resource Group, use one of the following steps:
  
  
  7. For Version, select V2.
  8. For Location, select the location for the data factory.
  9. Select Create.
  10. After the creation is complete, you see the Data Factory page.
  Step 2: Setup of the Integration Runtime Runtime1
  High-level steps for creating a linked self-hosted IR
  1. In the self-hosted IR Runtime to be shared, click Connections and Grant permission to another Data Factory. .
  
  2. Select the data factory you just created.
  Note the resource ID of the self-hosted IR to be shared.
  
  3. In the data factory to which the permissions were granted, create a new self-hosted IR (linked) and enter the resource ID.
  

Comment: *

Name: *

Email: *

Verification: *

Note: This question is part of series of questions that present the same scenario. Each question in the series contain a unique solution. Determine whether the solution meets the stated goals.
You develop a data ingestion process that will import data to a Microsoft Azure SQL Data Warehouse. The data to be ingested resides in parquet files stored in an Azure Data Lake Gen 2 storage account.
You need to load the data from the Azure Data Lake Gen 2 storage account into the Azure SQL Data Warehouse.
Solution:
1. Use Azure Data Factory to convert the parquet files to CSV files
2. Create an external data source pointing to the Azure storage account
3. Create an external file format and external table using the external data source
4. Load the data using the INSERT...SELECT statement
Does the solution meet the goal?

• A.Yes
• B.No

Comment: *

Name: *

Email: *

Verification: *

You have an Azure SQL database named DB1 in the Each US 2 region.
You need to build a secondary geo-replicated copy of DB1 in the West US region on a new server.
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.

Correct Answer:

Explanation:
Step 1: From the Geo-replication settings of DB1, select West US
The following steps create a new secondary database in a geo-replication partnership.
1. In the Azure portal, browse to the database that you want to set up for geo-replication.
2. (Step 1) On the SQL database page, select geo-replication, and then select the region to create the secondary database.
3. (Step 2-3) Select or configure the server and pricing tier for the secondary database.

Step 2: Create a target server and select a pricing tier
Step 3: On the secondary server, create logins that match the SIDs on the primary server.
Incorrect Answers:
Not log shipping: Replication is used.
References:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-active-geo-replication-portal

Comment: *

Name: *

Email: *

Verification: *