Which recent trends have triggered the need for a next generation data processing? (Choose 3 answers). Increasing connectivity of people and devices. Move transactional processing and analysis to separate servers for better scalability. Increase in use of mobile devices. Massive growth in data volume.
Which recent technology innovations have triggered the opportunity to build a next generation data processing platform? (Choose 2 answers). Faster disk access Multi-core processing Larger memory availability.
What are the key features of SAP HANA? (Choose 3 answers). In-memory database Automatic compression of data Removes the need for cache Combined OLTP and OLAP processing on one platform.
Which are true statements? (Choose 3 answers). SAP HANA runs on Intel x86 and SPARC hardware platforms. SAP HANA runs on Unix. SAP HANA can be installed only by certified engineers for production purposes. Customers can re-use their own certified hardware components in an SAP HANA
system. SAP HANA is available in the cloud or on premise, or a combination of both.
SAP HANA 2.0 is the ‘stability’ release and its use case is to support mission critical applications where frequent upgrades are not desirable. True False.
Where is SDI used? (Choose 2 answers). Data cleansing. Data transformation. Data streaming. For data loading.
How many processing tiers do you usually find in a native SAP HANA application stack? 1 2 3.
What is XS? A native, lightweight application server An optional engine to handle excessive data loads A data cleansing engine A user interface.
Why did SAP move from XS to XSA? (Choose 2 answers). To move to Cloud Foundry architecture to allow flexible application deployment
options To include ABAP as a key development language for native SAP HANA applications To implement micro-services architecture To provide better source code management tools inside SAP HANA.
What are the two views in the Web IDE for SAP HANA?
(Choose 2 answers). Database Explorer Development Catalog.
In SAP HANA Studio, what would you find in a Package? (Choose 3 answers). Calculation Views Analytic Privileges Procedures Tables.
In Web IDE for SAP HANA, what can I create in a HDB module? (Choose 3 answers). Calculation View Analytic Privilege HTML file Flowgraph.
What is a role of the SAP HANA Cockpit? To provide KPIs to help focus on business performance To provide key system performance information for one or more HANA instances To provide an application developer collaboration hub.
What are advantages of column store tables? (Choose 3 answers). Data footprint is automatically reduced through compression Only the columns required are actually loaded to memory Columns can be partitioned They are optimized for high-volume read/write transactional processing.
Row store tables are more efficient when there is a lot of repeating data values in columns. True False.
Why do we still need a persistent layer? (Choose 2 answers). To store data that has been unloaded from memory To hold the delta store for newly-arrived records To enable full database recovery if we have a power failure To store data that is frequently used.
What is a multistore table? A table that can hold data in row and column orientation A table that can distribute its partitions across memory and extended storage tiers A table that can be shared across multiple instances of HANA.
Active/active-read enabled mode allows applications to redirect read-intense workloads
to a secondary HANA? True False.
What is a multi-target application (MTA)? An application built with SAP HANA XS Classic (XS) that supports on-premise and
cloud deployments An application built with SAP HANA XS Advanced (XSA) that supports on-premise
and cloud deployments.
What are the two storage components used to restore the database in case of power failure? (Choose 2 answers). Log area Data volume Memory Delta store.
What is scale-out? (Choose 2 answers). Use of standby servers in the event of hardware failure Use of remote servers to store archived data that is rarely used Use of commodity servers that are used in high volume steaming applications Use of multiple servers to spread processing and improve performance.
SAP HANA security services include which of the following? (Choose 4 answers). Audit logging Authentication Encryption Antivirus Protection Authorization.
What is the role of core modeling in SAP HANA? (Choose2 answers). To push data-intensive processing up to the application to obtain the best
performance To develop reuseable data processing logic in the database To simplify applications.
What are valid types of calculation view? (Choose 3 answers). Dimension Cube Cube with star schema Dimension with star schema.
If I need to create multiple, tabular output structures from an SQLscript, which HANA
modeling object do I use? Procedure Function.
What do we implement to restrict access to specific data rows of a calculation view? SQL permission Authorisation object Analytic privilege.
Which SAP solution is used with SAP HANA Live? SAP S/4HANA SAP Business Suite SAP Ariba.
Which of these is used to build the virtual data model for SAP S/4HANA? ABAP CDS SAP HANA Live Universe SAP HANA CDS.
What SAP HANA spatial type would you most likely use to represent the State of Colorado
on a visual application? Polygon Line Point.
In SAP HANA Text Analysis, why would you use the ‘Voice of Customer’ dictionary? To extract the sentiment from customer feedback on social media To extract common entities such as company, country, currencies, and so on,
found in documents To identify close matches in words and expressions, to catch misspellings.
What must I create to develop a predictive model? Calculation View Predictive Analysis Library Flowgraph Procedure.
SAP HANA Graph Processing powers real-time, high-performance business charts and
dashboards. True False.
In data temperature management, cool data is stored in HANA Extended Storage. True False.
What is SAP Enterprise Architecture Designer? A tool to support sizing of an SAP HANA solution A tool used to define a data loading job A tool to support the build of a logical data model A tool used to simulate a work load on different HANA hardware configurations.
What are typical characteristics of SAP HANA data replication? (Choose 2 answers). Virtualization Duplicate data Real-time Streaming.
SAP SLT can be used for real-time replication from SAP and non-SAP sources. True False.
What are components of SAP HANA EIM?
(Choose 2 answers). SDI SDA SDS SDQ.
What are features of SDA? (Choose 2 answers). Automatic data type translation Data cleansing Evaluation and execution of push-down possibilities to remote sources Merging data from multiple sources.
Which of the following are correct statements relating to the flat file import function of SAP HANA Studio? (Choose 3 answers). The new table always has a 1:1 mapping between the file and table columns. The supported file types for upload are .csv, and .txt. When loading new data in a table that already contains data, the new data is
appended to the existing data. Renaming of columns and changing data types is allowed when loading data to new
HANA tables.
What are the database query languages used by SAP HANA? (Choose 2 answers). ODBC JDBC MDX SQL ABAP.
What are features of Business Suite on SAP HANA?
(Choose 2 answers). Embedded Analytics for operational analytics ABAP is replaced with JAVA Combine operational analytics and transaction processing Massive performance improvement.
What are features of SAP S/4HANA? (Choose 2 answers). Optimized for SAP HANA but maintains compatibility with other platforms Embedded Analytics Rewritten ABAP code optimized for SAP HANA SAP HANA Live provides real time operational analytics.
To connect SAP Analysis Edition for Excel, you need to create a secure connection in SAP
BusinessObjects Enterprise. True False.
Which of these does SAP HANA use to connect to BI tools? (Choose 3 answers). IDOC ODBC JDBC ODBO.
In which key areas can we expect there to be improvements when running SAP BW on SAP HANA?
(Choose 2 answers). Tighter security Data loading performance Superior data quality Reporting performance.
In SAP BW, when we refer to mixed modeling, what do we mean? Integration of classic BW models such as InfoSets or InfoCubes with SAP HANA
Calculation views Integration of SAP HANA optimized BW models such as ADSOs or OpenODS views
with SAP HANA Calculation views Integration of models from BW on non-HANA databases combined with SAP HANA
optimized BW models.
Where will you find the Data Distribution Optimizer? SAP HANA Studio SAP BW/4HANA SAP HANA Data Warehousing foundation.
Which interface client is used for XSA application development? SAP HANA Web-based Workbench SAP Web IDE for SAP HANA SAP HANA Studio SAP Web IDE.
Applications developed with XS must be migrated to XSA before they can run in SAP
HANA 2.0. True False.
|
