stuff i dont know from exam prepper

Atomicity

This property ensures that a transaction is treated as a single, indivisible unit of work, meaning it either completes entirely or fails completely, leaving the database in its original state.

Consistency

This property ensures that a transaction will bring the database from one valid state to another, adhering to all predefined rules and constraints within the database system.

Isolation

This property ensures that concurrent transactions do not interfere with each other, meaning the execution of one transaction should not be affected by the execution of other concurrent transactions, preventing unintended side effects.

Durability

This property guarantees that once a transaction has been successfully committed, its changes are permanent and will persist even in the event of system failures.

Dimension tables

The descriptive attributes or perspectives of the data that provide the context for the measures (about the fact table).

Fact tables

A central table in a data warehouse that stores measurements, metrics, or facts related to a business process. These facts are often numerical and quantifiable.

Dimensions (star schema)

The entities by which you aggregate or slice measures

After you create Microsoft Power BI data models and reports, you can publish them to…

the Power BI Service

Power BI Desktop

This is where you create reports and data models (not publish them)

Power BI phone app

Used to view reports, not publish them.

Power BI service

Cloud-based platform where you publish, share, and collaborate on reports and dashboards.

Kusto Query Language (KQL)

A read-only query language used to analyze large volumes of all types of data. It’s primarily used with Azure Data Explorer and other Microsoft services like Log Analytics and Application Insights.

For a single entity in a fully denormalized database, data is…

read from a single table and written to a single table.

Azure Synapse Analytics

This combines a scalable, high-performance Microsoft SQL Server-based relational data warehouse with the flexibility of a data lake and open-source Apache Spark.

When can you use an Azure Resource Manager template?

To automate the creation of an interdependent group of Azure resources in a repeatable way

When you create an Azure SQL database, which account can always connect to the database?

The server admin login account of the logical server

Transparent data encryption (TDE)

This encrypts the database to protect data at rest.

By default, each Azure SQL database is protected by

a server-level firewall.

You need to query a table named Products in an Azure SQL database.

Which three requirements must be met to query the table from the internet?

You must have SELECT access to the Products table.

You must have a user in the database.

Your IP address must be allowed to connect to the database.

A clustered index

physically sorts the data in a table based on the values in a specified column.

A view

presents content defined by a query.

Azure Table storage

supports multiple read replicas

Azure Table storage

does not support multiple write regions

The Azure Cosmos DB Table API

supports multiple read replicas

The Azure Cosmos DB Table API

supports multiple write replicas

PolyBase

An Azure Synapse Analytics feature that retrieves data from Azure Blob storage by using Transact-SQL queries

Power BI Desktop

Create reports

Power BI Service

Collaborating and sharing with team

Power BI Mobile app

View reports on mobile

Control flow (Azure Data Factory)

An orchestration of pipeline activities that depend on the output of other pipeline activities.

Integration runtime (Azure Data Factory)

A compute environment that provides the data integration capabilities for activities in Azure Data Factory

Azure Databricks

Native notebook support

View

Database object allows other users to rerun the same SQL query ,including calculated columns.

Report

A collection of visualizations that appear together on one or more pages.

Cube

Data in a data warehouse that can be aggregated and loaded into an online analytical processing model.