Online Access Free 070-475 Exam Questions

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 SQL data warehouse
• C.a Microsoft Azure HDInsight Hadoop cluster
• D.Microsoft Azure Table Storage
• E.a Microsoft Azure HDInsight Storm cluster

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.

• A.STORED AS ORC
• B.STORED AS RCFILE
• C.STORED AS TEXTFILE
• D.STORED AS GZIP

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 any date before the day the categories become active.
• B.Use any date after the day the file becomes active.
• C.Use the date and hour that the categories are to become active.
• D.Use the current date and time.

You have an Apache Hive cluster in Microsoft Azure HDInsight. The cluster contains 10 million data files.
You plan to archive the data.
The data will be analyzed monthly.
You need to recommend a solution to move and store the data. The solution must minimize how long it takes to move the data and must minimize costs.
Which two services should you include in the recommendation? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A.Azure Data Factory
• B.Azure Table Storage
• C.Azure Data Lake
• D.Microsoft SQL Server Integration Services (SSIS)
• E.Azure Queue storage

You have a Microsoft Azure Data Factory pipeline that contains an input dataset.
You need to ensure that the data from Azure Table Storage is copied only if the table contains 1,000 records or more.
Which policy setting should you use in JSON?

• A.Option B
• B.Option A
• C.Option C
• D.Option D