Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

HANA 1 > Technical Operations > Flashcards

Technical Operations Flashcards

1
Q

What are some of the main tools used for admin, monitoring and RCA of HANA

A
  1. SAP HANA Cockpit
  2. DBA Cockpit for HANA
  3. HDBSQL - command line
  4. SAP Solution Manager
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Which of the following customer specific SAP HANA configuration files (*. ini files) exist in Linux in the custom config directory

A

Files with parameter values that deviate from SAP delivered default values

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Where can you monitor more than one SAP HANA system in the SAP HANA studio

A

System Monitor

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Which of the below user can access HANA system via HTTP/HTTPS applications and doesn’t have access to create objects in schema in HANA database

A

Restricted user (Restricted users are those users who access HANA system with some applications and they don’t have SQL privileges’ on HANA system. When these users are created they don’t have any access initially. If we compare restricted users with Standard users - Restricted users can’t create objects in HANA database or their own Schemas. They don’t have access to view any data in database as they don’t have generic Public role added to profile like standard users. They can connect to HANA database only using HTTP/HTTPs)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

You log into the HANA studio and expand the catalog folder. What can you see within this folder

A
  1. Tables
  2. Views.
  3. Stored procedures
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

A part of a service, you log onto a customer’s system to view information related to a table that causes CPU spikes when queried. You want to check if there are any indexes associated with the table and the actual table data. How do you check both these things?

A

In the table definition tab & the table content tab

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

When we view the table definition for a distributed table in a scale out system and select the Runtime Information tab in the HANA studio, which of the following can we see information about

A

The delta size for column store tables
The number of partitions
The partition specification

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

The delta of a rowstore table with automerge disabled grows considerably after data loading. You manually perform a delta merge and them query this table. After querying you no longer need this table in RAM and manually unload it. Which is true of the these actions

A

A delta merge can only be performed on column store tables

Row store tables must always reside in RAM

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

You are the DBA of a scale out HANA DB that is receiving frequent low priority alerts relating to the number of records for some column store tables. You don’t see any problem with the number of records in these tables and there are no performance issues with reports querying them. What is the logical next step

A

You increase the thresholds for the occurrence of this type of alert to more meaningful value

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

You log onto a customers HANA database and go to the performance tab and select expensive statements trace sub-tab. You notice there is no information available. What might be the reason

A

The expensive statements trace has not been configured.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

You experience a hanging situation on you HANA DB and SAP support ask you to generate 3 sets of runtime environment dumps at 5 minutes intervals the next time the issue occurs. Upon reoccurrence of the issue, how do you generate these requested runtime dumps

A

Configure the collection of diagnosis information in the diagnosis files tab of the HANA studio

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

To access HANA cockpit there are some prerequisites that need to be met. Which of the following are required to allow access

A
  1. You can log in as the SYSTEM user if your HANA database is SPS10 or later
  2. The DB user needs to be assigned one of the “sap.hana.admin.roles::Monitoring” or “sap.hana.admin.roles::Administrator” roles
  3. The web browser you use to access the HANA cockpit must support SAPUI5
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

During an audit your HANA studio and r/3 connections are not working and you need to query the AUDIT_LOG view. You decide to query this view through the host. Which of the following steps would allow you to perform this action

A
  1. While logged onto the host you additionally log into HDBSQL and query the view
  2. You log into HDBSQL while using a user key to hide your password and query the view
  3. You log into HDBSQL using your usual HANA DB user and query the view
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

You want to log into the HDBSQL command line tool but do not wish to type your password into the console as it will be visible. What can you use to securely encrypt and store your password without having to explicitly enter it on screen

A

HDBUSERSTORE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Which of the following tools can be used for User Administrations

A

SAP HANA Cockpit or hdbsql

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

When creating a role you may create this role in the run-time enviornment. Which of the following statements are true about each of these methods.

A
  1. The design-time environment method decouples the creator from the role. So, if the creator is deleted, the role still exists.
  2. The design-time enviornment method makes it easy to import and export the role as an object
17
Q

A user, U1 creates a backup role, R1 in the catalog. U1 grants the role R1 to another user, U2. Granting privileges are provided so U2 can grant this role to an additional user, U3. U1 leaves the company and U1 is dropped. U2 still has the role R1 but U3 does not. Is this statement true or false?

A

False

18
Q

A customer has a large table that a number of end users need to access to obtain complete records. However, end users have different requirements and should only access data relevant to their roles. How may a customer achieve this

A

By creating an Analytic privilege’s on specific rows.

19
Q

You create an audit policy for all auditable actions with the audit trail targets as the AUDIT_LOG view. Which of the following actions will be recorded in the AUDIT_LOG

A
  1. Deletion of DB objects
  2. Access to sensitive information
  3. Changes to user authorizations
20
Q

How do you avoid specifying user and password in the command line

A

hdbuserstore

21
Q

You cannot force all clients with the SAP HANA database through the SQL interface to use a secured connection. True or False

A

False

22
Q

Which of the following actions can be audited by SAP HANA

A
  1. Changes to system configurations

2. Create or drop user, and create or drop role

23
Q

Which of the following privilege’s allow read access to data in SAP HANA information models depending on certain values or combination of values

A

Analytic Privilege’s

24
Q

Which of the following statements is true for the SAP HANA preinstalled role (SAP_Internal_HANA_Support) for support cases

A

It can only be granted further system privilege’s

HANA 1 (8 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions