Topic 5: Misc. Questions
Your on premises network contains an Active Directory Domain Services (AD DS) forest.
The forest contains a top level domain, three child domains, and an on-premises server named Server1.
You have a Microsoft Entra tenant. Server1 uses Microsoft Entra Connect Sync to replicate all the user objects from the three child domains to the tenant.
New contractors and employees are onboarded manually by using the Workday cloud- based human resources (HR) application.
You plan to automatically provision accounts for new users in one of the on-piemises child domains and the Microsoft Entra tenant. The provisioning logic for the employees will be
distinct from the provisioning logic for the contractors.
You need to identify the following:
• The minimum number of apps to register in the Microsoft Entra tenant
• The minimum number of Microsoft Entra Connect provisioning agents to deploy
The solution must minimize implementation effort.
What should you identify? To answer, select the appropriate options in the answer area.
NOTE Each correct selection is worth one point.

Correct Options:
The minimum number of apps to register in the Microsoft Entra tenant: 2
You need two enterprise apps in Microsoft Entra ID: one for provisioning employees from Workday and one for provisioning contractors. Each app contains distinct mapping and filtering rules. A single app cannot apply two different logic sets to different user types. Two apps provide clean separation with minimal implementation effort.
The minimum number of Microsoft Entra Connect provisioning agents to deploy: 1
Microsoft Entra Connect Provisioning Agent (for HR-driven provisioning) connects to on-premises AD. A single agent can write users to multiple domains, including child domains, as long as it has network access and appropriate permissions. Since you are provisioning into only one specific child domain, one agent is sufficient.
Incorrect Options:
Apps: 1 - One app cannot maintain two distinct provisioning logic sets (employees vs. contractors) without complex custom logic that increases implementation effort and risk. Microsoft recommends separate apps for different user populations with different mapping requirements.
Apps: 3 - Three apps exceed the minimum requirement. Two apps cleanly separate employees and contractors. A third app would be redundant and unnecessary.
Provisioning agents: 2 - Two agents are unnecessary for a single target child domain. Additional agents would provide high availability but are not required for the minimum solution. The question asks for the minimum number to deploy.
Provisioning agents: 3 - Three agents far exceed the minimum requirement. One agent can write to the target child domain successfully.
Reference:
Microsoft Learn: Tutorial for Workday to AD and Entra provisioning; Provision multiple HR sources; Microsoft Entra Connect Provisioning Agent deployment.
You have an Azure subscription that contains the resources shown in the following table.
Log files from App1 are ingested to App 1 Logs. An average of 120 GB of log data is ingested per day.
You configure an Azure Monitor alert that will be triggered if the App1 logs contain error messages.
You need to minimize the Log Analytics costs associated with App1. The solution must meet the following requirements:
• Ensure that all the log files from App1 are ingested to App 1 Logs.
• Minimize the impact on the Azure Monitor alert.
Which resource should you modify, and which modification should you perform? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Explanation:
You need to minimize Log Analytics costs for 120 GB/day of log data while preserving the ability to trigger alerts on error messages. The Basic Logs data plan offers lower ingestion costs but does not support log-based alerts. The Analytics Logs plan (default) supports alerts but is more expensive. Changing Workspace1 to a commitment tier reduces per-GB cost significantly at high ingestion volumes. Daily caps would block data ingestion, violating the requirement.
Correct Options:
Resource: Workspace1
The Log Analytics workspace (Workspace1) controls pricing tier and data plan settings. App1 is the data source, and App1Logs is the destination table. Cost optimization for log ingestion must be configured at the workspace level, not at the individual app or table level.
Modification: Change to a commitment pricing tier
A commitment tier (formerly capacity reservation) reduces per-GB ingestion costs for volumes above 100 GB/day. At 120 GB/day, a commitment tier (e.g., 100 GB/day or 200 GB/day) provides significant savings over pay-as-you-go. This preserves Analytics Logs data plan, so alerting on error messages continues to work. Daily caps would block ingestion; Basic Logs disables alerting.
Incorrect Options:
Resource: App1 - App Service app does not directly control Log Analytics pricing. It only sends diagnostic logs to Workspace1. Modifying App1 cannot change ingestion costs.
Resource: App1Logs - The Log Analytics table inherits data plan settings from the workspace. You cannot independently modify pricing at the table level without changing workspace configuration.
Change to Basic Logs data plan - Basic Logs has lower ingestion cost but does not support Azure Monitor alerts. Error message alerts would break, violating the requirement to minimize impact on alerts.
Set a daily cap - Daily cap stops data ingestion once the limit is reached. This would cause log loss and missed error alerts, violating the requirement that all log files be ingested.
Reference:
Microsoft Learn: Azure Monitor Logs pricing details; Commitment tiers for Log Analytics; Basic Logs versus Analytics Logs.
Your company has IT, security, and finance departments.
You need to implement a new Azure deployment that will include multiple Azure subscriptions and management groups. The solution must meet the following requirements:
• Ensure that all policies are assigned at the management group level.
• Ensure that all the finance department resources have specific encryption policies applied.
• Ensure that only users in the IT department can create virtual machines in any Azure region.
• Ensure that users in the finance department can create virtual machines in only the East US Azure region.
What is the minimum number of management groups you can create for the planned deployment?
A. 1
B. 2
C. 3
D. 4
Explanation:
You need separate policy application for finance department encryption and region restrictions while keeping IT department creation rights. Management groups inherit policies downward. With two management groups (IT root and Finance root, or a parent with two children), you can assign region restriction policies to Finance group, encryption policies to Finance group, and VM creation permissions to IT users at a higher level or within IT group. One management group cannot differentiate finance restrictions from IT permissions.
Correct Option:
B. 2
Two management groups are the minimum. For example: Parent management group (Root) containing all subscriptions, with policies for IT users to create VMs in any region (assigned at root or IT group). A separate Finance management group under the root, with policies restricting VM creation to East US and enforcing encryption. This separates finance constraints while maintaining common policies at root level.
Incorrect Options:
A. 1 - A single management group applies all policies uniformly to all subscriptions. You cannot restrict finance department VMs to East US while allowing IT department VMs in any region under the same management group without complex conditional policies, which is not a clean separation and may not meet the requirement cleanly.
C. 3 - Three management groups (e.g., Root, IT, Finance) would work but exceeds the minimum. Two management groups suffice: one for finance department resources with restrictive policies, and another for IT and other departments with broader permissions.
D. 4 - Four management groups are unnecessary. You can achieve full separation with two management groups, making four an inefficient and non-minimum answer.
Reference:
Microsoft Learn: Organize your Azure resources with management groups; Policy inheritance in management groups; Azure Policy scope evaluation.
You have 100 Microsoft SQL Server integration Services (SSIS) packages that are configured to use 10 on-premises SQL Server databases as their destinations.
You plan to migrate the 10 on-premises databases to Azure SQL Database
You need to recommend a solution to host the SSlS packages in Azure. The solution must ensure that the packages can target the SQL Database instances as their destinations.
What should you include in the recommendation?
A. SQL Server Migration Assistant (SSMA)
B. Azure Data Catalog
C. Data Migration Assistant
D. Azure Data Factory
You have an Azure subscription that contains 1,000 resources.
You need to generate compliance reports for the subscription. The solution must ensure that the resources can be grouped by department.
What should you use to organize the resources?
A. application groups and quotas
B. resource groups and role assignments
C. Azure Policy and tags
D. administrative units and Azure Lighthouse
Explanation:
To generate compliance reports and group resources by department, you need a way to assign metadata to resources for filtering and a mechanism to enforce compliance. Tags can store department information (e.g., Department: Sales). Azure Policy can then audit or enforce tagging and generate compliance reports based on tag values. This allows grouping resources by department in compliance reports.
Correct Option:
C. Azure Policy and tags
Tags are key-value pairs applied to resources to organize them by department. Azure Policy can enforce tag existence or specific tag values, and Azure Policy compliance reports show which resources comply with tagging rules. You can filter compliance data by department tags to generate department-specific reports. This is the standard Azure approach for organizational grouping and compliance.
Incorrect Options:
A. Application groups and quotas -
Application groups (e.g., in Azure Virtual Desktop) and quotas are for resource allocation and limits, not for organizing arbitrary resources for compliance reporting. They do not provide metadata tagging or compliance enforcement across diverse resource types.
B. Resource groups and role assignments -
Resource groups are logical containers, but moving 1,000 resources into department-based resource groups is rigid and not scalable (a resource can only belong to one group). Role assignments control access, not compliance reporting grouping by department.
D. Administrative units and Azure Lighthouse -
Administrative units are for delegated administration in Microsoft Entra ID (users/groups), not for Azure resources. Azure Lighthouse is for cross-tenant management. Neither helps group resources by department for compliance reports.
Reference:
Microsoft Learn: Use tags to organize Azure resources; Azure Policy compliance reports; Azure Policy initiative for tag enforcement.
You have the resources shown in the following table.
You create a new resource group in Azure named RG2.
You need to move the virtual machines to RG2.
What should you use to move each virtual machine? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Your company, named Contoso, Ltd., has an Azure subscription that contains the following
resources:
• An Azure Synapse Analytics workspace named contosoworkspacel
• An Azure Data Lake Storage account named contosolakel
• An Azure SQL database named contososql1
The product data of Contoso is copied from contososqM to contosolakel.
Contoso has a partner company named Fabrikam Inc. Fabrikam has an Azure subscription that contains the following resources:
• A virtual machine named FabrikamVMI that runs Microsoft SQL Server 2019
• An Azure Storage account named fabrikamsal
Contoso plans to upload the research data on FabrikamVMI to contosolakel. During the upload, the research data must be transformed to the data formats used by Contoso.
The data in contosolakel will be analyzed by using contosoworkspacel.
You need to recommend a solution that meets the following requirements:
• Upload and transform the FabrikamVMI research data.
• Provide Fabrikam with restricted access to snapshots of the data in contosoworkspace1.
What should you recommend for each requirement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Explanation:
The first requirement is to upload data from Fabrikam's SQL Server VM (FabrikamVMI) to Contoso's Data Lake Storage (contosolake1) with transformation during upload. Azure Synapse pipelines (including Copy Data activity and data flows) can connect to on-premises/VM-based SQL Server and transform data before landing in Data Lake Storage. For the second requirement, providing restricted access to snapshots of data in Synapse workspace to an external partner is best achieved by Azure Data Share, which enables sharing datasets with external tenants securely.
Correct Options:
Upload and transform the data: Azure Synapse pipelines
Azure Synapse pipelines support integration runtimes to connect to SQL Server on a VM, and mapping data flows or Copy activity with transformations to convert data formats while moving from SQL Server to Azure Data Lake Storage. This provides a code-free or low-code ETL solution that meets both upload and transform requirements.
Provide restricted access: Azure Data Share
Azure Data Share allows Contoso to share snapshots of data from Synapse workspace or Data Lake Storage with Fabrikam's Azure subscription. It supports granular access controls, snapshot scheduling, and works across Microsoft Entra tenants. Fabrikam receives their own copy of the data, maintaining security and access restrictions.
Incorrect Options:
Azure Data Box Gateway - A physical or virtual device for offline or limited-bandwidth data transfer to Azure. Not appropriate for uploading from a VM that is already online and accessible. Does not provide data transformation capabilities during upload.
Azure Data Share (for upload and transform) - Data Share is for sharing existing data between tenants, not for uploading and transforming data from a source system. It does not perform ETL transformations.
Azure Synapse pipelines (for restricted access) - Synapse pipelines are for orchestration and data movement within or into Contoso's environment, not for securely sharing data snapshots with external partners across tenants without giving them direct access to Contoso resources.
Reference:
Microsoft Learn: Azure Synapse Analytics pipelines; Copy and transform data from SQL Server; Azure Data Share overview and cross-tenant sharing.
You plan to use an Azure Storage account to store data assets.
You need to recommend a solution that meets the following requirements:
• Supports immutable storage
• Disables anonymous access to the storage account
• Supports access control list (ACL)-based Azure AD permissions
What should you include in the recommendation?
A. Azure Blob Storage
B. Azure Data Lake Storage
C. Azure NetApp Files
D. Azure Files
Explanation:
The sensors send data to three IoT Hubs (Hub1 in West Europe, Hub2 and Hub3 in North Europe). Stream Analytics jobs process data closest to the source to reduce latency and cost. Real-time analytics requires processing sensor data near the ingestion points. With two regions involved (West Europe and North Europe), you need at least two Stream Analytics jobs: one for West Europe (Hub1) and one for North Europe (Hub2 and Hub3 combined).
Correct Option:
B. 2
Two Stream Analytics jobs are the minimum. One job in West Europe processes data from Hub1. A second job in North Europe processes data from both Hub2 and Hub3 (one job can read from multiple IoT Hubs in the same region). This minimizes cross-region data transfer costs, reduces latency, and scales dynamically. Development effort is minimized by using two jobs instead of three.
Incorrect Options:
A. 1 -
A single Stream Analytics job can read from multiple IoT Hubs across different regions, but this incurs cross-region data transfer costs and higher latency. The job would be deployed in one region, pulling data from the other region, increasing costs and violating the "minimize costs" requirement.
C. 3 -
Three jobs (one per IoT Hub) is more than the minimum. One job in North Europe can handle both Hub2 and Hub3 since they are in the same region. Three jobs increase management overhead and cost without providing additional benefits.
D. 6 -
Six jobs is far excessive. Each IoT Hub does not require two jobs. There is no scenario in this architecture that would require six Stream Analytics jobs for three IoT Hubs.
Reference:
Microsoft Learn: Azure Stream Analytics job scaling; Input sources for Stream Analytics; Best practices for cost optimization.
You have an Azure subscription.
You plan to deploy a high-throughput transactional workload that will use PostgreSQL.
You need to recommend a managed solution for storing relational data. The solution must
meet the following requirements:
• Support the horizontal scaling of transactional writes by using row-based sharding.
• Minimize administrative effort.

