SAP Hana Coe Web Assessment

69 Questions

Settings
SAP Hana Coe Web Assessment

SAP HANA COE Web Assessment practice questions. Last updated June 2018.


Questions and Answers
  • 1. 
    Overview On a service you have some doubts surrounding the certification of the customer's CPU configuration after querying the system view M_HOST_INFORMATION. You decide to verify if their CPU model is certified and supported. What do you check to verify your suspicions?
    • A. 

      You check the overview tab in the HANA studio as it displays whether a piece of hardware is supported or not

    • B. 

      You consult the HANA hardware directory

    • C. 

      The HANA database won't start if a piece of hardware is not certified, so you check the diagnosis files for errors saying "CPU not supported"

    • D. 

      You check the landscape tab in the HANA studio as the CPU column will be blank if the model is not supported

  • 2. 
    Overview If a customer has a single node HANA DB with 512GB of licensed memory with an unenforced license key and is running their HANA instance on a 1TB server. What happens to their system if they exceed their licensed memory?
    • A. 

      The memory can be exceeded but only for nominated reports

    • B. 

      The system will lock until the database is restarted

    • C. 

      The operation of HANA is not affected if memory consumption exceeds the licensed amount

    • D. 

      Unenforced license keys only apply to scale out or distributed systems

  • 3. 
    Overview A HANA DB is running on revision 122.12. It is suffering from a known issue where activating the expensive statements trace with a threshold greater than 1 second results in a crash. The fix for this issue is included in revision 122.15. What type of release is revision 122.5 referred to as?
    • A. 

      A Maintenance Revision

    • B. 

      The Datacenter Service Point

    • C. 

      A Support Package Revision

    • D. 

      A Support Package Stack

  • 4. 
    Architecture Which of the following is true in relation to the sapstartsrv service? (2 correct answers)
    • A. 

      Sapstartsrv retrieves log and trace files when the DB is down

    • B. 

      Sapstartsrv starts the Daemon

    • C. 

      Sapstartsrv starts the other HANA services

    • D. 

      Sapstartsrv is started by the Daemon

    • E. 

      Sapstartsrv starts http(s)connections

  • 5. 
    Architecture What happens when the global allocation limit is almost met and a big memory request is made that would exceed the limit? (2 correct answers)
    • A. 

      Out of memory (OOM) dump occurs when HANA is not able to free any chunk of main memory with sufficient size anymore

    • B. 

      HANA unloads table partitions and columns from main memory in a least recently used (LRU) algorithm fasion

    • C. 

      The Nameserver will be shut down to free memory

    • D. 

      The HANA database crashes and restarts with a higher global allocation limit

  • 6. 
    • A. 

      Savepoints can speed up the restart of a HANA database as the redo logs are only processed from the last savepoint

    • B. 

      A savepoint is overwritten when the next savepoint is successfully completed

    • C. 

      You can recover the database to a consistent state from a savepoint without the need for redo logs

    • D. 

      You always need the redo log to recover the HANA database to a consistent state from a savepoint

    • E. 

      Savepoints have a fixed time interval of 5 minutes

  • 7. 
    Architecture You execute a transaction followed by a commit that inserts 1,000,000 new records into a column store table on a HANA DB with default values set. 10 minutes later an auto merge happens on the table. Which of the following are true in respect of this sequence of events? (3 correct answers)
    • A. 

      During the write operation, log entries were written to log buffers in memory

    • B. 

      The delta merge created new log entires

    • C. 

      During the write operation, log entries were written to the log segments in memory

    • D. 

      During the commit operation, the log entries were flushed to disk synchronously

    • E. 

      A savepoint occurred and HANA moved all changed data from memory to the data volume

  • 8. 
    Architecture A client contacts you to change their address. You update the record in the relevant row store table using SQL in a SQL editor window in the HANA studio. The properties window has Auto Commit set to on. In respect to MVC, which component does this write operation occur in?
    • A. 

      Shadow Page Cache Segment

    • B. 

      Delta Storage

    • C. 

      Transactional Version Memory

    • D. 

      Persisted Segment

  • 9. 
    • A. 

      The pool is memory used by heap allocators and should be considered as the current used memory value by HANA processes

    • B. 

      The pool is memory swapped out from HANA to the OS and is available for use by HANA processes locally

    • C. 

      The pool always equals the used memory value of HANA processes and you manually unload the tables holding this memory

    • D. 

      You understand the pool is just memory allocated from the OS and is not necessarily fully consumed by HANA processes

  • 10. 
    Architecture A customer has a large table that they wish to partition over their 3 slave nodes. They want to partition by year and create 3 partitions for years greater than 2010, years between 2000-2010 and years below 2000. How do you advise they achieve this?
    • A. 

      Partition the table with multi-level partitioning using HASH at 1st level and RANGE at 2nd level

    • B. 

      Partition the table using HASH partitioning

    • C. 

      Partition the table using RANGE partitioning

    • D. 

      Partition the table with multi-level partitioning using RANGE at 1st level and HASH at 2nd level

  • 11. 
    Technical Operations 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? (3 correct answers)
    • A. 

      The partition specification

    • B. 

      The number of partitions

    • C. 

      The delta size for row store tables

    • D. 

      The actual table data

    • E. 

      The delta size for column store tables

  • 12. 
    Technical Operations As part of a service, you log onto a customer's system to view information realted 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? (2 correct answers)
    • A. 

      In the table content tab

    • B. 

      In the table definition tab

    • C. 

      In the Indexserver trance file

    • D. 

      In the expensive statements trace tab

  • 13. 
    Technical Operations You log onto a customer's HANA database and go to the performance tab and select the expensive statements trance sub-tab. You notice there is no information available. What  might be the reason for this?
    • A. 

      The XS engine has crashed and is not running to collect the data

    • B. 

      The expensive statements trace has not been configured

    • C. 

      The SQL trace is not active so no SQL query information is available

    • D. 

      The performance trace is active and only one trace can be active at a given time

  • 14. 
    Technical Operations To access HANA cockpit, there are some prerequisites that need to be met. Which of the following are required to allow access? (3 correct answers)
    • A. 

      The web browser you use to access the HANA cockpit must support SAPUI5

    • B. 

      Prerequisites only apply if accessing HANA cockpit directly in a browser. Once logged into HANA studio you are automatically logged into HANA cockpit.

    • C. 

      The DB user needs to be assigned one of the "sap.hana.admin.roles::Monitoring" or "sap.hana.admin.roles::Administrator" roles

    • D. 

      You can log in as the SYSTEM user if you HANA database is SPS10 or later

    • E. 

      The DB user needs to be assigned both of the "sap.hana.admin.roles::Monitoring" or "sap.hana.admin.roles::Administrator" roles

  • 15. 
    Technical Operations You log into the HANA studio and expand the catalog folder. What can you see within this folder? (3 correct answers)
    • A. 

      List of packages

    • B. 

      Tables

    • C. 

      Views

    • D. 

      Stored procedures

    • E. 

      Virtual tables for remote sources

  • 16. 
    Technical Operations A customer has a large table that several 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. 

      The table can be duplicated and each version only contain the data that each user needs

    • B. 

      You can restrict the data they need to access with an object privilege

    • C. 

      By creating views on the relevant columns and granting SELECT privileges to the different users

    • D. 

      By creating an Analytics privilege on specific rows

  • 17. 
    Technical Operations You create an audit policy for all auditable actions with the audit trail target as the AUDIT_LOG view. Which of the following actions will be recorded in the AUDIT_LOG? (3 correct answers)
    • A. 

      Changes to user authorizations

    • B. 

      Deletion of DB objects

    • C. 

      Access to sensitive information

    • D. 

      HANA DB upgrade steps

    • E. 

      Direct changes to the system configuration files from the file system

  • 18. 
    Performance Analysis You need to analyze a HANA DB with high memory usage of the SQL plan cache and thousands of evictions per hour. You analyze the cache and see that most of the queries have literal values and are to the same tables. What is the recommended solution to this issue?
    • A. 

      Reset the plan cache to recover the used memory

    • B. 

      Increase the size of the SQL cache

    • C. 

      Reduce the number of queries to this table

    • D. 

      Use bind variables in the WHERE clause

  • 19. 
    Performance Analysis As a DBA you set a global statement memory limit of 100GB and a user statement memory limit of 150GB for a user, U1. U1 needs to execute a report that usually consumes roughlt 130GB. What happens when the user, U1 tries to execute this report?
    • A. 

      A composite out of memory dump will occur as the global statement memory limit takes precedence

    • B. 

      The system will hang as the global statement memory limit and a user statement memory limit should not be set at the same time

    • C. 

      The report will execute successfully if it does not exceed the global allocation limit as both parameters cancel each other out

    • D. 

      The report will execute successfully if it does not exceed 150GB as the user statements limit takes precedence

  • 20. 
    Performance Analysis You want to track all queries that exceed a defined threshold. What trace do you activate on the HANA database?
    • A. 

      SQL trace

    • B. 

      Performance trace

    • C. 

      Database trace

    • D. 

      Expensive statement trace

  • 21. 
    Performance Analysis A customer sets a statement memory limit on their HANA DB of 100GB. They observe occasions where queries are terminating at times of low overall memory usage and enquire about a method that allows queries to continue when memory usage is below a defined percentage. What is recommended they apply to achieve this?
    • A. 

      Apply the parameter "statement_memory_limit_threshold"

    • B. 

      Increase the current memory size for the parameter "statement_memory_limit"

    • C. 

      Change the value of the global allocation limit

    • D. 

      Set a higher statement memory limit for different users

  • 22. 
    Performance Analysis You a logged onto a customer's HANA DB through the studio during a service and even simple operations become slower and slower. You begin to check the system to see if there is an issue. Which of the following makes sense to analyze in this situation? (3 correct answers)
    • A. 

      You check the threads tab to see if there are any blocked threads

    • B. 

      You check the SQL plan cache to see if evictions per hour are greater than 1000

    • C. 

      You check to see if the expensive statements trace is active and set to inactive if it was

    • D. 

      You check the load graph to see if there are any CPU spikes

    • E. 

      You check the threads tab to see if there are any long running threads

  • 23. 
    Performance analysis (incorrect) During a Going Live Service, you analyze the SQL cache. You see that there are in excess of 1500 cache evictions per hour on all the hosts and each of them have a used percentage of 99. Each cache is 2GB and the hit ratios are all above 95%. What is your understanding of cache evictions in this context?
    • A. 

      1500 cache evictions per hour are to be expected on scale out system and is considered normal behavior

    • B. 

      The cache may be too small due to a large variety of statements and evictions occur to make space for new plans

    • C. 

      Evictions improve performance as the next execution of a statements related plan benefits from recompilation

    • D. 

      There are a lot of expensive statements as identified by the expensive statements trace that need to be evicted

  • 24. 
    Backup, Recovery & High Availability A HANA DB is configured with system replication between a primary and secondary system. The secondary system has become unavailable and as a result the primary system has become blocked until the secondary system is once again available. What replication mode is configured?
    • A. 

      Asynchronous

    • B. 

      Synchronous

    • C. 

      Synchronous in-memory

    • D. 

      Synchronous full sync

  • 25. 
    Backup, Recovery & High Availability Node 3 crashes in a scale out system with a configuration of 1 master node, 3 slave nodes and 1 standby node. A failover is triggered and the standby node takes over from node 3. What were the sequence of events that lead to the discovery of the crashed host and the automatic host failover?
    • A. 

      Both the name server and the daemon of the crashed host failed to reply to pings from a slave index server

    • B. 

      Only the daemon of the crashed host failed to reply to pings from the master name server

    • C. 

      Both the name server and the daemon of the crashed host failed to reply to pings from the master name server

    • D. 

      Only the name server of the crashed host failed to reply to pings from the master index server

  • 26. 
    Backup, Recovery & High Availability A customer implements system replication between primary and secondary systems. They wish to preload the column store tables on the secondary and ask about the pros and cons of this option. Select 1 pro and 1 con from the below list that you may provide to them (2 correct answers)
    • A. 

      Pro - Shorter performance ramp-up in case of takeover

    • B. 

      Con - Higher memory consumption reduces the likelihood of running non-production systems on the secondary

    • C. 

      Pro - Lower memory consumption allows you to run non-production systems on the secondary

    • D. 

      Con - Longer performance ramp-up in case of takeover

  • 27. 
    Backup, Recovery & High Availability When you make changes to a table the logs are written to log buffers in memory. These need to be persisted to disk in the log volume. Which of the following are true in relation to this process? (2 correct answers)
    • A. 

      Log buffers are written to log segments every 5 minutes by default

    • B. 

      Log buffers are written to log segments when a log buffer becomes full

    • C. 

      Log buffers are written to savepoints when a log buffer becomes full

    • D. 

      Log buffers are written to log segments when a commit entry is written

  • 28. 
    Optional Technologies In the context of a data management strategy, what does data tiering refer to?
    • A. 

      Moving non-hot data to a quality of test system

    • B. 

      Manually unloading all column store data to disk after querying

    • C. 

      Assigning data to various storage areas and storage media often by their temperature classification

    • D. 

      Partitioning a column store tables across 2 or more nodes

  • 29. 
    Optional Technologies You are processing a customer incident for a MDC system and need to log onto the system DB to check some configurations. Which service acts as the SQL port to allow the connection to the system DB?
    • A. 

      Indexserver

    • B. 

      Nameserver

    • C. 

      Xsengine

    • D. 

      Daemon

  • 30. 
    Optional Technologies In a multitenant environment, the System DB does not have its own:
    • A. 

      Daemon

    • B. 

      Name server

    • C. 

      Webdispatcher

    • D. 

      Index server

  • 31. 
    Modelling True or False, SAP HANA report directly on a physical tables and persists the results, also known as materialization.
    • A. 

      True

    • B. 

      False

  • 32. 
    Modelling Which types of operation blocks are available during the creating of a graphical calculation view? (3 correct answers)
    • A. 

      Projection

    • B. 

      Select

    • C. 

      Union

    • D. 

      Update

    • E. 

      Join

  • 33. 
    Modelling True or False, Input and output parameters are not optional with Procedures.
    • A. 

      True

    • B. 

      False

  • 34. 
    Modelling A UNION node allows the data modeller to:
    • A. 

      Filter data from two or more data sources

    • B. 

      Combine data from two or more data sources

    • C. 

      Summaries measures from two or more data sources using aggregation functions like SUM

    • D. 

      To query data from two or more data sources

  • 35. 
    Modelling In Data Modelling terms, Facts are also known as: (3 correct answers)
    • A. 

      Attributes

    • B. 

      Measures

    • C. 

      Key figures

    • D. 

      Metrics

    • E. 

      Dimensions

  • 36. 
    Modelling As of SP11, Attribute Views have been deprecated and replaced with:
    • A. 

      Graphical Calculation Views of type CUBE

    • B. 

      Graphical Calculation Views of type DIMENSION

    • C. 

      Graphical Calculation Views of type CUBE with STAR JOIN

    • D. 

      Analytic Views

  • 37. 
    Modelling Input Parameters can be used: (2 correct answers)
    • A. 

      Within expressions of Calculated Columns

    • B. 

      As an INFIX filter condition in CDS View definition

    • C. 

      To define parameters for join conditions

    • D. 

      To filter data

  • 38. 
    Data Provisioning A customer has some data in a remote source that they need to query within the HANA database. But they do not have plans to migrate this data into HANA for another year. Which of the below methods will allow them to achieve this goal?
    • A. 

      SLT on the target tables

    • B. 

      Synchronous storage replication

    • C. 

      System replication with operation mode logreplay

    • D. 

      SDA (Smart Data Access) with virtual tables

  • 39. 
    Data Provisioning EIM (Enterprise Information Management) is not a component but rather an umbrella term to describe capabilities. EIM is however comprised of 2 components. What are they? (2 correct answers)
    • A. 

      ETL (Extract, Transform, Load)

    • B. 

      SDA (Smart Data Access)

    • C. 

      SDQ (Smart Data Quality)

    • D. 

      Data Services

    • E. 

      SDI (Smart Data Integration)

  • 40. 
    Data Provisioning You are advising a customer on options surrounding the topic of data provisioning. They have recently migrated to HANA and ask about Data Services. Their lead basis team member read that Data Services is built-in HANA component. Do you tell them this is true or false?
    • A. 

      True

    • B. 

      False

  • 41. 
    What 2 types of data does HANA Vora combine?
    • A. 

      Enterprise data and Big Data

    • B. 

      Structured data and Enterprise data

    • C. 

      Unstructured data and Big Data

    • D. 

      SLT data and Big Data

  • 42. 
    A customer is looking to migrate their BW system to HANA. Their BW system currently runs on an Oracle database. They need to estimate how much memory will be required to run their BW system on a HANA database. What do you advise them to do?
    • A. 

      You advise they run the BW sizing report in their Oracle database

    • B. 

      You advise they move the data to their HANA database and then run the BW sizing report in HANA

    • C. 

      You tell them to divide their current data footprint by 7 as HANA has a fixed compression ratio of 1:7 with traditional databases

    • D. 

      You tell them that they need the same memory specifications for HANA as they have in their Oracle DB

  • 43. 
    The database persistence model defines which artefacts? (3 correct answers)
    • A. 

      Analytic Privileges

    • B. 

      Schema

    • C. 

      Calculated Columns

    • D. 

      Views

    • E. 

      Tables

  • 44. 
    In a scale out system with 1 Master Node, 2 Slave Nodes and 1 Standby Node. How many active Index servers are there?
    • A. 

      The master index server and one other slave node's index server are active - 2 index servers total

    • B. 

      An index server is active on each of the nodes - 4 index servers total

    • C. 

      The master and 2 slave index servers are active - 3 index servers total

    • D. 

      Only the master index server is active - 1 index server total

  • 45. 
    When you activate design-time artefacts in the SAP HANA Repository it becomes a runtime object in?  
    • A. 

      The Content Folder

    • B. 

      The local Project Folder

    • C. 

      SAP HANA Catalog

    • D. 

      The Repository Workspace

  • 46. 
    In a Star Schema, the Fact table is joined to the Dimension tables using:
    • A. 

      LEFT OUTER join N..1

    • B. 

      INNER join 1 1

    • C. 

      RIGHT OUTER join N...1

    • D. 

      LEFT OUTER join 1...N

  • 47. 
    A customer wants to migrate their SAP BW system to an on-premise HANA solution but is operating within a strict budget. They have existing hardware that they would like to re-use for the deployment of HANA. What approach will allow them to reduce costs significantly and use existing hardware?
    • A. 

      HANA appliance

    • B. 

      Managed Private Cloud

    • C. 

      Infrastructure as a Service (IaaS)

    • D. 

      Tailored Datacenter Integration (TDI)

  • 48. 
    • A. 

      You log into HDBSQL while using a user key to hide your password and query the view

    • B. 

      While logged onto the host you additionally log into HDBUSERSTORE and query the view

    • C. 

      While logged onto the host you additionally log into HDBSQL and query the view

    • D. 

      Log onto the host as theĀ adm user and query the view from the initial prompt

    • E. 

      You log into HDBSQL using your usual HANA DB user and query the view

  • 49. 
    On a service you have some doubts surrounding the certification of the customers CPU configuration after querying the system view M_HOST_INFORMATION. You decide to verify if their CPU model is certified and supported. What do you check to verify your suspicions?
    • A. 

      You check the landscape tab in the HANA studio as the CPU column will be blank if the model is not supported

    • B. 

      You consult the HANA hardware directory

    • C. 

      You check the overview tab in the HANA studio as it displays whether a piece of hardware is supported or not

    • D. 

      The HANA database won't start if a piece of hardware is not certified, so you check the diagnosis files for errors saying "CPU not supported"

  • 50. 
    Analysis You want to track all queries that exceed a defined threshold. What trace do you activate on the HANA database?
    • A. 

      SQL trace

    • B. 

      Performance trace

    • C. 

      Database trace

    • D. 

      Expensive statement trace

  • 51. 
    Select the ones you like
    • A. 

      Option1

    • B. 

      Option2

    • C. 

      Option3

    • D. 

      Option4

  • 52. 
    • A. 

      You use HASH partitioning to distribute the records to different partitions of the table

    • B. 

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

    • C. 

      You delete old records from the table to bring the number of records below the fixed threshold for this alert type

    • D. 

      You use RANGE partitioning to create a partition on each of the nodes

  • 53. 
    Log backups contain the information stored in the log segments in the log area and should be backed up to an external location automatically in a production environment. What are log backups required for? (2 correct answers)
    • A. 

      To roll forward committed transactions to ensure no data loss since the last successful backup

    • B. 

      To allow global savepoints commence before a data backup

    • C. 

      They are required for recovery of the row store

    • D. 

      They contain the custom configuration files

    • E. 

      To free up space in the file system that contains the log volumes

  • 54. 
    Which 2 of the following conditions should be met for a row store reorganisation to be recommended when a row store has become fragmented? (2 correct answers)
    • A. 

      Row store has more than 500 tables

    • B. 

      Row store size greater than 10 GB

    • C. 

      Row store size greater than 100 GB

    • D. 

      Free space ratio greater than 90%

    • E. 

      Free space ratio greater than 30%

  • 55. 
    You experience a hanging situation on your 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 and execute the relevant trace in the trace configuration tab of the HANA studio

    • B. 

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

    • C. 

      In the HANA studio you go to the threads tab and select the capture all running threads option

    • D. 

      Execute the relevant SQL script from the system information tab in the HANA studio and adjust the timeframe

  • 56. 
    What is one of the main differences between the load graph in the HANA studio and the load graph in the HANA cockpit?
    • A. 

      The studio load graph is restricted to the past 24 hours for data displayed whereas the cockpit load graph is not

    • B. 

      In the studio load graph, you can select the 'show jobs' option to highlight jobs that correlate with a resource spike

    • C. 

      In the cockpit load graph, you can select the 'show jobs' option to highlight jobs that correlate with a resource spike

    • D. 

      The scale of how you view the data on the graph can only be changed in the cockpit load graph

  • 57. 
    Which of the following additional compression types are used in HANA? (3 correct answers)
    • A. 

      Clustered

    • B. 

      Inherited

    • C. 

      Spatial

    • D. 

      Prefixed

    • E. 

      Indirect

  • 58. 
    When creating a role, you may create this role in the run-time environment or the design-time environment. Which of the following statements are true about each of these methods? (2 correct answers)
    • A. 

      The run-time environment method decouples the creator from the role. So, if the creator is deleted, the role still exists

    • B. 

      The design-time environment method makes it easy to import and export the role as an object

    • C. 

      The design-time environment method decouples the creator from the role. So, if the creator is deleted, the role still exists

    • D. 

      The design-time environment method is easier and faster

  • 59. 
    A customer has a BW system with large daily loading of data into some of their BW tables. Which of the following statements is true in terms of the recommended merge configuration the customer should apply to the target tables?
    • A. 

      Smart merge will prevent a merge on the target table during data loading

    • B. 

      Auto merge will merge tables when the defined record limit is exceeded and makes the process faster

    • C. 

      All delta merges should be disabled for the target tables and manually carried out after data loading has finished

    • D. 

      Disable auto merge and allow a critical merge to take care of the merge process

  • 60. 
    • A. 

      All incremental data backups since latest differential backup

    • B. 

      Only the latest incremental data backup since latest differential backup

    • C. 

      Latest full data backup before specified time

    • D. 

      Log entries in the log area

    • E. 

      Latest full data backup

  • 61. 
    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. 

      SSO (Single Sign On)

    • B. 

      HDBUSERSTORE

    • C. 

      HDBKEYSTORE

    • D. 

      HDBPASSVAULT

  • 62. 
    The diagnosis files contain trace files that are continuously filled with information about system operations. In a scale out system with 1 master and 2 slave nodes. Which of the following statements are true? (2 correct answers)
    • A. 

      Alert trace files are only for the indexserver on the slave nodes as business data is stored in these

    • B. 

      Each service on each host has its own set of trace files

    • C. 

      Only the indexserver, nameserver and xsengine have their own trace files

    • D. 

      Each service also has its own alert trace file for high priority messages

    • E. 

      There is a trace file for the nameserver on the master node only

  • 63. 
    Where does the SAP LT replication server create logging tables?
    • A. 

      In the source system

    • B. 

      In the SAP HANA database

    • C. 

      On the SLT system

    • D. 

      In the target system

  • 64. 
    Analytic Privileges are designed to:
    • A. 

      Restrict all users access to data from an Information View

    • B. 

      Restrict users access to different portions of the data from the same Information View

    • C. 

      Restrict certain users SELECT privilege on schemas

    • D. 

      Restrict users from seeing any Information Views within a Package

  • 65. 
    Within the context of Multitenant Database Containers, each database is self-contained and fully isolated with its own: (3 correct answers)
    • A. 

      Set of database users

    • B. 

      SID (System Identification)

    • C. 

      HANA instance

    • D. 

      Traces and logs

    • E. 

      Backups

  • 66. 
    A query is taking 2 minutes longer to execute than previous executions. You decide that a graphical representation of this queries execution would be helpful for analysis. What do you perform to achieve this?
    • A. 

      Performance trace

    • B. 

      Load graph in the HANA cockpit

    • C. 

      Plan Visualizer

    • D. 

      Explain plan

  • 67. 
    There are 2 lock types for application transaction in HANA. What are they? (2 correct answers)
    • A. 

      Read/Write ID Semaphore

    • B. 

      Object

    • C. 

      Mutex

    • D. 

      Record

  • 68. 
    One of the benefits of MDC is a strong separation of users and data between the tenants. However, to support cross-application reporting, cross-database queries are possible. What does a user, U2 in a tenant DB, DB2 need to be done to access objects in another tenant DB, DB1?
    • A. 

      A user, U1 needs to be created in DB1 with user, U2 in DB2 as a remote identity

    • B. 

      The target objects need to be replicated from DB1 to DB2

    • C. 

      The user, U2 is copied from DB2 to DB1 which allows access to the objects

    • D. 

      The statement in the question is incorrect as cross-database queries are not possible in MDC

  • 69. 
    The different services start up in a specific sequence. What is the name for the process which determines this sequence?
    • A. 

      Linux unified bootloader

    • B. 

      Runlevel

    • C. 

      Daemon

    • D. 

      Webdispatcher