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 2 for “database”. More results are available below.
CySA+ · Vulnerability Management
…ogs in with an account and reads the registry, package database, configuration files and patch history, giving accurate results and far fewer false positives, and revealing missing patches t…
DP-300 · Azure SQL operations
Slow database behavior can come from query plans, blocking, indexes, data volume or resource limits. Establish when the problem began and whether it affects one query or the whole workload. …
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 · 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-800 · 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-900 · Describe core data concepts
…n matters because it drives storage choice: relational databases for structured, document or key-value stores for semi-structured, blob storage for unstructured. Hook: if you could load it s…
DP-900 · Describe core data concepts
…oading. Running heavy reports directly against an OLTP database slows the business, which is why data is copied to a warehouse. Exam stems describing point-of-sale or banking are OLTP; stems…
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
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 · Identify considerations for relational data on Azure
…w; a foreign key in another table points to it and the database can refuse orphaned references. Analytical schemas deliberately denormalise, duplicating attributes into wide dimension tables…
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…
DP-900 · Identify considerations for relational data on Azure
… the most common open-source relational engines. Azure Database for MySQL and Azure Database for PostgreSQL run the community engines as PaaS with automated backups, patching, scaling and hi…
DP-900 · Identify considerations for relational data on Azure
Beyond tables, relational databases hold reusable objects. A view is a stored SELECT that behaves like a virtual table, useful for simplifying complex joins and restricting which columns use…
DP-900 · Describe considerations for working with non-relational data on Azure
…l stores drop the fixed schema and joins of relational databases to gain scale and flexibility. Key-value stores retrieve an opaque value by its key with very high speed, as in Azure Table S…
DP-900 · Describe considerations for working with non-relational data on Azure
…smos DB is a fully managed, globally distributed NoSQL database with single-digit millisecond latency backed by SLAs. It exposes several APIs so existing applications can move without rewrit…
DataSys+ · 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…
GCP-CDL · Exploring data transformation with Google Cloud
…e from it. Storage choices follow the type: relational databases and BigQuery for structured, Firestore or Bigtable for semi-structured, Cloud Storage for unstructured. A question describing…
GCP-CDL · Exploring data transformation with Google Cloud
…al apps within a region. Cloud Spanner is a relational database that scales horizontally across regions with strong consistency, for global transactional systems. Firestore is a serverless d…
GCP-CDL · Modernize infrastructure and applications with Google Cloud
…m makes modest changes such as swapping a self-managed database for Cloud SQL. Refactor or re-architect rewrites for cloud-native patterns like containers and microservices, delivering the m…
People search uses public names, handles and headlines. Private and unlisted profiles are excluded. Your goals are visible only to you in search.