Online Access Free C_HANATEC142 Practice Test

What are the recommended ways to perform a database backup? There are 2 correct answers to this question.

• A.Use the./hdbsetup command
• B.Use SAP HANA Studio
• C.Use SQL commands
• D.Use the BRBACKUP command

You need to replicate data from an SAP ERP production system to SAP HANA.
Where does SAP recommend that you install the productive SAP Landscape
Transformation (SLT) instance?
Please choose the correct answer.

• A.With the SAP ERP system
• B.With the SAP Solution Manager system
• C.On a dedicated server
• D.On the SAP HANA server

A company wants to restrict data access to a specific year for certain users. Which privilege type must you define in SAP HANA to achieve this requirement? Please choose the correct answer.

• A.Package privileges
• B.SQL privileges
• C.System privileges
• D.Analytic privileges

A long-running SQL query issued by an SAP NetWeaver work process also seems to use a lot of system resources.
How can you find out which ABAP module and which SAP NetWeaver user called the query?
Please choose the correct answer.

• A.- Go to the Performance tab of SAP HANA studio
  -
  Check the System load diagram
• B.- In SAP HANA studio, check the session overview
  -Identify the logical CONNECTION ID for the SAP NetWeaver work process
  -Check the columns APPLICATIONSOURCE and APPLICATIONUSER
• C.- Open Transaction Process Overview (SM50) in the SAP NetWeaver system
  -Sort the list by CPU time
  -Select the top entry
  -
  Check the User and Report columns
• D.- Open Transaction Global Work Process Overview (SM66) in the SAP NetWeaver system
  -Sort the list by CPU time
  -
  Select the top entry

Which of the following source data sizes should you use to size SAP HANA memory?
Please choose the correct answer.
Choose one:

• A.Total uncompressed size of tables required for queries
• B.Total compressed size of source database
• C.Total uncompressed size of tables and indexes required for queries
• D.Total uncompressed size of source database