Online Access Free 070-475 Exam Questions
| Exam Code: | 070-475 |
| Exam Name: | Design and Implement Big Data Analytics Solutions |
| Certification Provider: | Microsoft |
| Free Question Number: | 122 |
| Posted: | Jun 11, 2026 |
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a Microsoft Azure subscription that includes Azure Data Lake and Cognitive Services.
An administrator plans to deploy an Azure Data Factory.
You need to ensure that the administrator can create the data factory.
Solution: You add the user to the Owner role.
Does this meet the goal?
You use Microsoft Azure Data Factory to orchestrate data movements and data transformations within Azure.
You plan to monitor the data factory to ensure that all of the activity slices run successfully. You need to identify a solution to rerun failed slices. What should you do?
You need to recommend a permanent Azure Storage solution for the activity data. The solution must meet the technical requirements.
What is the best recommendation to achieve the goal? More than one answer choice may achieve the goal.
Select the BEST answer.
You have four on-premises Microsoft SQL Server data sources as described in the following table.
You plan to create three Azure data factories that will interact with the data sources as described in the following table.
You need to deploy Microsoft Data Management Gateway to support the Azure Data Factory deployment. The solution must use new servers to host the instances of Data Management Gateway.
What is the minimum number of new servers and data management gateways you should you deploy? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You have a large datacenter.
You plan to track the hardware failure notifications that occur in the datacenter. You expect to collect approximated 2 TB of data each month. You need to recommend a solution that meets the following requirements:
* Operators must be informed by email as soon as a hardware failure occurs.
* All event data associated with a hardware failure must be preserved for 24 months.
The solution must minimize costs.


