Microsoft 70-475 Exam Questions and Answers 2021

NEW QUESTION 1
You are designing an Apache HBase cluster on Microsoft Azure HDInsight. You need to identify which nodes are required for the cluster.
Which three nodes should you identify? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

• A. Nimbus
• B. Zookeeper
• C. Region
• D. Supervisor
• E. Falcon
• F. Head

Answer: BCF

Explanation: https://docs.microsoft.com/en-us/azure/hdinsight/hdinsight-hadoop-provision-linux-clusters

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

Answer: C

NEW QUESTION 3
You have an application that displays data from a Microsoft Azure SQL database. The database contains credit card numbers.
You need to ensure that the application only displays the last four digits of each credit card number when a credit card number is returned from a query. The solution must NOT require any changes to the data in the database.
What should you use?

• A. Dynamic Data Masking
• B. cell-level security
• C. Transparent Data Encryption (TDE)
• D. row-level security

Answer: A

NEW QUESTION 4
You have a pipeline that contains an input dataset in Microsoft Azure Table Storage and an output dataset in Azure Blob storage. You have the following JSON data.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the JSON data.
NOTE: Each correct selection is worth one point.

Answer:

Explanation: Box 1: Every three days at 10.00
anchorDateTime defines the absolute position in time used by the scheduler to compute dataset slice boundaries.
"frequency": "<Specifies the time unit for data slice production. Supported frequency: Minute, Hour, Day, Week, Month>",
"interval": "<Specifies the interval within the defined frequency. For example, frequency set to 'Hour' and interval set to 1 indicates that new data slices should be produced hourly>
Box 2: Every minute up to three times.
retryInterval is the wait time between a failure and the next attempt. This setting applies to present time. If the previous try failed, the next try is after the retryInterval period.
Example: 00:01:00 (1 minute)
Example: If it is 1:00 PM right now, we begin the first try. If the duration to complete the first validation check is 1 minute and the operation failed, the next retry is at 1:00 + 1min (duration) + 1min (retry interval) = 1:02 PM.
For slices in the past, there is no delay. The retry happens immediately. retryTimeout is the timeout for each retry attempt.
maximumRetry is the number of times to check for the availability of the external data.

NEW QUESTION 5
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 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 deploy a Microsoft Azure SQL data warehouse and a web application.
The data warehouse will ingest 5 TB of data from an on-premises Microsoft SQL Server database daily. The web application will query the data warehouse.
You need to design a solution to ingest data into the data warehouse.
Solution: You use AzCopy to transfer the data as text files from SQL Server to Azure Blob storage, and then you use PolyBase to run Transact-SQL statements that refresh the data warehouse database.
Does this meet the goal?

• A. Yes
• B. No

Answer: A

Explanation: If you need the best performance, then use PolyBase to import data into Azure SQL warehouse.
Note: Often the speed of migration is an overriding concern compared to ease of setup and maintainability,
particularly when there’s a large amount of data to move. Optimizing purely for speed, a source controlled differentiated approach relying on bcp to export data to files, efficiently moving the files to Azure Blob storage, and using the Polybase engine to import from blob storage works best.
References: https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-migrate-data

NEW QUESTION 6
You have an analytics solution in Microsoft Azure that must be operationalized.
You have the relevant data in Azure Blob storage. You use an Azure HDInsight Cluster to process the data. You plan to process the raw data files by using Azure HDInsight. Azure Data Factory will operationalize the
solution.
You need to create a data factory to orchestrate the data movement. Output data must be written back to Azure Blob storage.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Answer:

Explanation:

NEW QUESTION 7
You are designing a solution based on the lambda architecture. The solution has the following layers;
Batch
Speed
Serving
You are planning the data ingestion process and the query execution.
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

Answer:

Explanation: Box 1: No
Box 2: No
Output from the batch and speed layers are stored in the serving layer, which responds to ad-hoc queries by returning precomputed views or building views from the processed data.

Box 3: Yes.
We are excited to announce Interactive Queries, a new feature for stream processing with Apache Kafka. Interactive Queries allows you to get more than just processing from streaming.
Note: Lambda architecture is a popular choice where you see stream data pipelines applied (speed layer). Architects can combine Apache Kafka or Azure Event Hubs (ingest) with Apache Storm (event processing),
Apache HBase (speed layer), Hadoop for storing the master dataset (batch layer), and, finally, Microsoft Power BI for reporting and visualization (serving layer).

NEW QUESTION 8
You have a Microsoft Azure Data Factory pipeline.
You discover that the pipeline fails to execute because data is missing. You need to rerun the failure in the pipeline.
Which cmdlet should you use?

• A. Set-AzureAutomationJob
• B. Resume-AzureDataFactoryPipeline
• C. Resume-AzureAutomationJob
• D. Set-AzureDataFactotySliceStatus

Answer: B

