MC Azure data fundamentals study guide
The most authoritative and complete study guide for people beginning to work with data in the Azure clo.ud In MC Azure Data Fundamentals Study Guide: Exam DP-900, expert Cloud Solution Architect Jake Switzer delivers a hands-on blueprint to acing the DP-900 Azure data certification. The book prepare...
| Otros Autores: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Indianapolis, Indiana :
John Wiley and Sons
[2022]
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009659940806719 |
Tabla de Contenidos:
- Cover
- Title Page
- Copyright Page
- Acknowledgments
- About the Author
- About the Technical Editor
- Contents at a Glance
- Contents
- Introduction
- Who Should Read This Book?
- What's Included in the Book?
- Recommended Home Lab Setup
- Interactive Online Learning Environment and Test Bank
- DP-900 Exam Objectives
- Domain 1: Describe Core Data Components
- Subdomain 1a: Describe types of core data workloads
- Subdomain 1b: Describe data analytics core concepts
- Domain 2: Describe How to Work with Relational Data on Azure
- Subdomain 2a: Describe relational data workloads
- Subdomain 2b: Describe relational Azure data services
- Subdomain 2c: Identify basic management tasks for relational data
- Subdomain 2d: Describe query techniques for data using SQL language
- Domain 3: Describe How to Work with Nonrelational Data on Azure
- Subdomain 3a: Describe nonrelational data workloads
- Subdomain 3b: Describe nonrelational data offerings on Azure
- Subdomain 3c: Identify basic management tasks for nonrelational data
- Domain 4: Describe an Analytics Workload on Azure
- Subdomain 4a: Describe analytics workloads
- Subdomain 4b: Describe the components of a modern data warehouse
- Subdomain 4c: Describe data ingestion and processing on Azure
- Subdomain 4d: Describe data visualization in Microsoft Power BI
- Assessment Test
- Answers to the Assessment Test
- Chapter 1 Core Data Concepts
- Describe Types of Core Data Workloads
- Data Value
- Data Volume
- Data Variety
- Data Velocity
- Describe Data Analytics Core Concepts
- Data Processing Techniques
- Describe Analytics Techniques
- Describe Data Visualization Techniques
- Summary
- Exam Essentials
- Review Questions
- Chapter 2 Relational Databases in Azure
- Relational Database Features
- Relational Database Design Considerations.
- Relational Database Offerings in Azure
- Azure SQL
- Azure Synapse Analytics Dedicated SQL Pools
- Open-Source Databases in Azure
- Management Tasks for Relational Databases in Azure
- Deployment Scripting and Automation
- Migrating to Azure SQL
- Database Security
- Common Connectivity Issues
- Management Tools
- Query Techniques for SQL
- DDL vs. DML Commands
- Query Relational Data in Azure SQL, MySQL, MariaDB, and PostgreSQL
- Summary
- Exam Essentials
- Review Questions
- Chapter 3 Nonrelational Databases in Azure
- Nonrelational Database Features
- Key-Value Store
- Document Database
- Columnar Database
- Graph Database
- Azure Cosmos DB
- High Availability
- Request Units
- Azure Cosmos DB APIs
- Management Tasks for Azure Cosmos DB
- Deployment Options
- Azure Cosmos DB Security
- Azure Cosmos DB Common Connectivity Issues
- Management Tools
- Summary
- Exam Essentials
- Review Questions
- Chapter 4 File, Object, and Data Lake Storage
- File and Object Storage Features
- Azure Storage
- Performance Tiers
- Data Redundancy
- Deploying through the Azure Portal
- Azure Storage Services
- Management Tasks for Azure Storage
- Deployment Scripting and Automation
- Azure Storage Security
- Azure Storage Common Connectivity Issues
- Management Tools
- Summary
- Exam Essentials
- Review Questions
- Chapter 5 Modern Data Warehouses in Azure
- Analytical Workload Features
- Transactional vs. Analytical Workloads
- Data Processing Techniques
- Modern Data Warehouse Components
- Data Modeling Best Practices for Data Warehouses
- Azure Services for Modern Data Warehouses
- End-to-End Analytics with Azure Synapse Analytics
- Deploying an Azure Synapse Analytics Workspace
- Navigating the Synapse Studio UI
- Dedicated SQL Pools
- Serverless SQL Pools
- Summary
- Exam Essentials
- Review Questions.
- Chapter 6 Reporting with Power BI
- Power BI at a Glance
- Working with Power BI
- Summary
- Exam Essentials
- Review Questions
- Appendix Answers to the Review Questions
- Chapter 1: Core Data Concepts
- Chapter 2: Relational Databases in Azure
- Chapter 3: Nonrelational Databases in Azure
- Chapter 4: File, Object, and Data Lake Storage
- Chapter 5: Modern Data Warehouses in Azure
- Chapter 6: Reporting with Power BI
- Index
- EULA.
