exam questions

Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam

Exam AZ-305 topic 2 question 13 discussion

Actual exam question from Microsoft's AZ-305
Question #: 13
Topic #: 2
[All AZ-305 Questions]

You store web access logs data in Azure Blob Storage.
You plan to generate monthly reports from the access logs.
You need to recommend an automated process to upload the data to Azure SQL Database every month.
What should you include in the recommendation?

  • A. Microsoft SQL Server Migration Assistant (SSMA)
  • B. Data Migration Assistant (DMA)
  • C. AzCopy
  • D. Azure Data Factory
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

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
Gowind
Highly Voted 2 years, 6 months ago
Selected Answer: D
Correct https://docs.microsoft.com/en-us/azure/data-factory/tutorial-copy-data-tool
upvoted 17 times
...
NotMeAnyWay
Highly Voted 1 year, 11 months ago
Selected Answer: D
D. Azure Data Factory You should recommend using Azure Data Factory for this scenario. Azure Data Factory is a cloud-based data integration service that allows you to create, schedule, and manage data pipelines. In this case, you can create a pipeline to automatically extract data from the Azure Blob Storage, transform the data if needed, and load it into the Azure SQL Database on a monthly basis. This will help you generate the required monthly reports from the access logs.
upvoted 12 times
...
[Removed]
Most Recent 3 months, 3 weeks ago
Selected Answer: D
D is correct
upvoted 1 times
...
Lazylinux
10 months, 1 week ago
Selected Answer: D
Given answer D is correct Azure Data Factory is a cloud-based data integration service that allows you to create, schedule, and manage data pipelines. In this case, you can create a pipeline to automatically extract data from the Azure Blob Storage, transform the data if needed, and load it into the Azure SQL Database on a monthly basis. This will help you generate the required monthly reports from the access logs. Integrate all your data with Azure Data Factory, a fully managed, serverless data integration service. Visually integrate data sources with more than 90 built-in, maintenance-free connectors at no added cost. Easily construct ETL (extract, transform, and load) and ELT (extract, load, and transform) processes code-free in an intuitive environment or write your own code. Then deliver integrated data to Azure Synapse Analytics to unlock business insights.
upvoted 1 times
...
au95_aznieto
1 year, 11 months ago
If helps I found github project from Azure about cosmos db data migration tool, it seems to be active https://github.com/Azure/azure-documentdb-datamigrationtool
upvoted 2 times
...
zellck
2 years ago
Selected Answer: D
D is the answer. https://learn.microsoft.com/en-us/azure/data-factory/introduction Big data requires a service that can orchestrate and operationalize processes to refine these enormous stores of raw data into actionable business insights. Azure Data Factory is a managed cloud service that's built for these complex hybrid extract-transform-load (ETL), extract-load-transform (ELT), and data integration projects.
upvoted 3 times
...
totalz
2 years ago
None of the answers are an automated process...
upvoted 1 times
totalz
2 years ago
my bad, it says "include in the recommendation"
upvoted 1 times
...
...
VBK8579
2 years, 1 month ago
Selected Answer: D
D. Azure Data Factory
upvoted 1 times
...
OPT_001122
2 years, 1 month ago
Selected Answer: D
D. Azure Data Factory
upvoted 2 times
...
libran
2 years, 5 months ago
Selected Answer: D
Given is correct
upvoted 4 times
...
most_lenyora
2 years, 6 months ago
Correct
upvoted 2 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