NEW QUESTION 9
You plan to deploy Microsoft Azure HDInsight clusters for business analytics and data pipelines. The clusters must meet the following requirements:
Business users must use a language that is similar to SQL.
The authoring of data pipelines must occur in a dataflow language. You need to identify which language must be used for each requirement.
Which languages should you identify? To answer, drag the appropriate languages to the correct requirements. Each language 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.

Answer:

Explanation:

NEW QUESTION 10
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?

• A. Yes
• B. No

Answer: B

NEW QUESTION 11
You plan to analyze the execution logs of a pipeline to identify failures by using Microsoft power BI. You need to automate the collection of monitoring data for the planned analysis.
What should you do from Microsoft Azure?

• A. Create a Data Factory Set
• B. Save a Data Factory Log
• C. Add a Log Profile
• D. Create an Alert Rule Email

Answer: A

Explanation: You can import the results of a Log Analytics log search into a Power BI dataset so you can take advantage of its features such as combining data from different sources and sharing reports on the web and mobile devices.
To import data from a Log Analytics workspace into Power BI, you create a dataset in Power BI based on a log search query in Log Analytics. The query is run each time the dataset is refreshed. You can then build Power BI reports that use data from the dataset.
References: https://docs.microsoft.com/en-us/azure/azure-monitor/platform/powerbi

NEW QUESTION 12
You work for a telecommunications company that uses Microsoft Azure Stream Analytics. You have data related to incoming calls.
You need to group the data in the following ways:
Group A: Every five minutes for a duration of five minutes
Group B: Every five minutes for a duration of 10 minutes
Which type of window should you use for each group? To answer, drag the appropriate window types to the correct groups. Each window type 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.

Answer:

Explanation: Group A: Tumbling
Tumbling Windows define a repeating, non-overlapping window of time. Group B: Hopping
Like Tumbling Windows, Hopping Windows move forward in time by a fixed period but they can overlap with one another.

NEW QUESTION 13
Your company deploys thousands of sensors.
You plan to join the data from the sensors by using Azure Data Factory. The reference data file refreshes every 30 minutes.
You need to include the path to the reference data in Data Factory. Which path should you include?

• A. products/{date}/{time}/product_listjson
• B. products/{sensor_name}/product_list.json
• C. products/{batch}/product_listjson
• D. products/{time}/product_list.json

Answer: A

NEW QUESTION 14
You need to recommend a data handling solution to support the planned changes to the dashboard. The solution must meet the privacy requirements.
What is the best recommendation to achieve the goal? More than one answer choice may achieve the goal. Select the BEST answer.

• A. anonymization
• B. encryption
• C. obfuscation
• D. compression

Answer: C

NEW QUESTION 15
You are designing an Internet of Thing: (IoT) solution intended to identify trends. The solution requires the realtime analysis of data originating from sensors. The results of the analysis will be stored in a SQL database.
You need to recommend a data processing solution that uses the Transact-SQL language. Which data processing solution should you recommend?

• A. Microsoft Azure Stream Analytics
• B. Microsoft SQL Server Integration Services (SSIS)
• C. Microsoft Azure Machine Learning
• D. Microsoft Azure HDInsight Hadoop clusters

Answer: A

NEW QUESTION 16
You have a Microsoft Azure Data Factory that loads data to an analytics solution. You receive an alert that an error occurred during the last processing of a data stream. You debug the problem and solve an error.
You need to process the data stream that caused the error. What should you do?

• A. From Azure Cloud Shell, run the az dla job command.
• B. From Azure Cloud Shell, run the az batch job enable command.
• C. From PowerShell, run the Resume-AzureRmDataFactoryPipeline cmdlet.
• D. From PowerShell, run the Set-AzureRmDataFactorySliceStatus cmdlet.

Answer: D

Explanation: ADF operates on data in batches known as slices. Slices are obtained by querying data over a date-time window—for example, a slice may contain data for a specific hour, day, or week.
References:
https://blogs.msdn.microsoft.com/bigdatasupport/2021/08/31/rerunning-many-slices-and-activities-in-azure-data

NEW QUESTION 17
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 plan to deploy a Microsoft Azure SQL data warehouse and a web application.
The data warehouse will ingest 5 TB of data from an on-premises Microsoft SQL Server database daily. The web application will query the data warehouse.
You need to design a solution to ingest data into the data warehouse.
Solution: You use SQL Server Integration Services (SSIS) to transfer data from SQL Server to Azure SQL Data Warehouse.
Does this meet the goal?

• A. Yes
• B. No

Answer: B

Explanation: Integration Services (SSIS) is a powerful and flexible Extract Transform and Load (ETL) tool that supports complex workflows, data transformation, and several data loading options.
The main drawback is speed. We should use Polybase instead.
References: https://docs.microsoft.com/en-us/sql/integration-services/sql-server-integration-services