hanatech-17-kanshi

Which view in SAP HANA studio do you use to add additional users?. Navigator view. Quick Launch view. Properties view. Console view.

Which of the following are characteristics of a design-time role? (2 answers). It is revoked if the grantee user is deleted. It is granted and revoked directly by an administrator. It is transportable between systems. It is granted through the execution of stored procedures.

Which of the following can be monitored in SAP Solution Manager system monitoring? (3 answers). Alert status of SAP HANA internal alerting. Host level monitoring. Availability of SAP HANA services. Expensive SQL statements. User-specific traces.

Which of the following is influenced by the audit level?. The information that is printed with the audit log entry. The order of the audit log entries in the audit log. The amount of data transferred to SAP Solution Manager. The messages that are sent to the security administrator.

Which of the following components need a server certificate when you configure the SAP　HANA Automated Update function? (2 answers). Host agent. Update Manager. SAP HANA studio. SAP HANA database.

Which of the following can you do in the SAP HANA studio and also in the DBA Cockpit? (3 answers). Monitor an SQLDBC trace. Display the statuses of database resources. view the tables in the _SYS_STATISTICS schema. Execute system recovery. mplement backup scheduling.

Which of the following can be imported into and exported from SAP HANA studio? (3 answers). Models. Tables. Landscape. Variants. SQL statements.

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?. 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. 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. Go to the Performance tab of SAP HANA studio ➡Check the System load diagram. Open Transaction Global Work Process Overview (SM66) in the SAP ➡NetWeaver system.Sort the list by CPU time ➡Select the top entry.

Which tools can you use to monitor the query time from SAP HANA?. SQL Trace. Performance tab of the System Monitor. Central Management Console. Event Viewer.

Which of the following users allow you to install SAP HANA studio on a Windows client platform? (2 answers). Domain users with administrator privileges. Local users with administrator privileges. <SID>ADM users without administrator privileges. Local users without administrator privileges.

How can you find out which SAP HANA parameters have been changed in your system? (2 answers). By checking the configuration tab of the Administration Console in SAP HANA studio. By running the SQL query select * from "PUBLIC"."M_INIFILE_CONTENTS" where layer_name !='DEFAULT'. 'By running the SQL query select * from "PUBLIC"."M_CONFIGURATION" where options !='DEFAULT'. By checking the indexserver trace file covering the last system startup.

You want to make sure that all data accesses to a specific view will be logged in the audit　trail. As part of an update of the database schema, the view is dropped and recreated　under the same name.What is the consequence for auditing?. Auditing continues to work for the view. Auditing needs to be set up again for the recreated view. The audit log-object references must be reinitialized. The audit policy needs to be reactivated.

In the SAP HANA studio, in which tab can you find information about the performance of　queries?. Diagnosis Files. Alerts. System Information. Trace Configuration.

Where do you check log and trace files in SAP HANA studio?. Administration Editor Diagnosis Files tab. administration Editor System Information tab. Modeler Diagnosis Files tab. Administration Editor Performance tab Diagnosis Files tab.

SAP Support needs to access a customer's SAP HANA studio remotely. Which entry must the client maintain in SAP Service Marketplace?. Master index server. Name server. Statistics server. Preprocessor server.

You have exported a system landscape from an SAP HANA studio and imported it into a　different SAP HANA studio.What information must you provide to make the imported landscape work?. Passwords for all connections. Connection path. Server instance numbers. Server host names.

Which of the following are required to monitor SAP HANA in SAP Solution Manager?. SMD agent running on SAP HANA. Host agent running on SAP HANA. Host agent running on SAP Solution Manager. SMD agent running on SAP Solution Manger.

What is the correct communication data flow between diagnostics in SAP Solution Manager and SAP HANA in the monitor scenario?. Solution Manager SMDAgent HostAgent SAP HANA. Solution Manager HostAgent SMDAgent SAP HANA. Solution Manager SMDAgent SAP HANA. Solution Manager HostAgent SAP HANA.

Which of the following traces provides information about past SQL query runtime performance including the values of parameters?. Expensive statements trace. Performance trace. User-specific trace. SQL trace.

Which of the following traces is active by default in SAP HANA?. Database trace. Performance trace. Expensive statements trace. SQL trace.

Which of the following can you use to analyze an expensive SQL statement? (2 answers). Open the Plan Visualizer. Open the Plan Explanation. Open the hdbcons tool. Open the SQL Plan Cache.

You are reviewing the execution plan of an SQL statement. You want to find out which plan operators (POPs) have been executed in parallel and for how long each of them has been active. How　can you accomplish this?. Use the Visualize Plan functionality in the SAP HANA studio. Use Job Progress in the SAP HANA studio. Use Performance Trace in HDB admin. Use EXPLAIN (graphically) in the DBA Cockpit.

Which of the following must you configure to enable monitoring of SAP HANA in DBA Cockpit?. A database connection in DBA Cockpit. 'The CCMS connection in DBA cockpit. 'A database connection in the table DBCON. The CCMS agent in SAP HANA.

Application users report that a query sometimes runs much slower than usual. You suspect　that high system load is causing the slower query execution.Which of the following can you use to review overall system resource utilization at the time of query　execution?. SAP HANA Studio Administration Console->Performance LOAD. SAP HANA Studio System Monitor Sessions. DBA Cockpit (DBACOCKPIT) Current Status Alerts. DBA Cockpit (DBACOCKPIT) Performance Expensive.

Where do you check log and trace files in SAP HANA studio?. 'Administration Editor Diagnosis Files tab. Administration Editor System Information tab. Administration Editor Performance tab. Diagnosis Files tab Modeler Diagnosis Files tab.

In the navigator tree of the SAP HANA studio, how can you find out which indexes are defined for table CUST_DATA from the SALES schema? There are 2 correct answers to this question. Content node SALES schema node Tables folder double-click on the table CUST_DATA. Content node SALES schema node Tables folder right-click on the table CUST_DATA Open Definition. 'Content node SALES schema node Tables folder simple on the table CUST_DATA Open Definition. Content node SALES schema node Tables folder right-click on the　'table CUST_DATA Open Content.

Which of the following SAP HANA tools is used to collect diagnostic information?. fullSystemInfoDump.py. landscapeHostConfiguration.py. hdbnsutil. hdbsql.