exam questions

Exam AZ-301 All Questions

View all questions & answers for the AZ-301 exam

Exam AZ-301 topic 2 question 47 discussion

Actual exam question from Microsoft's AZ-301
Question #: 47
Topic #: 2
[All AZ-301 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. Azure Data Factory
  • C. Data Migration Assistant
  • D. AzCopy
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

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
Rajuuu
Highly Voted 5 years, 2 months ago
ANSWER IS B. https://docs.microsoft.com/en-gb/azure/data-factory/introduction
upvoted 11 times
tartar
4 years, 9 months ago
B is ok
upvoted 3 times
...
...
Neetiniti
Highly Voted 4 years, 11 months ago
Correct Answer: B. Azure Data Factory is the platform that solves such data scenarios. It is the cloud-based ETL and data integration service that allows you to create data-driven workflows for orchestrating data movement and transforming data at scale. Using Azure Data Factory, you can create and schedule data-driven workflows (called pipelines) that can ingest data from disparate data stores. You can build complex ETL processes that transform data visually with data flows or by using compute services such as Azure HDInsight Hadoop, Azure Databricks, and Azure SQL Database. https://docs.microsoft.com/en-gb/azure/data-factory/introduction
upvoted 5 times
...
mindtrax
Most Recent 4 years, 3 months ago
ADF is quit an expensive solution for something AZ Copy can do as well. I am not sure which one to go for.
upvoted 1 times
mindtrax
4 years, 3 months ago
There is a question like this in the 304 as well but there minimized costs is mentioned and AZCopy is the selected answer.
upvoted 1 times
mindtrax
4 years, 3 months ago
Ignore this please AZCopy is for copying files to a Storage Account and here an upload to an Azure SQL DB is required
upvoted 2 times
...
...
...
glam
4 years, 4 months ago
B. Azure Data Factory
upvoted 1 times
...
sanketshah
4 years, 5 months ago
B is correct answer.
upvoted 1 times
...
NikP
4 years, 9 months ago
I like this question. No confusion. Straight forward. Answer is ADF.
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 ...