Searching CertSprout…
Searching CertSprout…
A little curiosity goes a long way
Search certifications, learning topics, career paths, public profiles and help across CertSprout.
Showing 20 results · Page 7 for “azure”. More results are available below.
DP-300 · Azure SQL operations
…saction holding locks unnecessarily. Worked example An Azure SQL Database query suddenly becomes slower after a plan change. Which feature helps compare query plans over time? Query Store Qu…
DP-300 · Database administration
Database administration balances availability, integrity, performance and recovery. Investigate workload evidence before changing indexes or resource limits, and understand the impact on wri…
DP-300 · SQL querying
SQL joins determine which rows are combined, filters determine which remain, and aggregation summarizes the result. Confirm the intended grain before calculating a total. Joining one parent …
DP-420 · Data modeling
A data model expresses entities, identifiers and relationships. Design it around the operations that must remain correct and the questions that need efficient answers. Normalization can redu…
DP-420 · Database administration
Database administration balances availability, integrity, performance and recovery. Investigate workload evidence before changing indexes or resource limits, and understand the impact on wri…
DP-420 · Identity and access
Authentication establishes who or what is requesting access. Authorization decides which actions that identity may perform on a resource. A successful sign-in therefore does not imply permis…
DP-420 · SQL querying
SQL joins determine which rows are combined, filters determine which remain, and aggregation summarizes the result. Confirm the intended grain before calculating a total. Joining one parent …
DP-750 · Data pipeline design
A data pipeline needs defined inputs, transformations, outputs and checkpoints. Failures can leave partial results, so decide how processing resumes without losing or duplicating records. Tr…
DP-750 · Databricks lakehouse concepts
A lakehouse workflow can separate raw ingestion from validated and business-ready datasets. Each layer should have a clear contract rather than merely a different folder name. Preserve enoug…
DP-750 · Machine-learning engineering
Data leakage occurs when training or model selection uses information that would not be available at prediction time. Split data in a way that respects time and related entities, and fit lea…
DP-750 · Responsible AI evaluation
Aggregate accuracy can hide poor performance for particular users or situations. Evaluate representative subgroups and realistic failure cases, and consider privacy, misuse and human oversig…
DP-900 · Describe core data concepts
Structured data has a fixed schema of rows and columns, like a relational table or a CSV with consistent headers. Semi-structured data carries its own tags but the shape can vary between rec…
DP-900 · Describe core data concepts
Transactional systems (OLTP) handle large numbers of small, fast operations such as placing an order or updating a balance. They are normalised, enforce ACID properties and are optimised for…
DP-900 · Describe core data concepts
Transactional databases guarantee four properties. Atomicity means a transaction is all or nothing; a failed money transfer leaves both accounts untouched. Consistency means every transactio…
DP-900 · Describe core data concepts
…ediate signals and batches for full accuracy later. In Azure, Data Factory pipelines are typically batch, while Stream Analytics and Event Hubs handle streaming. Hook: batch is the daily pos…
DP-900 · Describe core data concepts
DP-900 expects you to distinguish three roles. The database administrator installs, configures, secures, backs up and tunes databases and is accountable for availability and recovery. The da…
DP-900 · Describe core data concepts
SQL statements fall into families. Data Definition Language creates and alters objects: CREATE, ALTER, DROP. Data Manipulation Language reads and changes rows: SELECT, INSERT, UPDATE, DELETE…
DP-900 · Describe core data concepts
Analytics questions build on each other. Descriptive analytics reports what happened, such as last quarter's sales. Diagnostic analytics explains why it happened by drilling into causes. Pre…
DP-900 · Identify considerations for relational data on Azure
Normalization splits data into related tables so each fact is stored once. Instead of repeating a customer's address on every order row, addresses live in a Customers table and orders refere…
DP-900 · Identify considerations for relational data on Azure
Azure offers three ways to run SQL Server. Azure SQL Database is fully managed PaaS for individual databases or elastic pools, with automatic patching, backups and high availability but with…
People search uses public names, handles and headlines. Private and unlisted profiles are excluded. Your goals are visible only to you in search.