Question

$1$

: Short Answer

$($

$2$

$0$

$$Marks

$)$

I. Briefly describe the benefits of migrating on

$-$

premises databases to Azure SQL Database.

$($

$1$

$0$

marks

$)$

II

$.$

$$Explain two key security best practices for managing Azure SQL databases.

$($

$1$

$0$

$$marks

$)$

Question

$2$

: Plan and Implement Data Platform Resources

$($

$4$

$0$

$$Marks

$)$

$1$

$.$

$$Scenario

$-$

Based: Your company plans to develop a new customer relationship management

$($

CRM

$)$

application with strict data privacy regulations. Analyze this scenario and discuss:

$-$

I. Which Azure database service would you recommend, and why?

$($

$1$

$0$

$$marks

$)$

II

$.$

$$Which steps would you take to ensure data privacy and compliance?

$($

$1$

$0$

$$marks

$)$

III. Resource Comparison

$($

$1$

$0$

$$Marks

$)$

: Compare and contrast Azure SQL Database and Azure Cosmos

DB for storing and managing customer data in a CRM application, highlighting their key

advantages and disadvantages.

IV

$.$

$$Code Analysis

$($

$1$

$0$

$$Marks

$)$

: Given the following code snippet, explain its purpose and potential

implications:

Create Table CustomerData

$($

$$ CustomerID INT Primary Key,

$$ Name Varchar

$($

$5$

$0$

$)$

$,$

$$ Email Varchar

$($

$1$

$0$

$0$

$)$

$,$

$$ Phone Varchar

$($

$2$

$0$

$)$

$)$

;

Question

$3$

: Implement a Secure Environment

$($

$4$

$0$

$$Marks

$)$

I. Threat Identification

$($

$6$

$$Marks

$)$

: Identify and briefly explain three common security threats to

Azure SQL databases.

II

$.$

$$Security Mitigation: For each threat identified in question

$1$

$,$

$$describe a specific Azure security

feature or practice to mitigate it

$.$

$($

$1$

$0$

$$marks each

$)$

III. Auditing and Compliance

$($

$1$

$0$

$$Marks

$)$

: Explain the importance of auditing and compliance for

Azure

IV

$.$

$$Your company is developing a new business intelligence application requiring high performance

and scalability.

V

$.$

$$Which Azure database service would you recommend and why? Briefly explain two key features

of this service that address the application's requirements.

$($

$4$

$$Marks

$)$

VI

$.$

$$Compare and contrast two data partitioning strategies

$($

e

$.$

g

$.$

$,$

$$range$,$ hash

$)$

$$for large tables in Azure

SQL Database. Briefly explain the potential benefits and drawbacks of each strategy.

$($

$1$

$0$

$$Marks

$)$