Online Access Free 70-475 Practice Test

You have a Microsoft Azure SQL data warehouse named DW1.
A department in your company creates an Azure SQL database named DB1. DB1 is a data mart.
Each night, you need to insert new rows Into 9.000 tables in DB1 from changed data in DW1. The solution must minimize costs.
What should you use to move the data from DW1 to DB1, and then to import the changed data to DB1? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation

Box 1: Azure Data Factory
Use the Copy Activity in Azure Data Factory to move data to/from Azure SQL Data Warehouse.
Box 2: The BULK INSERT statement

You are developing an Apache Storm application by using Microsoft Visual Studio. You need to implement a custom topology that uses a custom bolt. Which type of object should you initialize in the main class?

• A.Streamlnfo
• B.TopologyBuilder
• C.Stream
• D.Logger

You need to recommend a platform architecture for a big data solution that meets the following requirements:
Supports batch processing
Provides a holding area for a 3-petabyte (PB) dataset
Minimizes the development effort to implement the solution
Provides near real time relational querying across a multi-terabyte (TB) dataset Which two platform architectures should you include in the recommendation? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A.a Microsoft SQL Server database
• B.a Microsoft Azure HDInsight Hadoop cluster
• C.a Microsoft Azure HDInsight Storm cluster
• D.a Microsoft Azure SQL data warehouse
• E.Microsoft Azure Table Storage

You extend the dashboard of the health tracking application to summarize fields across several users.
You need to recommend a file format for the activity data in Azure that meets 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.

• A.XML
• B.JSON
• C.ORC
• D.CSV
• E.TSV

You have a Microsoft Azure Stream Analytics job that contains several pipelines.
The Stream Analytics job is configured to trigger an alert when the sale of products in specific categories exceeds a specified threshold.
You plan to change the product-to-category mappings next month to meet future business requirements.
You need to create the new product-to-category mappings to prepare for the planned change. The solution must ensure that the Stream Analytics job only uses the new product-to-category mappings when the mappings are ready to be activated.
Which naming structure should you use for the file that contains the product-to-category mappings?

• A.Use the date and hour that the categories are to become active.
• B.Use any date after the day the file becomes active.
• C.Use any date before the day the categories become active.
• D.Use the current date and time.