hana100

Which recent trends have triggered the need for a next-generation data processing platform? Choose the 3 correct answers. Increase in connectivity of people and devices. Separation of transactional processing and analysis processing to dedicated servers. Increase in use of mobile devices. Massive growth in data volume.

Transactional processing and analysis are now coming back together to support a simpler landscape and enable real time decision making removing the need to move copies of the data from one system to another: More and more people and devices are becoming connected (think about IoT). Mobile device usage is on the increase and also the volume of data continues to rise at a staggering rate. True. False.

Which recent technology innovations have triggered the opportunity to build a next-generation data processing platform? Choose the correct answers. Faster disk access. Multi-core processing. Larger memory availability.

We are moving away from disk access and towards memory based data storage and processing using multi-core processors. Memory is now larger and also cheaper that even before and this is a key enabler of the next generation data processing platform. True. False.

SAP HANA provides excellent performance for data intense applications because it stores pre-aggregated data for fast access to results. Determine whether this statement is true or false. True. False.

SAP HANA does not store pre-aggregated data. The in-memory database is able to aggregated data on the fly from the most granular data and still achieve great performance. True. False.

What are advantages of column store tables versus row store tables? Choose the 3 correct answers. Data footprint is automatically reduced through compression. Only the columns required for processing are actually loaded to memory. Columns can be partitioned to improve performance. They are optimized for fast writes and updates to records.

Column store tables are optimized only for read-intense analytical processing, not transactional processing where not just read but also write to tables is needed. Column store tables also use automatic compression to reduce the footprint and we only need to load columns that are required into memory for processing. Also, you can partition column tables to get better performance when the tables are large. True. False.

Why do we still need a disk layer when SAP HANA is referred to as an in-memory database? Choose the 2 correct answers. To store data that has been unloaded from memory when memory becomes full. To hold the delta store for newly-arrived records. To enable full database recovery in the event of a power failure. To store data that is frequently used.

The disk layer is still needed to off-load low priority data from memory to disk when memory is full. It is also used to store periodic snapshots of memory in case we lose power and need to recover memory from the last saved snapshot. The delta store is an area of memory not disk. Memory is always used to store frequently used data to speed up loading to the CPU. True. False.

What is a multistore table? Choose the correct answer. 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.

A multistore table is a new feature of SAP HANA 2.0, where partitions can be spread across memory and extended storage to support better performance on aged data. It is not some kind of hybrid table that can hold data in row and column orientation. It is not a table that can be shared across multiple instances of HANA. True. False.

Active/active-read enabled mode allows applications to redirect read-intense workloads to a secondary redundant read-only HANA node? Determine whether this statement is true or false. True. False.

A secondary redundant read-only HANA node is used to continuously capture and replay the database log from a primary HANA node mainly for data recovery scenarios. But the secondary redundant node can now also be used for any read-intense tasks as it is always a direct copy of the primary node. So, off-loading this work from the primary HANA balances the workloads and increase overall performance. True. False.

Which tables are automatically compressed? Choose the correct answer. Row. Virtual. Column.

Column tables are compressed. Row tables are not compressed and virtual tables never store data. True. False.

Why might customers choose to implement SAP HANA Cloud? Choose the 3 correct answers. Reduced administration effort on customer side. Easy to scale. Fast deployment. Manage updates to the platform.

SAP HANA Cloud is managed by SAP and partners and so the administration effort on the customers side is minimal. SAP HANA Cloud is easy to scale because you can choose your own CPU and memory and can change this at anytime very easily. SAP HANA Cloud can be deployed quickly using a simple interface. Customers do not manage the updates, this is done only by SAP. True. False.

What is meant by SAP HANA Tailored Data Center Integration? Choose the correct answer. The customer creates a customized hardware platform on which to install SAP HANA, by reusing existing and SAP certified hardware components. Partners provide cloud infrastructure on which SAP HANA can be installed. Partners provide a fully installed SAP HANA on certified hardware for use onpremise.

Tailored Data Centre Integration enables customers to reuse their existing hardware. Tailored Data Centre Integration is not a partner provided cloud infrastructure or even a fully installed SAP HANA on certified hardware to use on-premise. True. False.

Which are key roles of an SAP HANA project? Choose the 4 correct answers. Change management consultant. Application developer. Data architect. Security expert. Modeler.

What methods can you use to size a SAP HANA database system? Choose the 2 correct answers. Use the SAP Quick Sizer website. Use the The SAP HANA Hardware Directory website. Use the ABAP report RSPFPAR. Use the ABAP report /SDF/HDB_SIZING.

SAP HANA sizing can be performed using the SAP Quick Sizer website and/or ABAP report /SDF/HDB_SIZING. True. False.

