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 11 for “Microsoft”. More results are available below.
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…
DP-900 · Identify considerations for relational data on Azure
…ers to maintain. Azure SQL Database, by contrast, runs Microsoft's own engine and is the choice for T-SQL workloads.
DP-900 · Identify considerations for relational data on Azure
SELECT chooses columns, FROM names the table, and WHERE filters rows before any grouping. JOIN combines rows from two tables on a matching key; an inner join keeps only matches, a left join …
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
Non-relational 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 …
DP-900 · Describe considerations for working with non-relational data on Azure
Azure Cosmos 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 withou…
DP-900 · Describe considerations for working with non-relational data on Azure
A storage account contains four services. Blob Storage holds unstructured objects of any size in containers, with block blobs for files, append blobs for logs and page blobs for VM disks. Az…
DP-900 · Describe considerations for working with non-relational data on Azure
Blob Storage prices depend on how often you read data. Hot has the highest storage cost and lowest access cost for frequently used data. Cool is for data accessed infrequently and kept at le…
DP-900 · Describe considerations for working with non-relational data on Azure
…. It is the foundation of modern lakehouse designs and Microsoft Fabric's OneLake. You still get Blob features such as tiers, redundancy and lifecycle policies. Choose Data Lake Storage Gen2…
DP-900 · Describe an analytics workload on Azure
Extract, Transform, Load cleans and reshapes data in a processing engine before writing it to the destination, keeping the target tidy but requiring separate compute. Extract, Load, Transfor…
DP-900 · Describe an analytics workload on Azure
Analytical models use a star schema. The fact table holds numeric measures such as quantity and sales amount, one row per event, plus foreign keys to dimensions. Dimension tables describe th…
DP-900 · Describe an analytics workload on Azure
…d it introduced the lakehouse and Delta Lake concepts. Microsoft Fabric is the newer SaaS platform bundling lakehouse, warehouse, real-time analytics, data science and Power BI over a single…
DP-900 · Describe an analytics workload on Azure
Real-time analytics needs an ingestion service and a processing engine. Azure Event Hubs ingests millions of events per second from applications and is Kafka-compatible; Azure IoT Hub does t…
DP-900 · Describe an analytics workload on Azure
Power BI Desktop is the free Windows application for connecting to data, shaping it with Power Query, building a data model with relationships and DAX measures, and designing report pages. R…
DP-900 · Describe an analytics workload on Azure
Each chart answers a particular question. Line charts show change over time. Bar and column charts compare values across categories. Pie and donut charts show composition at one moment and s…
DP-900 · Describe an analytics workload on Azure
…oth BI and data science. Azure Synapse, Databricks and Microsoft Fabric all implement lakehouse patterns. Hook: warehouse is tidy, lake is raw, lakehouse is tidy on top of raw.
GH-100 · GitHub administration
GitHub administration combines organization-level settings with repository roles, teams and collaborator access. Grant permissions through maintainable groups and review inherited access as …
People search uses public names, handles and headlines. Private and unlisted profiles are excluded. Your goals are visible only to you in search.