10 free Microsoft AZ-120 practice questions with the correct answer and a full explanation for each, taken from the CertStash pack of 424 questions. Work through them, then open each answer to check your reasoning.
Get all 424 questions (US$39) · Download these 10 as a PDF
Question 1
You are migrating SAP to Azure. The ASCS application servers are in one Azure zone, and the SAP database server in in a different Azure zone.
ASCS/ERS is configured for high availability.
During performance testing, you discover increased response times in Azure, even though the Azure environment has better computer and memory configurations than the on-premises environment.
During the initial analysis, you discover an increased wait time for Enqueue.
What are three possible causes of the increased wait time? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
Show answer and explanation
Correct answer: C, D, E
C. misconfigured load balancer rules and health check probes for Enqueue and ASCS D. active Enqueue replication E. network latency between the database server and the SAP application servers Increased Enqueue wait times in a cross-zone Azure deployment can result from three root causes. Misconfigured load balancer rules and health check probes prevent proper traffic routing to Enqueue/ASCS servers, causing queuing delays. Network latency between database and application servers in different zones increases round-trip times for Enqueue operations. Active Enqueue replication between zones introduces synchronization overhead and communication delays. A missing Enqueue profile would prevent the system from starting entirely rather than causing performance degradation, and disk I/O during backups would affect the backup process, not Enqueue wait times specifically.
Why the other options are wrong
- A. A missing Enqueue profile would cause startup failure, not increased wait times during operations.
- B. Disk I/O during backup operations affects backup performance, not Enqueue wait times during normal operations.
Question 2
You have an on-premises SAP environment that uses AIX servers and IBM DB2 as the database platform.
You plan to migrate SAP to Azure. In Azure, the SAP workloads will use Windows Server and Microsoft SQL Server as the database platform.
What should you use to export from DB2 and import the data to SQL Server?
Show answer and explanation
Correct answer: A. R3load
R3load is the standard SAP tool designed to export and import data across different database platforms during SAP system migrations. It handles the conversion of data formats between source and target database systems, making it the appropriate choice for migrating from IBM DB2 to SQL Server. R3trans is used for transporting repository objects and is not suitable for bulk data migration. SSMS is a SQL Server management tool without native DB2 connectivity for data extraction. Azure SQL Data Warehouse is a cloud analytics service, not a migration tool.
Why the other options are wrong
- B. Azure SQL Data Warehouse is an analytics platform, not a data migration tool for heterogeneous database conversions.
- C. SQL Server Management Studio cannot directly extract data from DB2 systems.
- D. R3trans transports repository objects and customizations, not bulk database data.
Question 3
You have an SAP environment that is managed by using VMware vCenter.
You plan to migrate the SAP environment to Azure.
You need to gather information to identify which compute resources are required in Azure.
What should you use to gather the information?
Show answer and explanation
Correct answer: A. Azure Migrate and SAP EarlyWatch Alert reports
Azure Migrate provides comprehensive discovery and assessment of on-premises infrastructure, including resource utilization across VMware vCenter environments. SAP EarlyWatch Alert reports provide detailed sizing recommendations and hardware capacity analysis specific to SAP workloads. Together, these tools gather the necessary compute resource information to determine appropriate Azure VM sizes and configurations. Azure Site Recovery is primarily for replication and failover, not sizing assessment. SAP Quick Sizer is for sizing new deployments, not assessing existing environments. SAP HANA system replication and HANA Cockpit are specific to HANA systems, not general SAP ECC sizing.
Why the other options are wrong
- B. Azure Site Recovery is for disaster recovery replication, not capacity assessment. SAP Quick Sizer is for sizing new systems, not existing ones.
- C. SAP Quick Sizer is for new deployments. SAP HANA system replication is for database high availability, not capacity planning.
- D. Azure Site Recovery Deployment Planner assesses replication targets. SAP HANA Cockpit monitors HANA systems specifically, not general resource requirements.
Question 4
You plan to migrate an SAP ERP Central Component (SAP ECC) production system to Azure.
You are reviewing the SAP EarlyWatch Alert report for the system.
You need to recommend sizes for the Azure virtual machines that will host the system.
Which two sections of the report should you review? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
Show answer and explanation
Correct answer: A, C
A. Hardware Capacity C. Hardware Configuration under Landscape The Hardware Capacity section provides CPU, memory, and disk capacity metrics that directly inform VM sizing decisions. The Hardware Configuration section under Landscape details the current hardware specifications and utilization patterns necessary to right-size Azure VMs. Patch Levels indicate support status but not sizing requirements. Database and ABAP Load Optimization provides tuning recommendations rather than sizing guidance. Data Volume Management addresses storage sizing, not compute VM sizing.
Why the other options are wrong
- B. Patch Levels relate to software support status, not compute resource sizing.
- D. Database and ABAP Load Optimization provides performance tuning, not VM sizing recommendations.
- E. Data Volume Management addresses storage capacity, not compute VM sizing decisions.
Question 5
You plan to migrate an SAP environment to Azure.
You need to recommend a solution to migrate the SAP application servers to Azure. The solution must minimize downtime and changes to the environments.
What should you include in the recommendation?
Show answer and explanation
Correct answer: D. Azure Site Recovery
Azure Site Recovery provides agentless or agent-based replication of entire application servers with minimal downtime through failover capabilities. It maintains the server configurations, reduces manual reconfiguration efforts, and supports live migration with near-zero downtime, meeting both requirements. Azure Storage Explorer is a data browsing tool. Azure Import/Export is for bulk offline data transfer of storage blobs. AzCopy transfers data files but does not migrate running application servers with their configurations and services.
Why the other options are wrong
- A. Azure Storage Explorer is a data browsing and management tool, not a server migration solution.
- B. Azure Import/Export is for bulk offline data transfer to Azure Storage, not server application migration.
- C. AzCopy transfers data files between storage locations but does not migrate running application servers or their configurations.
Question 6
You plan to migrate an on-premises SAP development system to Azure.
Before the migration, you need to check the usage of the source system hardware, such as CPU, memory, network, etc.
Which transaction should you run from SAP GUI?
Show answer and explanation
Correct answer: D. OS07N
Transaction OS07N displays current and historical system load information, CPU utilization, memory usage, and network performance metrics from the SAP application server. This transaction provides real-time visibility into hardware resource consumption necessary for capacity planning before migration. SM51 shows application server status. DB01 displays database alerts. DB12 shows database backup information.
Why the other options are wrong
- A. SM51 displays the list of active application servers and their status, not detailed hardware metrics.
- B. DB01 displays database-specific alerts and problems, not system-wide hardware usage.
- C. DB12 shows database backup and archive log information, not current hardware utilization metrics.
Question 7
Your company has an SAP environment that contains the following components:
• SAP systems based on SAP HANA and SAP Adaptive Server Enterprise (SAP ASE) that run on SUSE Linux Enterprise Server 12 (SLES 12)
• Multiple SAP applications
The company plans to migrate all the applications to Azure.
You need to get a comprehensive list of all the applications that are part of the SAP environment.
What should you use?
Show answer and explanation
Correct answer: B. the SAP Solution Manager
SAP Solution Manager maintains a comprehensive repository of all SAP systems, applications, and components running in the landscape, including their dependencies, versions, and configurations. It provides the definitive source for understanding all applications within the SAP environment prior to migration. SAP license information lists purchased software but not installed instances. Data volume management reports address storage sizing. Network inventory focuses on connectivity, not application discovery.
Why the other options are wrong
- A. SAP license information shows purchased products but not necessarily all deployed instances and applications.
- C. Data volume management reports address storage requirements, not comprehensive application and system discovery.
- D. Network inventory and locations focus on infrastructure connectivity, not application landscape discovery.
Question 8
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 migrate an SAP HANA instance to Azure.
You need to gather CPU metrics from the last 24 hours from the instance.
Solution: You query views from SAP HANA Studio.
Does this meet the goal?
Show answer and explanation
Correct answer: B. No
SAP HANA Studio is a development and administration GUI client that provides database monitoring capabilities, but it does not retain historical CPU metrics from the previous 24 hours by default. For historical performance data, you must use SAP HANA Cockpit, which is the comprehensive monitoring and lifecycle management tool with historical metric retention, or query the M_HOST_RESOURCE_UTILIZATION_STATISTICS view directly via SQL, which stores historical data. SAP HANA Studio views show current state but lack the time-series data necessary to retrieve 24-hour historical metrics.
Question 9
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 migrate an SAP HANA instance to Azure.
You need to gather CPU metrics from the last 24 hours from the instance.
Solution: You run SAP HANA Quick Sizer.
Does this meet the goal?
Show answer and explanation
Correct answer: B. No
SAP HANA Quick Sizer is a sizing tool used for capacity planning and hardware recommendations before deployment. It does not gather historical CPU metrics from an existing running instance over a 24-hour period. To collect actual performance metrics from a live SAP HANA instance, you need monitoring and diagnostic tools that can access system performance data, not sizing estimation tools.
Why the other options are wrong
- A. Quick Sizer is designed for pre-deployment sizing estimates, not post-deployment metric collection from running systems.
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 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 migrate an SAP HANA instance to Azure.
You need to gather CPU metrics from the last 24 hours from the instance.
Solution: You use DBA Cockpit from SAP GUI.
Does this meet the goal?
Show answer and explanation
Correct answer: A. Yes
DBA Cockpit is a transaction in SAP GUI that provides database administration and monitoring capabilities for SAP HANA systems. It can access and display historical performance metrics including CPU utilization over specified time periods such as the last 24 hours, making it an appropriate tool for gathering this diagnostic data.
Why the other options are wrong
- B. DBA Cockpit is specifically designed to monitor and analyze SAP HANA performance metrics including CPU data over time.
That was 10 of 424.
The full Microsoft AZ-120 pack has all 424 questions, each with the answer, the explanation and why the other options are wrong, plus a questions-only copy for timed runs. US$39, paid once, with free monthly updates and a pass-or-your-money-back guarantee.