What are scale-out scenarios with SAP HANA? Choose the 2 correct answers. Provision of extra redundant standby servers that can be switched to in case of hardware failure. Deployment of low-cost generic servers to support high volume data streaming applications. Use of multiple servers to increase data storage capacity.

Scale-out is the use of redundant standby servers that we can switch over to in case of primary server failure. It is also the use of multiple servers to increase data storage capacity. True. False.

Which features are supported by the SAP HANA platform lifecycle management tools? Choose the 2 correct answers. Adding or removing additional SAP HANA hosts. Creating and deploying SAP HANA CDS views. Installing or updating an SAP HANA database system. Performing SAP HANA database backups.

The SAP HANA platform lifecycle management tools can be used for adding or removing SAP HANA hosts and to install or update a SAP HANA system. True. False.

What is the correct SAP HANA Maintenance Strategy? Choose the correct answer. A new release every 6 months and 3 months maintenance support. new release every year and 2 years maintenance support. A new release every 6 months and 2 years maintenance support.

SAP HANA gets a new release every year, and this new release gets 2 years maintenance support. True. False.

Why do we model in SAP HANA? Choose the 2 correct answers. To push data-intensive processing away from the application and to the database. To develop reusable data processing logic in the database. To design an efficient data storage architecture.

We push data-intensive processing away from the application and down to the database to obtain the best performance. Core modeling in HANA encourages reuse of data processing logic. Core modeling is used to develop calculation views for to create a virtual layer. Data storage in not included in the virtual layer. True. False.

What are valid types of calculation view? Choose the 3 correct answers. Dimension. Cube. Cube with star schema. Dimension with star schema.

If I need to write custom SQL to present a complex data source to a calculation view, which SAP HANA object do I use? Choose the correct answer. Procedure. Table Function.

Procedures cannot be used to present a data source to a calculation view, only table functions can do that. True. False.

What do we implement to restrict access to specific data rows of a calculation view? Choose the correct answer. SQL Permission. Authorization Object. Analytic Privilege.

SQL permissions only secure the database object, not data values. Authorization object is an ABAP object, not used in SAP HANA. Analytic Privilege is used to define security around rows (data). True. False.

In SAP HANA Text Analysis, why would you use the Voice of Customer dictionary? Choose the correct answer. 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.

Voice of Customer ir a standard dictionary used in sentiment analysis that can identify expressions that customers may use to describe how they feel about products or services. True. False.

Why would an organization implement SAP HANA Spatial? Choose the correct answer. To enrich core ERP data with geographic insight. To identify unhappy customers who need a response. To determine how closely related two customers are.

SAP HANA Spatial enriches ERP data with geographic insight. Unhappy customers would be identified using Text Analysis. How closely related customers are, is something you could find using SAP HANA Graph. True. False.

Which of these provide the algorithms that can be used with SAP HANA predictive analysis? Choose the correct answers. EML. APL. PAL. SDA.

EML, APL and PAL can all provide algorithms for SAP HANA predictive analysis. Another approach, not mentioned, is to use the R language for custom algorithm building. SDA is used for defining virtual tables that connect to remote sources. True. False.

In SAP HANA Text Analysis, why would you use Voice of Customer dictionary? Choose the correct answer. 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.

SAP HANA Graph Processing powers real-time, high-performance business charts, and dashboards. Determine whether this statement is true or false. True. False.

Graph Processing is not related to charts and dashboards, but is used to model and process data that is best described using a network. Examples would be supply chains or social networks where many entities are highly connected. True. False.

What are key capabilities of SAP HANA Analytics Cloud (SAC)? Choose the 3 correct answers. Landscape monitoring. Predictive. Business Intelligence. Planning.

Landscape monitoring is not a capability of SAC. Predictive, Business Intelligence, and Planning are capabilities of SAC. True. False.

Which of the following does SAP HANA use to connect to reporting tools? Choose the 3 correct answers. IDOC. ODBC. JDBC. ODBO.

In SAP HANA, cold data is stored in HANA Native Storage Extension (NSE). Determine whether this statement is true or false. True. False.

Native Storage Extension is used to manage warm data. Cold data is stored outside of SAP HANA perhaps in Hadoop or SAP IQ. True. False.

What are typical characteristics of SAP HANA data replication? Choose the 2 correct answers. Virtualization. Duplicate data. Real-time. Continual streaming. Significant transformations.

Data replication with SAP HANA is typically the duplication of data in real time with no changes to data. True. False.

SAP SLT can be used for real-time replication from SAP and also non-SAP sources. Determine whether this statement is true or false. True. False.

You can use SAP SLT for real-time replication from SAP and also non-SAP sources. True. False.

What are features of SDA? Choose 2 the correct answers. Automatic data type translation. Data cleansing. Evaluation and execution of push-down possibilities to remote sources. Merging data from multiple sources.

SDA does not support data cleansing or merging of multiple data sources. True. False.

