exam questions

Exam AZ-900 All Questions

View all questions & answers for the AZ-900 exam

Exam AZ-900 topic 1 question 170 discussion

Actual exam question from Microsoft's AZ-900
Question #: 170
Topic #: 1
[All AZ-900 Questions]

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:

Show Suggested Answer Hide Answer
Suggested Answer:
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 Synapse Analytics
Azure SQL Synapse Analytics (previously called Data Warehouse) 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
Synapse Analytics is an important component of the Modern Data Warehouse multi-platform architecture. Because Azure SQL Synapse Analytics 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.
Reference:
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/

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Hydrogen
Highly Voted 3 years, 3 months ago
Terrible product naming Microsoft :-/
upvoted 266 times
Milimiliemilie
3 years, 1 month ago
Why isn't this comment "highly voted" yet? :-D
upvoted 8 times
zimzimzimma
1 year, 6 months ago
Did my part
upvoted 4 times
...
...
shah92
1 year, 1 month ago
aws is worser than azure lol
upvoted 4 times
...
...
Aru23
Highly Voted 3 years, 5 months ago
Clue: Relational: Sql Massive: Synapse Messive PetaByte: Lake OPenshource: Insight
upvoted 136 times
ChetanaS
1 year, 10 months ago
Such a nice co-relation...nobody can ever forget this answer
upvoted 6 times
...
BobbyVagene
3 years, 4 months ago
Very handy thank you! I have one suggestion though, Synapse and Datalake descriptions both mention petabytes, but SQL Synapse is also relational. I would suggest this: Relational: SQL Massive Relational: SQL Synapse Just Massive: Datake OPensource: HD Insight, HD = HadoOP
upvoted 109 times
...
...
XaXeXi
Most Recent 7 months ago
I don't think this question is still within the scope of the exam, can anyone confirm? 2024
upvoted 5 times
...
HitenPat
9 months ago
SQL : relational Synapse : complex queries Data Lake : process programs HDInsights : HD = hadoOP - open source
upvoted 1 times
...
fmones16
9 months, 4 weeks ago
HDInsight = Open-source Data Lake Analytics = Petabytes SQL Synapse Analytics = Quickly SQL Database = Relational
upvoted 1 times
...
mau1181
1 year, 2 months ago
I only can see one questions for Microsoft AZ 900 exam, do you know how can I access all the questions?
upvoted 1 times
...
SAFM
1 year, 2 months ago
This does not seem part of the syllabus anymore... agree?
upvoted 5 times
...
zimzimzimma
1 year, 6 months ago
Very confusing about the difference between Data Lake and Synapse. Even the MS engineer who answered this question seems to be saying the same, yet differently phrased: https://learn.microsoft.com/en-us/answers/questions/662946/what-is-the-difference-between-azure-synapse-analy
upvoted 1 times
...
BabyYodaIsCute
1 year, 7 months ago
I don't think this question is still within the scope of the exam, can anyone verify?
upvoted 3 times
...
Billy235
2 years, 2 months ago
No longer part of the exam after the May 2022 syllabus refresh?
upvoted 5 times
Ajuu93
2 years ago
As a data engineer sitting for this exam, it’s sad to see some familiar terms being removed from syllabus.
upvoted 2 times
...
...
Pa1theAchiever
2 years, 5 months ago
correct
upvoted 1 times
...
cormorant
2 years, 9 months ago
whenever you hear SQL, it's relational ______________ while you're at it: databricks - spark HDInsight - hadoop
upvoted 4 times
Divyayuvi
2 years, 5 months ago
and for NoSQL!!?? ;)
upvoted 1 times
...
...
NiKU2403
2 years, 11 months ago
examples of some worst services from MS and their names
upvoted 9 times
...
MACA_knd
3 years ago
Very helpful clues
upvoted 1 times
...
sudheerdhawangis
3 years, 5 months ago
SQL database:Relational,Cloud HDInsight:Analysis,big data Lake:Large data,Petabyte Azure SQL Synapse Analysis: process big data jobs in seconds ,cloudbased
upvoted 7 times
...
wmlead
3 years, 5 months ago
quite confusing
upvoted 8 times
...
Vivek7
3 years, 6 months ago
Correct
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago