Free AZ-305 Exam Braindumps
Designing Microsoft Azure Infrastructure Solutions Questions 35–39 (page: 31)

Updated On: 16-Nov-2026
View Related Case Study

HOTSPOT (Drag and Drop is not supported)
You have an Azure subscription. The subscription contains an Azure SQL managed instance that stores employee details, including social security numbers and phone numbers.
You need to configure the managed instance to meet the following requirements:
-The helpdesk team must see only the last four digits of an employee’s phone number.
-Database administrators must be prevented from seeing the employees’ social security numbers.
-What should you enable for each column in the managed instance? To answer, select the appropriate options in the answer area.
Note: Each correct selection is worth one point.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Box 1: Dynamic data masking
Phone numbers
The helpdesk team must see only the last four digits of an employee’s phone number.
Dynamic data masking helps prevent unauthorized access to sensitive data by enabling customers to designate how much of the sensitive data to reveal with minimal effect on the application layer. It's a policy-based security feature that hides the sensitive data in the result set of a query over designated database fields, while the data in the database isn't changed.
Masking functions: A set of methods that control the exposure of data for different scenarios.
* Credit card
Masking method, which exposes the last four digits of the designated fields and adds a constant string as a prefix in the form of a credit card.
XXXX-XXXX-XXXX-1234
Box 2: Always Encrypted
Social security numbers
Database administrators must be prevented from seeing the employees’ social security numbers.
Always Encrypted is a feature designed to protect sensitive data, such as credit card numbers or national/regional identification numbers (for example, U.S. social security numbers), stored in Azure SQL Database, Azure SQL Managed Instance, and SQL Server databases. Always Encrypted allows clients to encrypt sensitive data inside client applications and never reveal the encryption keys to the Database Engine. This provides a separation between those who own the data and can view it, and those who manage the data but should have no access - on-premises database administrators, cloud database operators, or other high-privileged unauthorized users. As a result, Always Encrypted enables customers to confidently store their sensitive data in the cloud, and to reduce the likelihood of data theft by malicious insiders.


Reference:

https://learn.microsoft.com/en-us/sql/relational-databases/security/encryption/always-encrypted-database-engi ne https://learn.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview



View Related Case Study

HOTSPOT (Drag and Drop is not supported)
You have an Azure subscription.
You plan to deploy an app that requires an Azure Data Lake Storage Gen2 account.
You need to recommend which settings to modify during the storage account deployment. The solution must ensure that the data in the account is protected if an attacker gains access to the physical disk that stores the data.
Which two settings should you recommend? To answer, select the appropriate settings in the answer area.
Note: Each correct selection is worth one point.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Box 1: Infrastructure encryption
Enable infrastructure encryption for double encryption of data
Infrastructure encryption can be enabled for the entire storage account, or for an encryption scope within an account.
When infrastructure encryption is enabled for a storage account or an encryption scope, data is encrypted twice — once at the service level and once at the infrastructure level — with two different encryption algorithms and two different keys.
Double encryption of Azure Storage data protects against a scenario where one of the encryption algorithms or keys might be compromised. In this scenario, the additional layer of encryption continues to protect your data.
Box 2: Allow access from
We see: Allow access from: All network
In Firewalls and virtual networks set Allow access from: to Allow public access from specific virtual networks and IP addresses.
Under Exception, check Allow trusted Microsoft services to bypass this firewall.
Note
You can also set Allow access from: to Allow public access from all networks.


Reference:

https://learn.microsoft.com/en-us/azure/storage/common/infrastructure-encryption-enable https://learn.microsoft.com/en-us/azure/databricks/connect/storage/tutorial-azure-storage



View Related Case Study

You are designing a data analytics solution in Azure.
You need to recommend a solution that meets the following requirements:
● Supports multiple analytic languages
● Integrates with Microsoft Power BI
● Works with multiple data stores
● Supports visualizations
What should you include in the recommendation?

  1. Azure SQL Database
  2. Azure HDInsight
  3. Azure Data Lake Storage Gen2
  4. Azure Databricks

Answer(s): D

Explanation:

The best solution among the choices provided is Azure Databricks.
Azure Databricks is a unified, Spark-based analytics platform that specifically meets all the criteria mentioned in your request:
Support for Multiple Analytic Languages: It natively supports Python, Scala, R, and SQL within its collaborative notebook environment.
Integrates with Microsoft Power BI: It has a native connector for Power BI, allowing for interactive visualizations and reporting.
Work with Multiple Data Stores: It integrates seamlessly with a wide range of Azure data stores, including Azure Data Lake Storage (ADLS) Gen2, Azure Blob Storage, and Azure Synapse Analytics.
Support Visualizations: Beyond Power BI integration, it offers built-in visualization tools and dashboards within its own workspace.
Incorrect:
[Not B]
Azure HDInsight supports multiple languages and integrates with Power BI, it is an older, managed cluster service for open-source frameworks (like Hadoop and Spark). Azure Databricks is generally preferred for modern, collaborative analytics due to its superior performance optimizations and ease of use.
[Not C]
Azure Data Lake Storage Gen2 is primarily a storage solution (a repository) rather than a compute or analytics platform.
While it stores data for analysis and integrates with Power BI, it does not "run" analytic languages like Python or R itself; it requires a compute engine like Databricks or Synapse to do so.


