ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-900 All Questions

View all questions & answers for the DP-900 exam
Go to Exam

Exam DP-900 topic 1 question 165 discussion

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

DRAG DROP -
Match the Azure services to the appropriate requirements.
To answer, drag the appropriate service from the column on the left to its requirement 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 Data Factory -

Box 2: Azure Data Lake Storage -
Azure Data Lake Storage (ADLA) now natively supports Parquet files. ADLA adds a public preview of the native extractor and outputter for the popular Parquet file format

Box 3: Azure Synapse Analytics -
Use Azure Synapse Analytics Workspaces.
Reference:
https://docs.microsoft.com/en-us/azure/data-factory/supported-file-formats-and-compression-codecs
by nachito at April 20, 2022, 5:02 p.m.

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
Submit Cancel
FabianW
Highly Voted 2 years, 6 months ago
Answer should be: - Azure Synapse Analytics: Output data to parquet format - Azure Data Lake Storage: Store data that is in parquet format - Azure SQL Database: Persist a tabular representation of data that is stored in parquet format
upvoted 105 times
BorisUK2000
1 year, 3 months ago
That is correct. In the third question, they are talking about tabular representation of the Parquet data, not the Parquet data itself
upvoted 1 times
...
Aunehwet79
2 years, 5 months ago
Thank you - that matches my thinking also
upvoted 13 times
...
...
Chaos2807
Highly Voted 2 years, 5 months ago
Answer: Azure Synapse can convert CSV and other file types to Parquet files and query it ADLS - Store Parquet files produced by Azure Synapse Analytics Azure SQL Database - tabular representation of data
upvoted 6 times
...
rupayan87
Most Recent 2 months, 3 weeks ago
1.ADF 2.ADLS 3. if it is about which service can push the data as tabular format then ADF, Synapse Analytics looks right to me. If it is about which service is capable to persisting the data in itself then it is SQL. Please help me here :)
upvoted 1 times
...
AGTraining
7 months, 4 weeks ago
- Azure Synapse Analytics: Output data to parquet format - Azure Data Lake Storage: Store data that is in parquet format - Azure SQL Database: Persist a tabular representation of data that is stored in parquet
upvoted 3 times
...
Yomzie
8 months, 2 weeks ago
**Tabular representation (tables):: SQL/Azure SQL DB **Store data as parquet: ADLS Gen 2 **Output data to parquet format: Azure Synapse Analytics
upvoted 1 times
...
Marccccc
11 months, 3 weeks ago
Duplicate of #133
upvoted 1 times
...
Murtuza
1 year, 6 months ago
The correct answer is listed below and has been verified - Azure Synapse Analytics: Persist a tabular representation of data that is stored in parquet - Azure Data Lake Storage: Store data that is in parquet format - Azure Data Factory: Output data to parquet format
upvoted 4 times
EstbanFTP
12 months ago
Azure Data Factory is not a choice. SQL database is a choice
upvoted 1 times
...
...
Pranava_GCP
1 year, 6 months ago
what is the right answer ?
upvoted 2 times
...
tangerine141
1 year, 7 months ago
Azure Synapse Analytics/ Azure Data Factory Azure Data Lake Storage Synapse Analytics
upvoted 3 times
...
Azurre
1 year, 7 months ago
Azure Data Lake Storage Gen2 is an Azure service that can output data to the Parquet format. In summary, Azure Data Lake Storage Gen2, Azure Blob Storage, Azure Synapse Analytics, and Azure HDInsight are some of the Azure services that can store data in the Parquet format. In summary, Azure Synapse Analytics is an Azure service that can persist a tabular representation of data that is stored in Parquet format by using SQL Serverless external tables.
upvoted 2 times
...
Kseetha
1 year, 7 months ago
Azure Data Lake Storage - Store data in Parquet format Azure Synapse Analytics -can be used to store tabular representation of data in Parquet format
upvoted 2 times
...
sanroda
1 year, 11 months ago
At Box 1: Azure Data Factory, but we don't have it as answer, it was Azure SQL Database.
upvoted 1 times
...
smariussorin
2 years ago
- Azure Data Factory: Output data to parquet format - Azure Data Lake Storage: Store data that is in parquet format - Azure SQL Database: Persist a tabular representation of data that is stored in parquet format Duplicate
upvoted 1 times
OldSchool
2 years ago
Where did Az Data Factory come from?
upvoted 4 times
...
...
iandewar
2 years, 5 months ago
First choice: Service should read Azure Data Factory not Azure SQL Database
upvoted 6 times
Shaxxie
2 years, 5 months ago
It should be Azure Synapse Analytics.
upvoted 3 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago