Amazon
Avaya
Checkpoint
Cisco®
CompTIA
CrowdStrike
EC-Council
EXIN
Fortinet
Google
ISC
ISC2
ITIL®
Juniper
Microsoft
Okta
Palo Alto Networks
Salesforce
All Vendors
  1. Home
  2. Microsoft
  3. AZ-120

Microsoft AZ-120 Exam (page: 5)
Microsoft Planning and Administering Azure for SAP Workloads
Updated on: 25-Dec-2025

Viewing Page 5 of 53
AZ-120 PDF 412 Questions

You have an on-premises deployment of SAP on DB2.

You plan to migrate the deployment to Azure and Microsoft SQL Server 2017.

What should you use to migrate the deployment?

  1. db2haicu
  2. SQL Server Migration Assistant (SSMA)
  3. DSN1COPY
  4. Azure SQL Data Sync

Answer(s): B

Explanation:

You can migrate IBM Db2 databases to Azure SQL Database, by using SQL Server Migration Assistant for Db2.
Incorrect:
Not A: Db2 high availability instance configuration utility (db2haicu) is a text-based utility that you can use to configure and administer your highly available databases in a clustered environment.
Not C: You can use DSN1COPY to copy data from an image copy of the data sets of a table space to the data sets of a table space on the same subsystem or another subsystem.



You have an on-premises SAP production landscape.

You plan to migrate to SAP on Azure.

You need to generate an SAP Early Watch Alert report.

What should you use?

  1. Azure Advisor
  2. SAP HANA Cockpit
  3. SAP Software Provisioning Manager
  4. SAP Solution Manager

Answer(s): A

Explanation:

You can size the target Azure environment for the migration.
Note: SAP EarlyWatch Alert is an automatic service analyzing the essential administrative areas of an SAP system. Alerts indicate critical situations and give solutions to improve performance and stability.
Incorrect:
Not B: SAP HANA Cockpit, aptly named after the control-center of an aircraft, serves as a single point of access for managing SAP HANA systems. The cockpit provides tools for database administration and monitoring, user management, system starts and stops, and system configuration.

Not C: Software Provisioning Manager offers the execution of many system provisioning tasks and covers a broad range of platforms and products, both on the ABAP and the Java technology.
Not D: SAP Solution Manager (sometimes referred to by admins as "SolMan") is an application lifecycle management (ALM) platform used to implement, maintain, and integrate SAP systems; troubleshoot issues; and keep things running securely, cleanly, and smoothly.



HOTSPOT (Drag and Drop is not supported)

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Hot Area:

  1. See Explanation for the Answer.

Answer(s): A

Explanation:



Box 1: Yes
Set up synchronous database replication through Oracle Data Guard between the databases to ensure consistency and allow low RTO & RPO service times in case if individual failures.

Box 2: Yes
Oracle Database 12c Release 2 (12.2) is certified on Microsoft Windows Server 2016 (Standard, Datacenter, and Essentials Editions), which includes support for the database client, server, and Oracle Real Application

Clusters.
Organizations can run SAP applications with Oracle databases on the same code base on Unix, Linux, and Windows operating systems.

Box 3: Yes



You migrate an on-premises instance of SAP HANA that runs SUSE Linux Enterprise Server (SLES) to an Azure virtual machine.

You project that in two years, you will replace the virtual machine with a larger virtual machine within the same flexibility group.

You need to recommend solutions to minimize HANA deployment costs during the next three years. The solutions must not affect the availability SLAs.

Which two solutions should you recommend? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

  1. Azure Spot instance
  2. a three-year reservation that has instance size flexibility
  3. a one-year reservation that has capacity priority
  4. Azure Hybrid Benefit
  5. a one-year reservation that has instance size flexibility

Answer(s): B,D

Explanation:

B: If you already have a SUSE Linux Enterprise Server subscription through the Azure Marketplace, convert your Azure subscription to one- or three-year Azure Reservations for SUSE Linux Enterprise Server with Azure Reserved Virtual Machine Instances (RIs) for significant cost savings.
Discount applies to different VM sizes for SUSE plans
Like Reserved VM Instances, SUSE plan purchases offer instance size flexibility. This means that your discount applies even when you deploy a VM with a different vCPU count. The discount applies to different VM sizes within the software plan.
D: Azure Hybrid Benefit is a licensing benefit that helps you to significantly reduce the costs of running your workloads in the cloud. It works by letting you use your on-premises Software Assurance-enabled Windows Server and SQL Server licenses on Azure. And now, this benefit applies to RedHat and SUSE Linux subscriptions, too.



DRAG DROP (Drag and Drop is not supported)

You have an on-premises SAP landscape that uses a DB2 database and contains an SAP Financial Accounting (SAP FIN) deployment. The deployment contains a file share that stores 50 TB of bitmap files.

You plan to migrate the on-premises SAP landscape to SAP HANA on Azure (Large Instances) and Azure Files shares. The solution must meet the following requirements:

Minimize downtime.

Minimize administrative effort.

You need to recommend a migration solution.

What should you recommend for each resource? To answer, drag the appropriate services to the correct resources. Each service 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.

Select and Place:

  1. See Explanation for the Answer.

Answer(s): A

Explanation:



Box 1: SAP Database Migration option (DMO) with System Move
Database Migration Option (DMO)
Scenario:
You want to migrate your existing SAP ABAP system to the SAP HANA database Use the database migration option (DMO) of the Software Update Manager (SUM):
it combines SAP upgrade and database migration to SAP HANA in one tool.

