DDMA Level III

Cloud Data Solutions flashcards

Read the question, say the answer to yourself, then turn the card to check. The first 10 of 48 cards are free; the rest come with the subject.

Card 1 of 48

Jump to a card

Complete Flashcard Reference

Review every card in this deck. Open any card to reveal its answer. The first 10 are free; the other 38 come with the subject.

What are the three cloud service models, and how much does the customer manage under each?

IaaS: the provider delivers raw resources (virtual machines, storage, networking); the customer manages everything from the operating system up. The most to manage. PaaS: the provider manages the infrastructure and runtime; the customer deploys and manages their own applications. SaaS: the provider delivers a complete, ready-to-use application; the customer manages nothing underneath it. The least to manage.

Name the four cloud deployment models.

Private: dedicated to a single organisation, for greater control and security. Public: shared across many customers, owned and run by a third-party provider. Hybrid: private and public combined, with workloads moving between them as needed. Community: shared by a specific group of organisations with common concerns, such as a shared regulatory requirement.

What is an elastic pool in Azure SQL Database, and when is it the better choice?

A shared pool of resources across multiple databases. It is cost-efficient where usage varies unpredictably between the databases, compared with a single database, which has its own dedicated resources.

Why is an Azure Storage account needed before most storage services can be used?

It is the top-level container that groups related storage resources together. It gives the account's data a unique namespace, accessible securely over HTTP/HTTPS.

How do the firewall and row-level security differ as layers of database security?

Firewall (network security): decides whether a connection may reach the database at all, by restricting which IP addresses or virtual networks can connect. Row-level security (access management): decides which specific rows an already-connected, already-authenticated user can see or modify within a table.

How do Query Performance Insight and database advisors work together?

As a diagnose-then-remediate pair. Query Performance Insight diagnoses: it identifies the specific queries consuming the most resources. Database advisors remediate: they recommend index, schema or query changes likely to improve performance.

Rank the three ways to run SQL Server in Azure from most IaaS-like to most PaaS-like.

1. SQL Server on Azure Virtual Machines: most control, most management burden (you patch and maintain it). 2. Azure SQL Managed Instance: near-complete SQL Server compatibility, with most of the operational burden managed by Azure. 3. Azure SQL Database (single database or elastic pool): least management burden.

What are the five characteristics of cloud computing?

On-demand self-service: resources provisioned without human intervention from the provider. Broad network access. Resource pooling across many customers. Rapid elasticity: scaling up or down quickly. Measured, pay-for-use service.

What does Azure Key Vault do for a cloud database?

It centrally manages the encryption keys and secrets the database's security depends on, rather than embedding them in application code.

What are Azure Functions, and how are they billed?

Serverless compute: a small piece of code runs in response to an event, without provisioning or managing a server at all. Billed only for actual execution time.

What is cloud computing?