Free Designing an Azure Data Solution DP-201 Exam Practice Test

A company installs IoT devices to monitor its fleet of delivery vehicles. Data from devices is collected fromAzure Event Hub.The data must be transmitted to Power BI for real-time data visualizations.You need to recommend a solution.What should you recommend?

• Azure HDInsight with Spark Streaming
• Apache Spark in Azure Databricks
• Azure Stream Analytics
• Azure HDInsight with Storm

You need to design a solution to meet the SQL Server storage requirements for CONT_SQL3.Which type of disk should you recommend?

• Standard SSD Managed Disk
• Premium SSD Managed Disk
• Ultra SSD Managed Disk

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 an Azure SQL database that has columns. The columns contain sensitive Personally Identifiable Information (PII) data.You need to design a solution that tracks and stores all the queries executed against the PII data. You must be able to review the data in Azure Monitor, and the data must be available for at least 45 days.Solution: You create a SELECT trigger on the table in SQL Database that writes the query to a new table in the database, and then executes a stored procedure that looks up the column classifications and joins to the query text.Does this meet the goal?

• Yes
• No

You have an Azure Storage account.You plan to copy one million image files to the storage account.You plan to share the files with an external partner organization. The partner organization will analyze the files during the next year.You need to recommend an external access solution for the storage account. The solution must meet thefollowing requirements:* Ensure that only the partner organization can access the storage account.* Ensure that access of the partner organization is removed automatically after 365 days.What should you include in the recommendation?

• shared keys
• Azure Blob storage lifecycle management policies
• Azure policies
• shared access signature (SAS)

You plan to migrate data to Azure SQL Database.The database must remain synchronized with updates to Microsoft Azure and SQL Server.You need to set up the database as a subscriber.What should you recommend?

• Azure Data Factory
• SQL Server Data Tools
• Data Migration Assistant
• SQL Server Agent for SQL Server 2017 or later
• SQL Server Management Studio 17.9.1 or later

A company plans to use Apache Spark Analytics to analyze intrusion detection dataYou need to recommend a solution to monitor network and system activities for malicious activities and policy violations. Reports must be produced in an electronic format and sent to management. The solution mustminimize administrative efforts.What should you recommend?

• Azure Data Factory
• Azure Data Lake
• Azure Databricks
• Azure HDInsight

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 streaming data that is received by Azure Event Hubs and stored in Azure Blob storage. The data contains social media posts that relate to a keyword of Contoso.You need to count how many times the Contoso keyword and a keyword of Litware appear in the same post every 30 seconds. The data must be available to Microsoft Power BI in near real-time.Solution: You create an Azure Stream Analytics job that uses an input from Event Hubs to count the posts that have the specified keywords, then and send the data directly to Power BI.Does the solution meet the goal?

• Yes
• No

You plan to use Azure SQL Database to support a line of business app.You need to identify sensitive data that is stored in the database and monitor access to the data.Which three actions should you recommend? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

• Enable Data Discovery and Classification.
• Implement Transparent Data Encryption (TDE).
• Enable Auditing.
• Run Vulnerability Assessment.
• Use Advanced Threat Protection.

You need to design the storage for the telemetry capture system.What storage solution should you use in the design?

• Azure SQL Data Warehouse
• Azure Databricks
• Azure Cosmos DB

A company has a real-time data analysis solution that is hosted on Microsoft Azure. The solution uses Azure Event Hub to ingest data and an Azure Stream Analytics cloud job to analyze the data. The cloud job is configured to use 120 Streaming Units (SU).You need to optimize performance for the Azure Stream Analytics job.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

• Implement event ordering
• Scale the SU count for the job up
• Implement Azure Stream Analytics user-defined functions (UDF)
• Scale the SU count for the job down
• Implement query parallelization by partitioning the data output
• Implement query parallelization by partitioning the data output