Home » Microsoft » AZ-900 v.2 » DRAG DROP
DRAG DROP
Match the Azure service to the correct description.
Instructions: To answer, drag the appropriate Azure service from the column on the left to its description on the right. Each service may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:
Correct Answer:
Explanation/Reference:
Box 1: Azure SQL Database
SQL Server is a relational database service. Azure SQL Database is a managed SQL Server Database in Azure. The SQL Server is managed by Microsoft; you just have access to the database.
Box 2: Azure SQL Data Warehouse
Azure SQL Data Warehouse (SQL DW) is a cloud-based Platform-as-a-Service (PaaS) offering from Microsoft. It is a large-scale, distributed, MPP (massively parallel processing) relational database technology in the same class of competitors as Amazon Redshift or Snowflake. Azure SQL DW is an important component of the Modern Data Warehouse multi-platform architecture. Because Azure SQL DW is an MPP system with a shared-nothing architecture across distributions, it is meant for large-scale analytical workloads which can take advantage of parallelism.
Box 3: Azure Data Lake Analytics
You can process big data jobs in seconds with Azure Data Lake Analytics. You can process petabytes of data for diverse workload categories such as querying, ETL, analytics, machine learning, machine translation, image processing and sentiment analysis by leveraging existing libraries written in .NET languages, R or Python.
Box 4: Azure HDInsight.
Apache Hadoop was the original open-source framework for distributed processing and analysis of big data sets on clusters. The Hadoop ecosystem includes related software and utilities, including Apache Hive, Apache HBase, Spark, Kafka, and many others.
Azure HDInsight is a fully managed, full-spectrum, open-source analytics service in the cloud for enterprises. The Apache Hadoop cluster type in Azure HDInsight allows you to use HDFS, YARN resource management, and a simple
MapReduce programming model to process and analyze batch data in parallel.
References:
https://azure.microsoft.com/en-us/services/sql-database/
https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-overview-what-is
https://docs.microsoft.com/bs-latn-ba/azure/hdinsight/hadoop/apache-hadoop-introduction
https://www.blue-granite.com/blog/is-azure-sql-data-warehouse-a-good-fit-updated
https://azure.microsoft.com/en-gb/services/data-lake-analytics/
How To Pass AZ-900 Exam?
Microsoft AZ-900 PDF dumps.
High quality AZ-900 pdf and software. VALID exam to help you pass.
|
 |
website answer is correct.
Correct
Why is this correct?
Correct: Azure SQL Data Warehouses are a cloud-based service that leverages massively parallel processing (MPP) to quickly run complex queries across petabytes of data in a relational database
Why is this correct?
Correct: Azure Data Lake Analytics can run massively parallel data transformation and processing programs across petabytes of data
https://docs.microsoft.com/en-us/azure/data-lake-analytics/data-lake-analytics-overview
Correct answers are below:
Azure HDInsight——————-An open-source framework for the distributed processing and analysis of big
data sets in clusters
Azure Data Lake Analytics—–A cloud-based service that leverages massively parallel processing (MPP)
to quickly run comples queries across petabytes of data in a relational
database
Azure SQL Data Warehouse–Can run massively parallel data transformation and processing programs
across petabytes of data
Azure SQL Database————–A managed relational cloud database service
I defer in the Azure SQL dataware house(now azure Synapse) and lake analytics answers. With sql datawarehouse you can run programs to transform data with hadoop and spark , whereas with lake analytics you can get the highest performance, throughput, and parallelization
Azure SQL Data Warehouse now is Azure Synapse Analytics
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-overview-what-is