Welcome to Microsoft Azure Data Fundamentals DP-900 practice tests. This course will help you to test your preparation before attempting the certification exam. The questions are as per the DP-900 exam syllabus of the official documentation. There are 2 Full-Length Practice tests with unique and high-quality questions. The third test contains 34+ questions. We update these tests by adding new questions and additional practice tests - up to 6 practice tests (Max allowed by Udemy)100% Exam Coverage - Tests are updated regularly to keep them up to date with the current syllabus. Retake Endlessly: You can retake as many times as you need. Detail Explanations: You get detailed explanations for all the answers with reference links and official documentation-Exam DP-900: Microsoft Azure Data Fundamentals: Describe 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 database services including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual MachineDescribe Azure Synapse AnalyticsDescribe Azure Database for PostgreSQL, Azure Database for MariaDB, and Azure Database for MySQLIdentify basic management tasks for relational dataDescribe the provisioning and deployment of relational data servicesDescribe a 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 the 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 the provisioning and deployment of non-relational data servicesDescribe a 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 the 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 workloadDescribe the difference between batch and real-timeDescribe data warehousing workloadsDetermine when a data warehouse solution is neededDescribe the components of a modern data warehouseDescribe Azure data services for modern data warehousing such as Azure Data Lake, Azure Synapse Analytics, Azure Databricks, and Azure HDInsightDescribe modern data warehousing architecture and workloadDescribe data ingestion and processing on AzureDescribe common practices for data loadingDescribe the components of Azure Data Factory (e.g, pipeline, activities, etc.)Describe data processing options (e.g, Azure HDInsight, Azure Databricks, Azure Synapse Analytics, Azure Data Factory)Describe data visualization in Microsoft Power BIDescribe the role of paginated reportingDescribe the role of interactive reportsDescribe the role of dashboardsDescribe the workflow in Power BI