Benefits:
Migration steps are simplified.
System update, Unicode Conversion (*), and database migration are combined in one tool
(*: only possible for a target based on 7.40)
Business downtime is reduced.
The source database remains consistent, so a fast fallback is possible.

Incorrect:
* Azure Migrate
Azure Migrate is a Microsoft service that helps an enterprise assess how its on-premises workloads will perform, and how much they will cost to host, in the Azure public cloud. While Azure Migrate helps with

planning a cloud migration, it does not actually transfer on-premises virtual machines (VMs) to the Azure cloud.

* Data Migration Assistant (DMA) enables you to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality on your new version of SQL Server. It recommends performance and reliability improvements for your target environment.

Box 2: Azure Data box Gateway
Azure Data Box Gateway is a storage solution that enables you to seamlessly send data to Azure.

Data Box Gateway is a virtual device based on a virtual machine provisioned in your virtualized environment or hypervisor. The virtual device resides in your premises and you write data to it using the NFS and SMB protocols. The device then transfers your data to Azure block blob, page blob, or Azure Files.



You have an on-premises SAP NetWeaver application server and SAP HANA database deployment.

You plan to migrate the on-premises deployment to Azure.

You provision new Azure virtual machines to host the application server and database roles.

You need to initiate SAP Database Migration Option (DMO) with System Move.

On which server should you start Software Update Manager (SUM)?

  1. the virtual machine that will host the application server
  2. the virtual machine that will host the database
  3. the on-premises database server
  4. the on-premises application server

Answer(s): D

Explanation:

Software update manager on source system.

Overview on SUM procedure
1. Plan your maintenance activity (Maintenance Planner)
2. Download the SUM and the documentation from http://support.sap.com/sltoolset
3. Extract the archive to a folder on the primary application server of your SAP system
4. Update SAP Host Agent to latest patch level; configure SAP Host Agent (see guide);
5. Connect from your local PC via browser
6. Configure the SUM, especially point to the stack.xml as result of Maintenance Planner
7. Execute the maintenance on your system
8. If adequate, provide feedback to SAP using the prepared form in SUM reference.



You have an on-premises SAP NetWeaver deployment. The deployment has a DB2 data store that contains a 5-TB SAP database.

You plan to migrate the deployment to SQL Server on an Azure virtual machine.

You need to optimize the performance of transaction log write operations during the migration. The solution must NOT affect the I/O quota of the virtual machine.

What should you do?

  1. Place the transaction logs on the temporary disk.
  2. Place the transaction logs on a striped volume of Premium SSD disks.
  3. Place the transaction logs on an Ultra disk.
  4. Enable the write cache for the disk that hosts the transaction logs.

Answer(s): B

Explanation:

The placement of the database files and the log and redo files and the type of Azure Storage you use, is defined by IOPS, latency, and throughput requirements. Specifically, for Azure premium storage to achieve enough IOPS, you might be forced to use multiple disks or use a larger premium storage disk. If you use multiple disks, build a software stripe across the disks that contain the data files or the log and redo files. In such cases, the IOPS and the disk throughput SLAs of the underlying premium storage disks or the maximum achievable IOPS of standard storage disks are accumulative for the resulting stripe set.
Incorrect:
Not C: For DBMS deployments, we recommend Azure premium storage, Ultra disk or Azure NetApp Files based NFS shares (exclusively for SAP HANA) for any data, transaction log, or redo files. It doesn't matter whether you want to deploy production or nonproduction systems.



HOTSPOT (Drag and Drop is not supported)

You have an on-premises deployment of SAP HANA that contains a production environment and a development environment.

You plan to migrate both environments to Azure.

You need to identify which Azure virtual machine-series to use for each environment. The solution must meet the following requirements:

Minimize costs.

Be SAP HANA-certified.

What should you identify for each requirement? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Hot Area:


  1. See Explanation for the Answer.

Answer(s): A

Explanation:



Box 1: D-Series
General purpose compute
The D-series Azure VMs offer a combination of vCPUs, memory, and temporary storage able to meet the requirements associated with most production workloads.

Example workloads include many enterprise-grade applications, e-commerce systems, web front ends, desktop virtualization solutions, customer relationship management applications, entry-level and mid-range databases, application servers, gaming servers, media servers, and more...

Box 2: M-Series
M-Series
Memory optimized virtual machines
The M-series family of Azure virtual machines are memory optimized and are ideal for heavy in-memory workloads such as SAP HANA. The M-Series offer up to 4 TB of RAM on a single VM. In addition, these VMs offer a virtual CPU count of up to 128 vCPUs on a single VM to enable high performance parallel processing.

Example workloads include SAP HANA, SAP S/4 HANA, SQL Hekaton and other large in-memory business

critical workloads requiring massive parallel compute power.

Incorrect:
* N-Series

GPU enabled virtual machines
The N-series is a family of Azure Virtual Machines with GPU capabilities. GPUs are ideal for compute and graphics-intensive workloads, helping customers to fuel innovation through scenarios like high-end remote visualization, deep learning, and predictive analytics.

The N-series has three different offerings aimed at specific workloads:

- The NC-series is focused on high-performance computing and machine learning workloads. The latest version--NCsv3--features NVIDIA's Tesla V100 GPU.
- Etc.

Example workloads include simulation, deep learning, graphics rendering, video editing, gaming and remote visualization.



Viewing Page 5 of 53



Share your comments for Microsoft AZ-120 exam with other users:

patricks 10/24/2023 6:02:00 AM

passed my az-120 certification exam today with 90% marks. studied using the dumps highly recommended to all.
Anonymous