Online Access Free 70-475 Exam Questions

You have a Microsoft Azure SQL database that contains Personally Identifiable Information (PII).
To mitigate the PII risk, you need to ensure that data is encrypted while the data is at rest. The solution must minimize any changes to front-end applications.
What should you use?

• A.a shared access signature (SAS)
• B.transparent data encryption (TDE)
• C.the ENCRYPTBYPASSPHRASE T-SQL function
• D.Transport Layer Security (TLS)

Your company has thousands of Internet-connected sensors.
You need to recommend a computing solution to perform a real-time analysis of the data generated by the sensors.
Which computing solution should you include in the recommendation?

• A.Microsoft Azure Notification Hubs
• B.a Microsoft Azure HDInsight HBase cluster
• C.Microsoft Azure Cognitive Services
• D.Microsoft Azure Stream Analytics

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 Data Factory Contributor role.
Does this meet the goal?

• A.Yes
• B.No

You have a web application that generates several terabytes (TB) of financial documents each day. The application processes the documents in batches.
You need to store the documents in Microsoft Azure. The solution must ensure that a user can restore the previous version of a document.
Which type of storage should you use for the documents?

• A.Azure Blob storage
• B.Azure Cosmos DB
• C.Azure Data Lake
• D.Azure File Storage

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 have an Apache Spark system that contains 5 TB of data.
You need to write queries that analyze the data in the system. The queries must meet the following requirements:
* Use static data typing.
* Execute queries as quickly as possible.
* Have access to the latest language features.
Solution: You write the queries by using Java.

• A.Yes
• B.No