This question requires that you evaluate the underlined text to determine if it is correct.

This question requires that you evaluate the underlined text to determine if it is correct.

You have an SAP environment on Azure that uses Microsoft SQL server as the RDBMS.

You plan to migrate to an SAP HANA database.

To calculate the amount of memory and disk space required for the database, you can use SAP Quick Sizer.

Instructions: Review the BOLD text, If the makes the stamen correct, select ‘’No change is needed. “ if the statement is incorrect select the answer choice that makes the statement correct.

A. No change is needed.

B. Azure Migrate

C. /SDF/HDB_SIZING

D. SQL Server Management Studio (SSMS)

View Answer

Answer: C

Explanation:

If you want to move an existing deployed system from another relational database management system (RDBMS) to HANA. SAP provides reports to run on your existing SAP system. If the database is moved to HANA, these reports check the data and calculate memory requirements for the HANA instance.

/SDF/HDB_SIZING is a standard Executable ABAP Report available within your SAP system (depending on your version and release level).

ABAP code listing snippet for SAP ABAP Report /SDF/HDB_SIZING

*&——————————-*

*& Report /SDF/HDB_SIZING // ZNEWHDB_SIZE *&

*&——————————-*

*& Estimates the memory requirement in HANA of non-HANA databases * *& When run on HANA, size the database using real memory consumption *& values.

*&——————————-*

*

*

REPORT /SDF/HDB_SIZING LINE-SIZE 101 LINE-COUNT 90

NO STANDARD PAGE HEADING.

DATA: l_version TYPE c LENGTH 6 VALUE ’54’. "54.2

TYPES: ty_para(2) TYPE n,

ty_top(3) TYPE n.

TYPE-POOLS: abap.

DATA: tabname TYPE tabname,

subrc TYPE sy-subrc,

p_prf TYPE abap_bool,

See full code listing within your SAP system using transactions such as SE80 and SE38

Reference:

https://www.se80.co.uk/sapreports/-/-fs-/-fs-sdf-fs-hdb_sizing.htm

https://docs.microsoft.com/en-us/azure/virtual-machines/workloads/sap/hana-sizing