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: | Sep 07, 2025 |
You have data pushed to Microsoft Azure Blob storage every few minutes.
You want to use an Azure Machine Learning web service to score the data hourly.
You plan to deploy the data factory pipeline by using a Microsoft.NET application.
You need to create an output dataset for the web service.
Which three properties should you define? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A company named Fabrikam, Inc. has a Microsoft Azure web app. Billions of users visit the app daily.
The web app logs all user activity by using text files in Azure Blob storage. Each day, approximately 200 GB of text files are created.
Fabrikam uses the log files from an Apache Hadoop cluster on Azure DHlnsight.
You need to recommend a solution to optimize the storage of the log files for later Hive use.
What is the best property to recommend adding to the Hive table definition to achieve the goal? More than one answer choice may achieve the goal. Select the BEST answer.
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 states goals. Some question sets might have more than one correct solution, while the 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 plan to implement a new data warehouse.
You have the following information regarding the data warehouse:
* The first data files for the data warehouse will be available in a few days.
* Most queries that will be executed against the data warehouse are ad-hoc.
* The schemas of data files that will be loaded to the data warehouse change often.
* One month after the planned implementation, the data warehouse will contain 15 TB of data.
You need to recommend a database solution to support the planned implementation.
Solution: You recommend an Apache Hadoop system.
Does this meet the goal?
You have a Microsoft Azure data factory named ADF1 that contains a pipeline named Pipeline1.
You plan to automate updates to Pipeline1.
You need to build the URL that must be called to update the pipeline from the REST API.
How should you complete the URL? To answer, drag the appropriate URL elements to the correct locations.
Each URL element may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
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 states goals. Some question sets might have more than one correct solution, while the 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 plan to implement a new data warehouse.
You have the following information regarding the data warehouse:
* The first data files for the data warehouse will be available in a few days.
* Most queries that will be executed against the data warehouse are ad-hoc.
* The schemas of data files that will be loaded to the data warehouse change often.
* One month after the planned implementation, the data warehouse will contain 15 TB of data.
You need to recommend a database solution to support the planned implementation.
Solution: You recommend a Microsoft SQL server on a Microsoft Azure virtual machine.
Does this meet the goal?