Practice Assessment for Exam DP-900: Microsoft Azure Data Fundamentals

Which service is built on Apache Spark and is compatible with other cloud providers? Select only one answer. Azure Databricks Azure Data Factory Azure Synapse Analytics Azure HDInsight - Answer- Azure Databricks - Databricks is used for processing large amounts of data, which is supported by multiple cloud providers. Data Factory is used to run ETL pipelines. Azure Synapse Analytics is an Azure native service built on Apache Spark. HDInsight is used to process large amounts of data by using Apache Hadoop. Which native Azure service can you use to process data by running Apache Spark jobs? Select only one answer. Azure Data Lake Storage Azure Cosmos DB Azure Synapse Analytics - Answer- Azure Synapse Analytics is an Azure native service built on Spark. Azure Data Lake Storage is used to store data. Azure Cosmos DB does not use a Spark platform. Which type of data store uses star schemas, fact tables, and dimension tables? Select only one answer. relational database data warehouse cube data lake - Answer- Data warehouses use fact and dimension tables in a star/snowflake schema. Relational databases do not use fact and dimension tables. Cubes are generated from a data warehouse but are a table themselves. Data lakes store files. Which two services allow you to pre-process a large volume of data by using Scala? Each correct answer presents a complete solution. Azure Databricks a serverless Apache Spark pool in Azure Synapse Analytics Azure Synapse Analytics serverless SQL pool Azure Synapse Analytics dedicated SQL pool - Answer- Databricks and the Spark pool in Azure Synapse Analytics run data processing for large amounts of data by using Scala. What is a characteristic of stream processing?