Explanation:
The workload requires horizontal scaling of transactional writes using row-based sharding. Row-based sharding distributes data across multiple nodes based on a shard key. Among Azure PostgreSQL offerings, only Azure Cosmos DB for PostgreSQL (formerly Citus) provides native row-based sharding with distributed tables. Flexible Server and Single Server do not support built-in horizontal sharding for transactional writes.
Correct Options:
Azure service: Azure Cosmos DB for PostgreSQL
This is the only Azure managed PostgreSQL service that natively supports row-based sharding through distributed tables. It uses Citus extension to horizontally partition data across multiple nodes, enabling high-throughput transactional writes. It provides managed scaling with minimal administrative effort compared to self-managed sharding solutions.
Scalability technique: Distributed tables
Distributed tables are the mechanism in Azure Cosmos DB for PostgreSQL that implements row-based sharding. Data is distributed across worker nodes based on a distribution column (shard key). This enables parallelized transactional writes and queries. Other techniques like logical replication or near-zero downtime scaling do not provide native horizontal write scaling.
Incorrect Options:
Azure Database for PostgreSQL flexible server - Supports read replicas and vertical scaling but does not provide built-in row-based sharding for transactional writes. Would require application-level sharding, increasing administrative effort.
Azure Database for PostgreSQL single server - Similar to flexible server, lacks native horizontal sharding. Also near deprecation, not recommended for new high-throughput workloads.
Logical replication - Used for replicating data between PostgreSQL instances for read scaling or migration, not for native row-based sharding of transactional writes across a cluster.
Near-zero downtime scaling - Refers to vertical scaling or storage scaling capabilities, not horizontal distribution of writes across multiple nodes.
Reference:
Microsoft Learn: Azure Cosmos DB for PostgreSQL distributed tables; Choose a PostgreSQL hosting option in Azure.
You have an Azure subscription.
You plan to deploy a monitoring solution that will include the following:
• Azure Monitor Network Insights
• Application Insights
• Microsoft Sentinel
• VM insights
The monitoring solution will be managed by a single team.
What is the minimum number of Azure Monitor workspaces required?
A. 1
B. 2
C. 3
D. 4
Explanation:
Azure Monitor workspaces (specifically Log Analytics workspaces) serve as the central data store for logs from various Azure services. Azure Monitor Network Insights, Application Insights (when configured to use workspace-based mode), Microsoft Sentinel, and VM insights can all send their data to the same Log Analytics workspace. A single workspace can support all these monitoring services simultaneously.
Correct Option:
A. 1
A single Log Analytics workspace can consolidate logs from all four monitoring components. Microsoft Sentinel is explicitly built on top of a Log Analytics workspace. Application Insights supports workspace-based mode to store data in Log Analytics. VM insights and Network Insights both send performance and log data to the same workspace. One workspace is sufficient for a single team to manage.
Incorrect Options:
B. 2 is unnecessary because no isolation requirement is stated. Multiple workspaces might be used for data sovereignty, retention differences, or access segregation, but the question asks for the minimum number with a single management team. One workspace meets all functional requirements.
C. 3 exceeds the minimum. While possible, there is no technical constraint requiring three workspaces for these four services to coexist.
D. 4 is the maximum you might use for full isolation, but the minimum required for the solution to work is one workspace.
Reference:
Microsoft Learn: Design your Azure Monitor Logs deployment; Workspace-based Application Insights; Microsoft Sentinel workspace requirements.
| Page 7 out of 36 Pages |