In this task, we are going to use derived columns transformation in Azure Data Factory to split a column into 2 columns. We have a container demo-data with a csv file !(/assets/img/posts/dataflow...

In this task, we are going to use conditional split in Azure Data Factory to split the data in a Persons table present in Azure SQL Database to split the data based on the age column. Persons who ...

In this task, we are going to flatten the json file stored in a Container in our storage account. In the json file, the data is an array of arrays, so we are going to flatten it to individual reco...

Understanding how to enable security for Azure Data Lake. The security model in Azure Data Lake Storage supports both RBAC and ACLs. Azure role assignments are evaluated first. They take priority ...

Understanding how to configure a hierarchical namespace for Azure Data Lake. 1. Create a storage account Enable the hierarchical namespace to create a Data Lake Quick question: You plan t...

Understanding how to create a resource lock in Azure. Configure a resource lock Task 1: Create a resource Create a storage account. Setting Value Reso...

In this exercise, you use the Pricing calculator to estimate the cost of running a basic web application on Azure. Define your requirements For a basic web application hosted in your datacenter, y...

In this exercise, you use the Total Cost of Ownership (TCO) Calculator to compare the cost of running a sample workload in your datacenter versus on Azure. Assume you’re considering moving some of...

Understanding and implementing Azure VM Creating an Azure virtual machine Task: Create a Linux VM and install Nginx (a pupular web server) In the terminal, use the command “az” to use Azure CLI ...

Revising sampling distribution concept in statistics. What is Sampling Distribution? Sampling is the process of creating samples from a larger population. The distribution of these samples bas...