Reference:

https://azure.microsoft.com/en-us/blog/category/analytics



View Related Case Study

HOTSPOT (Drag and Drop is not supported)
You are designing a data pipeline that will integrate large amounts of data from multiple on-premises Microsoft SQL Server databases into an analytics platform in Azure. The pipeline will include the following actions:
-Database updates will be exported periodically into a staging area in Azure Blob storage.
-Data from the blob storage will be cleansed and transformed by using a highly parallelized load process.
-The transformed data will be loaded to a data warehouse.
-Each batch of updates will be used to refresh an online analytical processing (OLAP) model in a managed serving layer.
-The managed serving layer will be used by thousands of end users.
You need to implement the data warehouse and serving layers.
What should you use? To answer, select the appropriate options in the answer area.
Note: Each correct selection is worth one point.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Box 1: An Azure Synapse Analytics dedicated SQL pool
Data warehouse
Azure Synapse Analytics is an analytics service that brings together enterprise data warehousing and Big Data analytics. Dedicated SQL pool (formerly SQL DW) refers to the enterprise data warehousing features that are available in Azure Synapse Analytics.

Dedicated SQL pool (formerly SQL DW) represents a collection of analytic resources that are provisioned when using Synapse SQL. The size of a dedicated SQL pool (formerly SQL DW) is determined by Data Warehousing Units (DWU).
Once your dedicated SQL pool is created, you can import big data with simple PolyBase T-SQL queries
Note: The massively parallel processing architecture of Azure Synapse provides scalability and high performance.
Example:
Data warehousing and analytics
This example scenario demonstrates a data pipeline that integrates large amounts of data from multiple sources into a unified analytics platform in Azure.
Architecture

Dataflow
The data flows through the solution as follows:
1. For each data source, any updates are exported periodically into a staging area in Azure Data Lake Storage.
2. Azure Data Factory incrementally loads the data from Azure Data Lake Storage into staging tables in Azure Synapse Analytics. The data is cleansed and transformed during this process. PolyBase can parallelize the process for large datasets.
3. After loading a new batch of data into the warehouse, a previously created Azure Analysis Services tabular model is refreshed. This semantic model simplifies the analysis of business data and relationships.
4. Business analysts use Microsoft Power BI to analyze warehoused data via the Analysis Services semantic model.
Box 2: Azure Analysis Services
Serving layer
Each batch of updates will be used to refresh an online analytical processing (OLAP) model in a managed serving layer.
The managed serving layer will be used by thousands of end users.


Reference:

https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-overview-w hat-is https://learn.microsoft.com/en-us/azure/architecture/example-scenario/data/data-warehouse



View Related Case Study

You have 12 on-premises data sources that contain customer information and consist of Microsoft SQL Server, MySQL, and Oracle databases.
You have an Azure subscription.
You plan to create an Azure Data Lake Storage account that will consolidate the customer information for analysis and reporting.
You need to recommend a solution to automatically copy new information from the data sources to the Data Lake Storage account by using extract, transform and load (ETL). The solution must minimize administrative effort.
What should you include in the recommendation?

  1. Azure Data Factory
  2. Azure Data Explorer
  3. Azure Data Share
  4. Azure Databricks

Answer(s): A

Explanation:

Azure Data Factory (ADF) is the ideal tool for this scenario.
Since you have a mix of SQL Server, MySQL, and Oracle, ADF handles the complexity through Linked Services and Datasets, allowing you to build a unified pipeline for all ten sources.
To minimize administrative effort and bridge the gap between your on-premises network and the cloud, you'll need to use a Self-hosted Integration Runtime (SHIR). You only need to install one SHIR on a single machine (or a cluster for high availability) within your local network to securely push data from all ten databases to Azure Data Lake Storage (ADLS) Gen2.


Reference:

https://learn.microsoft.com/en-us/azure/data-factory/introduction https://www.reddit.com/r/MicrosoftFabric/comments/1axmzy6/continual_data_load_from_on_prem_sql_server _to



Viewing page 31 of 78
Viewing questions 151 - 155 out of 382 questions


Post your Comments and Discuss Microsoft AZ-305 exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!