Which of the following file types can be loaded using the flat file import wizard of Web IDE? Choose 3 the correct answers. CSV. TXT. XLS. XLSX.

You can load CSV, XLS and XLSX but not TXT files using the flat file import wizard of Web IDE. True. False.

What are features of SAP Business Suite powered by SAP HANA? Choose the 2 correct answers. Includes Embedded Analytics. ABAP is replaced with JAVA. Combine operational analytics and transaction processing. Performance improvement.

Embedded Analytics are only relevant for SAP S/4HANA. Business Suite powered by SAP HANA uses SAP HANA Live. ABAP is still used. Business Suite powered by SAP HANA now combines operational analytics and transaction processing and you get a boost in performance. True. False.

What are features of SAP S/4HANA? Choose the 2 correct answers. Optimized for SAP HANA but maintains compatibility with other databases. Embedded Analytics. Rewritten ABAP code optimized for SAP HANA. SAP HANA Live included to provide real time operational analytics.

SAP S/4HANA runs only on the SAP HANA database. ABAP code has been completely rewritten so it works optimally with SAP HANA. SAP HANA Live is relevant only for Business Suite on SAP HANA. S/4HANA uses Embedded Analytics to provide real time operational analytics. True. False.

What are the tasks of the ABAP developer in an SAP HANA implementation? Choose the 3 correct answers. Adjust migrated ABAP code so it functions correctly on SAP HANA. Look for opportunities to use ABAP code that works on any database. Speed up existing ABAP applications using SAP HANA optimizations. Develop new ABAP applications that exploit SAP HANA advanced capabilities.

Amongst other things, ABAP developers are responsible for adjusting migrated ABAP code so it functions correctly on SAP HANA, speeding up existing ABAP applications using SAP HANA optimizations and developing new ABAP applications that exploit SAP HANA advanced capabilities. ABAP developers do not look for opportunities to use ABAP code that works on any database. Code should always be written to use only native SAP HANA database features. There will be no other database that needs to be considered when writing ABAP code. True. False.

For ABAP applications running on SAP HANA, the recommended approach is to bring data to code. Determine whether this statement is true or false. True. False.

For ABAP applications running on SAP HANA, the recommended approach is to bring code to data. True. False.

Which tool is used for XS Advanced application development? Choose the correct answer. SAP HANA Web-based Workbench. SAP Web IDE for SAP HANA. SAP HANA Studio.

SAP Web IDE for SAP HANA is used for XS Advanced application development. SAP HANA Studio and Web-based Workbench are used only XS classic application development only. True. False.

Applications developed with XS classic must be migrated to XSA before they can run in SAP HANA 2.0. Determine whether this statement is true or false. True. False.

SAP HANA 2.0 supports XS classic applications without adjustment; they do not need to be migrated to XS Advanced. True. False.

What does XS Advanced application development use for source code management? Choose the correct answer. HDI. Node.JS. Git. Cloud Foundry.

Git is the XS Advanced application development use for source code management HDI is used to manage the deployment of run-time objects. Node.JS is a programming language. Cloud Foundry is the open source framework adopted by XS Advanced and is used to provide architecture consistency across cloud developments. True. False.

What are valid user interfaces for SAP HANA Cockpit? Choose the correct answer. SSH terminal. Web browser. Eclipse IDE.

SAP HANA Cockpit is a browser based application. True. False.

Which of the following services are SAP HANA core services? Choose the correct answers. Name server. XS advanced runtime. Extended store server. Preprocessor server.

The SAP HANA core services are: Name server, index server, compile server, preprocessor server, SAP web dispatcher and SAP start service. All the other services are dependant on the installed components or options. True. False.

The SAP HANA core services are: ( All the other services are dependant on the installed components or options). Name server. Index server. Compile server. Preprocessor server. SAP web dispatcher. SAP start service.

Which file system files can be encrypted by SAP HANA? Choose the 3 correct answers. Data Volumes. Linux kernel configuration files. Log Volumes. Configuration Ini files. Log Backups.

SAP HANA can encrypt data Volumes, log volumes and data and log backups, Not the configuration Ini files and the Linux kernel, these not. True. False.

Which of the following statements about the SAP HANA Authorization Framework are correct: Choose the 3 correct answers. User can be assigned to groups. Privileges can be assigned to groups. Roles can be assigned to roles. Privileges can be assigned to users.

About the SAP HANA Authorization Framework: Privileges can be assigned to groups. Determine whether this statement is true or false. True. False.

What are the three tools that might be used in a migration to SAP HANA? Choose the 3 correct answers. Database Migration Option of the Software Update Manager. Software Provisioning Manager. SAP Landscape Replication Server. SAP HANA Migration Assistant.

SAP HANA Migration Assistant is not a tool used in a database migration to SAP HANA, this is a tool used to migrate HANA development content from HANA XS to HANA XS Advanced. True. False.