1 BUSI 653 Project Part 2 Problem Statement The Registrar's Office at UCW has many services. They are working with different datasets daily. They are looking for a cloud-based data analytic environment to ingest, store, and process their datasets using Azure. In the first phase of this project, they asked your team to provide management-level consulting and practitioner-level implementation services for them 2 They are looking for the following Data Analysis Environment. Fig. 1: Data Analysis Environment for the registrar's office. They would like a report for consulting, designing, and implementing the mentioned environment using the following structure. 1- Solution Deployment 2- Solution Suggestion 3 Please follow these guidelines to prepare their report 1- Solution Deployment Please complete the following tables for their department. Table 4: Data Landing Zone Row Service in Fig 1 Screenshot ARM template link 1 1 2 2.1, 2.2, 2.3 3 3 4 4 5 5 Row 1: Please store the dataset that you used in part 1 of your project in the storage account. Share the screenshot and the exported template. Row 2: Please reimplement your ETL pipeline Project - Part1. Share the screenshot and the exported template. Row 3: Please add containers and folders in the storage account with the appropriate structure. Share the screenshot and exported template. Row 4: Please implement a purview service to scan your dataset in the storage account (row 1) to find sensitive information. Share the screenshot of the result. Row 5: Please implement a DevOps service and connect it to your ETL pipeline. Create a separate branch for each step of your ETL. Note: Please provide explanations for each row. 4 2- Solution Suggestion Please review the following materials and suggest how UCW can use the following services. 2-1 Cost management services suggestion Describe cost management in Azure Suggestion: 2-2 Monitoring services suggestion Describe monitoring tools in Azure Suggestion: 2-3 Security services suggestion Describe Azure identity, access, and security Suggestion: 5 Please upload your report in Moodle. Please follow the following requirements and rubrics for your report. 6

Attachments:

busi-653---pr....pdf