DP-900 - Other Azure Services

Other Azure Services - 19 Cards
Click here to toggle all cards
Azure Data Studio
Cross-platform db tool with Intellisense, code snippets, SQL queries, notebooks and backup/restore support.
SQL Server Management Studio (SSMS)
Graphical tool for managing SQL Server and Azure Databases. Supports configuration, management, and administration tasks.
SQL Server Data Tools (SSDT)
Build SQL Server and Azure SQL databases, Analysis Services data models, Integration Services packages, and Reporting Services reports.
sqlcmd
Run SQL scripts and procedures from command line for SQL Server, Azure SQL Database, Azure SQL MI, and Azure Synapse Analytics.
Database Administrator
Control data servers, using Azure Data Studio and SQL Server Management Studio
Data Engineers
Design, build, and optimize data pipelines using Azure tools and programming languages
Data Analyst
Analyze and visualize data with tools like Excel and Power BI
Pricing calculator
Estimate the costs for Azure services.
Factors affecting Pricing
Resource type and configuration, Usage, Region, Data transfer, Reserved or not etc.
ARM Templates
Infrastructure as Code to automate resource provisioning in Azure
Azure Portal
Web-based UI. No automation. Runs in modern browsers.
Azure Mobile App
iOS/Android app. Convenient for remote management.
Azure PowerShell
Execute cmdlets and create scripts. Windows and cross-platform.
Azure CLI
Execute Bash scripts. Linux and cross-platform.
Azure Cloud Shell
Free, browser-based shell. Pre-installed Azure tools. Supports PowerShell and CLI. Runs in modern browsers.
Azure Resource Hierarchy
Management Group(s) > Subscription(s) > Resource Group(s) > Resources
Resource Groups
Logical container for resources, associated with a single subscription, can have multiple resources
Subscriptions
Link Azure account to resources
Management Groups
Allows you to manage access, policies, and compliance across multiple subscriptions