In order to set realistic expectations, please note: These questions are NOT official questions that you will find on the official exam. These questions DO cover all the material outlined in the knowledge sections below. Many of the questions are based on fictitious scenarios which have questions posed within them. The official knowledge requirements for the exam are reviewed routinely to ensure that the content has the latest requirements incorporated in the practice questions. Updates to content are often made without prior notification and are subject to change at any time. Each question has a detailed explanation and links to reference materials to support the answers which ensures accuracy of the problem solutions. The questions will be shuffled each time you repeat the tests so you will need to know why an answer is correct, not just that the correct answer was item “B” last time you went through the test. Prove that you can describe the following: core data concepts; how to work with relational data on Azure; how to work with non-relational data on Azure; and an analytics workload on Azure. There are no prerequisites for this course, however students with some IT knowledge or experience will find the concepts easier to understand. Candidates for this exam should have foundational knowledge of core data concepts and how they are implemented using Microsoft Azure data services. This exam is intended for candidates beginning to work with data in the cloud. Candidates should be familiar with the concepts of relational and non-relational data, and different types of data workloads such as transactional or analytical. Azure Data Fundamentals can be used to prepare for other Azure role-based certifications like Azure Database Administrator Associate or Azure Data Engineer Associate, but its not a prerequisite for any of them. Skills measured on Microsoft Azure DP-900 ExamDescribe core data concepts (15-20%)Describe types of core data workloadsdescribe batch datadescribe streaming datadescribe the difference between batch and streaming datadescribe the characteristics of relational dataDescribe data analytics core conceptsdescribe data visualization (e.g, visualization, reporting, business intelligence (BI))describe basic chart types such as bar charts and pie chartsdescribe analytics techniques (e.g, descriptive, diagnostic, predictive, prescriptive, cognitive)describe ELT and ETL processingdescribe the concepts of data processingDescribe how to work with relational data on Azure (25-30%)Describe relational data workloadsidentify the right data offering for a relational workloaddescribe relational data structures (e.g, tables, index, views)Describe relational Azure data servicesdescribe and compare PaaS, IaaS, and SaaS solutionsdescribe Azure SQL family of products including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machinesdescribe Azure Synapse Analyticsdescribe Azure Database for PostgreSQL, Azure Database for MariaDB, and Azure Database for MySQLIdentify basic management tasks for relational datadescribe provisioning and deployment of relational data servicesdescribe method for deployment including the Azure portal, Azure Resource Manager templates, Azure PowerShell, and the Azure command-line interface (CLI)identify data security components (e.g, firewall, authentication)identify basic connectivity issues (e.g, accessing from on-premises, access with Azure VNets, access from Internet, authentication, firewalls)identify query tools (e.g, Azure Data Studio, SQL Server Management Studio, sqlcmd utility, etc.)Describe query techniques for data using SQL languagecompare Data Definition Language (DDL) versus Data Manipulation Language (DML)query relational data in Azure SQL Database, Azure Database for PostgreSQL, and Azure Database for MySQLDescribe how to work with non-relational data on Azure (25-30%)Describe non-relational data workloadsdescribe the characteristics of non-relational datadescribe the types of non-relational and NoSQL datarecommend the correct data storedetermine when to use non-relational dataDescribe non-relational data offerings on Azureidentify Azure data services for non-relational workloadsdescribe Azure Cosmos DB APIsdescribe Azure Table storagedescribe Azure Blob storagedescribe Azure File storageIdentify basic management tasks for non-relational datadescribe provisioning and deployment of non-relational data servicesdescribe method for deployment including the Azure portal, Azure Resource Manager templates, Azure PowerShell, and the Azure command-line interface (CLI)identify data security components (e.g, firewall, authentication, encryption)identify basic connectivity issues (e.g, accessing from on-premises, access with Azure VNets, access from Internet, authentication, firewalls)identify management tools for non-relational dataDescribe an analytics workload on Azure (25-30%)Describe analytics workloadsdescribe transactional workloadsdescribe the difference between a transactional and an analytics workloaddescrib
