KasnebRevisions
Log inGet started
Papers in this syllabus

Paper 11

CLOUD DATA SOLUTIONS

Read study notes

This unit specifies competencies required to manage cloud data solutions. It enables the learner to identify key concepts of cloud computing, apply database solutions using Microsoft Azure, manage cloud database security and privacy and troubleshoot database implementation in Azure.

On completion, a candidate should be able to

  • Identify key concepts of cloud computing
  • Apply database solutions using Microsoft Azure
  • Manage cloud database security and privacy
  • Troubleshoot Database implementation in Azure

Content

  1. 1

    Identify key concepts of cloud computing

    Identify key concepts of cloud computing

    1. ❑ Definition of cloud computing ❑ Cloud computing service models ✓ Software as a service (saas) ✓ Platform as a service (PaaS) ✓ Infrastructure as a service (IaaS) ❑ Cloud deployment models ✓ Private cloud ✓ Public cloud ✓ Hybrid cloud ✓ Community cloud ❑ Characteristics of cloud computing ❑ Cloud computing technologies ✓ Virtualization ✓ Service-Oriented Architecture (SOA) ✓ Grid computing ✓ Utility Computing ❑ Advantages and disadvantages of Microsoft Azure Examples of cloud service providers

  2. 2

    Apply database solutions using Microsoft Azure

    Apply database solutions using Microsoft Azure

    1. Description of Microsoft Azure Uses of Microsoft Azure ✓ Virtual machines ✓ SQL databases ✓ Azure active directory Domain services ✓ Application services ✓ Visual studio team services ✓ Storage Components of Azure ✓ Compute ✓ Storage ✓ Database ✓ Security and authentication ✓ Networking ✓ Monitoring ✓ Web services ✓ Mobile services Use Azure Functions Azure Storage Account ✓ The need for Azure Storage account ✓ creating an Azure Storage Account Types of Azure Storage account Azure SQL Database ✓ Deployment models - Single database - Elastic pool - Database server ✓ Scalable performance and pools Logical SQL server in Azure SQL Database Azure Synapse Manage servers, databases, and firewalls using the Azure portal SQL Server on Azure Virtual Machines Azure SQL managed instance

  3. 3

    Manage cloud database security and privacy

    Manage cloud database security and privacy

    1. Azure SQL Server Data base security issues ✓ Network security - Firewall ✓ Access management - Authentication and Authorization - Row-level security ✓ Threat protection - SQL auditing in Azure Monitor logs and event hubs - Information protection and encryption - Key management with Azure key vault ✓ Security management - Vulnerability assessment - Data discovery and classification Compliance

  4. 4

    Troubleshoot Database implementation in Azure

    Troubleshoot Database implementation in Azure

    1. ❑ Monitoring and performance tuning in Azure SQL Database and Azure SQL Managed Instance ✓ CPU and I/O resources m onitoring Monitoring and tuning capabilities in the Azure portal Monitor with SQL insights Azure SQL Database and Azure SQL Managed Instance resource monitoring Database advisors in Azure SQL Database Query Performance Insight in Azure SQL Database Generate intelligent assessments of performance issues Enable the streaming export of metrics and resource logs Log Analytics workspace in Azure monitor Azure event hubs Stream logs to third-party logging and telemetry systems Build a custom telemetry and logging platform View service health by streaming data to Power BI Azure Storage Use extended events