SAP HANA Questions
In which programming languages can you create procedures in SAP HANA? There are 2 answers to this question. a) R b) SQLScript c) L d) JavaScript
a. R b. SQL Script
51. The virtual data model for SAP S/4HANA is based on which of these? Please choose the answer. a) ABAP CDS b) SAP HANA Live c) SAP HANA CDS d) Universe
a. ABAP CDS
What are the four SAP HANA platform services? There are 4 answers to this question. a) Application Services b) Database Services c) Processing Services d) Security Services e) Integration Services
a. Application Services b. Database Services c. Processing Services e. Integration Services
SAP HANA security services include which of the following? There are 4 answers to this question. a) Audit logging b) Antivirus Protection c) Encryption d) Authorization e) Authentication
a. Audit Logging c. Encryption d. Authorization e. Authentication
What is the recommended way to create full-text indexes? Please choose the answer. a) Core Data Services b) Procedures c) User-defined functions d) SQL statements in the SQL console
a. Core Data Services
Which are of the following languages supported by SAP HANA Graph are optimized for graph processing? There are 2 answers to this question. a) Cypher Query Language b) GraphScript c) SQL Script d) SQL
a. Cypher Query Language b. GraphScript
Which spatial data formats can you import into SAP HANA? There are 2 answers to this question. a) ESRI shapefiles b) GeoJSON c) Scalable Vector Graphic (SVG) d) Well-Known Text (WKT)
a. ESRI Shapefiles d. Well- Known Text (WKT)
What can a variable be used for? Please choose the answer. a) Filtering b) Call a procedure in SQL Script c) Calculated column expression d) Currency conversion
a. Filtering
53. When creating a system connection in SAP HANA Studio, which of these is essential information? There are 3 answers to this question. a) Instance b) URL c) A valid user and password d) Host
a. Instance c. A valid user and password d. host
In SAP BW, when we refer to mixed modeling, what do we mean? a) Integration of SAP HANA optimized BW models such as ADSOs or OpenODS views with SAP HANA Calculation views b) Integration of SAP NetWeaver Components into complex SAP HANA BW models c) Integration of models from BW on non-HANA databases combined with SAP HANA optimized BWmodels d) Integration of classic BW models such as InfoSets or InfoCubes with SAP HANA Calculation views
a. Integration of SAP HANA optimized BW models such as ADSOs or OpenODS views with SAP HANA Calculation views
What is the SAP HANA Application Function Library (AFL)? There are 2 answers to this question. a) Repository of ready-made predictive algorithms b) Repository of connections that can be used by business functions c) Repository of ready-made business functions d) Repository of ready-to-run applications that are powered by SAP HANA
a. Repository of ready-made predictive algorithms c. Repository of ready-made business functions
45. Which business intelligence tool can publish storyboards? Please choose the answer. a) SAP Analysis for Microsoft Office b) SAP Lumira, designer edition c) SAP BusinessObjects Analysis, edition for Microsoft Office d) SAP BusinessObjects Web Intelligence
a. SAP Analysis for Microsoft Office
54. What should you use to create tables in an HDI container? There are 2 answers to this question. a) SAP Enterprise Architecture Designer b) Database Explorer c) SQL Console d) Core Data Services (CDS)
a. SAP Enterprise Architecture Designer d. Core Data Dervices (CDS)
49. The company asks you to get data from IoT sensors. Which SAP tools could you use? There are 3 answers to this question. a) SAP HANA Remote Data Sync (RDSync) b) SAP Landscape Transformation Replication Server c) SAP HANA streaming analytics d) SAP SQL Anywhere e) SAP HANA smart data access (SDA)
a. SAP HANA Remote Data Snyc (RDSync) c. SAP HANA streaming analytics d. SAP SQL Anywhere
48. Which data provisioning tools can use SAP HANA adapters? There are 2 answers to this question. a) SDA b) SAP HANA streaming analytics c) SDI d) SAP Replication Server
a. SDA c. SDI
What are components of SAP HANA EIM? There are 2 answers to this question. a) SDI b) SDQ c) SDA d) SDS
a. SDI b. SDQ
If we change the transaction "Laura buys 10 apples" to "Laura buys 10 green apples," how would we store the color green? Please choose the answer. a) Store green as an attribute. b) Store green as a spatial data type. c) Store green as a measure. d) Store green as a CDS view.
a. Store green as an attribute
Identify the object that adds a WHERE clause to the query. Please choose the answer. a) Variable b) Attributes c) Modeler d) Input parameter
a. Variable
In SAP BW/4HANA, what do you use instead of an InfoCube? Please choose the answer. a) Advanced DataStore Object b) CompositeProvider c) InfoObject d) Open ODS View
a. advanced Data Store Object
What is the default node for a calculation view of type cube? Please choose the answer. a) Aggregation node b) Star join node c) Projection node d) Join node
a. aggregation note
What type of input parameters do you use to choose the data from a field in the current table? Please choose the answer. a) Column b) Value help c) Derived from table d) Direct
a. column
In which direction do you build calculation views when including the source tables in Join nodes? Please choose the answer. a) From the Join nodes up to the semantics node b) From the Semantics node up to the default node c) From the Semantics node down to the Join nodes d) From the Join node down to the default node
a. from the join nodes up to the semantic node
From where does the Extract Semantics feature get the definition of hierar- chies? Please choose the answer. a) From the underlying dimension views b) From the table data sources c) From the SQL view data sources d) From the current calculation view
a. from the underlying dimension views
Refactoring is used with which of the following actions? Please choose the answer. a) Improving your modeling design b) Documenting c) Translating d) Deployment
a. improving your modeling design
Which recent trends have triggered the need for a next generation data processing platform? There are 3 answers to this question. a) Increase in use of mobile devices b) Massive growth in data volume c) Increasing connectivity of people and devices d) Move transactional processing and analysis to separate servers for better scalability
a. increase in use of mobile devices b. massive growth in data volume c. increasing connectivity of people and devices
Why is an integrated deployment approach preferred over the side-car approach to SAP HANA Live? There are 2 answers to this question. a) It offers a simplified landscape. b) It provides a quick start for customers using Business Suite on non HANA databases. c) Data is available in real time using SLT. d) There is no data movement.
a. it offers a simplified landscape d. there is no data movement
How does SAP S/4HANA embedded analytics differ from SAP HANA Live? There are 2 answers to this question. a) It uses ABAP CDS views. b) Authorizations are at the application level. c) Authorizations are at the database level. d) It uses SAP HANA calculation views.
a. it uses ABAP CDS views b. Authorizations are at the application level
Which are features of a calculated column? There are 2 answers to this question. a) It's a column in the result set. b) Its calculations are persisted. c) It's created in the output area. d) It's created in the Semantics node.
a. its a column in the result set c. its created in the output area
What information can you find in the Plan Graph? There are 2 answers to this question. a) Number of records returned in each step b) Execution engines used c) Time taken for each step d) SQL Plan Cache
a. number of records returned in each step c. time taken for each step
If I need to create multiple, tabular output structures from an SQLscript, which HANA modeling object do I use? Please choose the answer. a) Procedure b) Function c) None of these d) Both Procedure and Function
a. procedure
What performance techniques should you implement to improve the performance of SAP HANA information views? There are 3 answers to this question. a) Push down aggregations to SAP HANA. b) Minimize the transfer of data between the execution engines. c) Investigate partitioning of large tables. d) Perform calculation before aggregation in your analytic views. e) Apply filters as late as possible.
a. push down aggregations to SAP HANA b. Minimize the transfer of data between the execution engines c. investigate partitioning of large tables
Which join types are available in a Join node of a calculation view? There are 2 answers to this question. a) Referential joins b) Cross joins c) Spatial joins d) Temporal joins
a. referential joins c. spatial joins
A column table definition includes a spatial column that has the VALIDATION FULL property. You execute an SQL statement to insert a geometry into this column. The statement fails. Which of the following are possible reasons for the failure? There are 2 answers to this question. a) The geometry is an ST_POLYGON where the last defined point is not the same as the first one. b) The geometry is an ST_MULTIPOLYGON that specifies only one polygon. c) The geometry is an ST_MULTIPOLYGON where the second polygon is completely contained in the first one. d) The geometry is an ST_POLYGON that has an inner ring that is completely inside the outer ring.
a. the geometry is an ST_POLYGON where the last defined point is not the same as the first one c. the geometry is an ST_MULTIPOLYGON where the second polygon is completely contained in the first one
44. You have copied a design-time file from a source folder to a target folder that has the same namespace setting. In which of the following scenarios will a build of the copy design-time file be successful? There are 2 answers to this question. a) The source design-time file has never been built. b) The build of the copy design-time file will always be successful c) The source design-time file has been deleted from the source folder in the meantime. d) The source design-time file has been built once but the built has failed.
a. the source design-time file has never been built d. the source design-time file has been built once but the build has failed
For what tasks would you use the Where-Used feature in SAP HANA? Please choose the answer. a) To find all places where an information model is used b) To find all places where translations exist c) To find all places where an information model has been deployed d) To find all places where a developer updated information models
a. to find all places where an information model is used
What is a role of the SAP HANA Cockpit? Please choose the answer. a) To provide key system performance information for one or more HANA instances b) To provide KPIs to help focus on business performance c) To secure the SAP HANA Database d) To provide an application developer collaboration hub
a. to provide key system performance information for one or more HANA instances
What is scale-out? There are 2 answers to this question. a) Use of standby servers in the event of hardware failure. b) Use of multiple servers to spread processing and improve performance. c) Use of commodity servers that are used in high volume steaming applications. d) Use of remote servers to store archived data that is rarely used.
a. use of standby serves in the event of hardware failure b. use of multiple serves to spread processing and improve performance
When do you use the hidden attribute in a dimension calculation view? Please choose the answer. a) When you want to hide an attribute that is not required for client consumption. b) When you need to include the attribute in your calculation view to define a join. c) When you want to hide the attribute in your cube calculation view. d) When you want to include an attribute that is not required for cube consumption.
a. when you want to hide an attribute that is not required for client consumption
What must I create to develop a predictive model? a) Procedure b) Flowgraph c) Predictive Analysis Library d) Calculation View
b) Flowgraph
What is needed in an SAP Vora deployment? There are 2 answers to this question. a) SAP HANA data warehousing foundation b) Apache Spark c) SAP Data Services d) Apache Hadoop
b. Apache Spark d. Apache Hadoop
Why did SAP decide to use CDS for S/4HANA Analytics and not SAP HANA Live? There are 2 answers to this question. a) Calculation views cannot be used with S/4HANA tables. b) CDS is tied to the application layer for better control of complete source code transportation. c) More use cases are available with CDS than with SAP HANA Live. d) Deeper BI functionality is available with CDS compared to SAP HANA Live.
b. CDS is tied to the application layer for better control of complete source code transportation c. more use cases are available with CDS than with SAP HANA live
To what subset of SQL does the SELECT statement belong? Please choose the answer. a) DCL b) DQL c) DML d) DDL
b. DQL
What are the advantages of columnar storage? There are 2 answers to this question. a) Improved performance when all fields are selected b) Improved data reading performance c) Improved compression d) Improved data writing performance
b. Improved data reading performance c. Improved compression
What statement is allowed in a user-defined function? Please choose the answer. a) INSERT b) JOIN c) EXEC d) COMMIT
b. Join
You imported the following objects. Which of them always require an activity from you before they can be built? There are 2 answers to this question. a) Synonyms definition b) Multi-target application c) SAP HANA database module d) Logical schema definition
b. Multi- Target Application c. SAP HANA database module
Which deployment scenarios feature security staying in the application server and end users not logging in to the SAP HANA system? There are 2 answers to this question. a) SAP HANA as a platform with an SAP HANA XS application b) SAP HANA as a reporting server c) SAP HANA as a database d) SAP HANA as a side-by-side accelerator
b. SAP HANA as a reporting server c. SAP HANA as a database
You have a discussion with board members of a company. They want your recommendation on a business intelligence tool that they can use on their Apple iPad to display KPI dashboards. They also want a WYSIWYG design environment that allows scripting, should it be required. Which tool do you recommend? Please choose the answer. a) SAP Crystal Reports for Enterprise b) SAP Lumira, designer edition c) SAP Lumira, discovery edition d) SAP BusinessObjects Web Intelligence
b. SAP Lumira, designer edition
What development tool is available for creating SAP HANA XSA and HDI information models? Please choose the answer. a) SAP HANA Web-Based Development Workbench b) SAP Web IDE for SAP HANA c) SAP HANA Studio d) Database Explorer
b. SAP Web IDE for SAP HANA
Which hierarchies can you enable for SQL access? Please choose the answer. a) Time-dependent hierarchies in a dimension view b) Shared hierarchies in a star join view c) Level hierarchies in a calculation view of type cube d) Local hierarchies in a star join view
b. Shared hierarchies in a star join view
50. What are properties of domain fix values? There are 2 answers to this question. a) They are based on SQLScript functions. b) They are static values. c) They ask end users for input at runtime. d) They are based on the ABAP Data Dictionary.
b. They are static values d. They are based on the ABAP Data Dictionary
Which of the following features of an XS Advanced application are provided by an HDB module? There are 2 answers to this question. a) User interface b) Virtual data modeling c) Business logic d) Persistence layer
b. Virtual data modeling d. Persistence layer
43. In SAP HANA Studio, what would you find in a Package? There are 3 answers to this question. a) Tables b) Calculation Views c) Procedures d) Analytic Privileges
b. calculation views c. procedures d. analytic privileges
What is the preferred way to create a procedure? Please choose the answer. a) Use the Import menu in the SAP Web IDE for SAP HANA. b) Create a .hdbprocedure file. c) Create a .procedure file. d) Use the CREATE PROCEDURE statement in the SQL console.
b. create a .hdbprocedure file
46. To maintain good read performance in a constantly changing database, which two components are used? There are 2 answers to this question. a) Memory store b) Delta storage c) Column store d) Main storage
b. delta storage d. main storge
Where can you create a filter expression? Please choose the answer. a) In a Data Foundation node b) In a Projection node c) In an Aggregation node d) In the Semantics node
b. in a projection node
Where is SAP HANA Live installed? Please choose the answer. a) On the SAP ERP application server b) In the SAP HANA database c) On SAP Landscape Transformation Replication Server d) In the reporting tool
b. in the SAP HANA database
52. Where do you create a variable? Please choose the answer. a) In the work area of an Aggregate node b) In the Semantics node c) In the context menu of a workspace d) In the output area of a Join node
b. in the semantics node
Which of the following views can you extend with the SAP HANA Live Extension Assistant? Please choose the answer. a) Your own custom views b) Reuse views c) All SAP-delivered views d) Query views with a union
b. reuse views
In a calculation view, what should you consider when you create an input parameter that derives its value from a user-defined function? There are 2 answers to this question. a) The input parameter must be set to mandatory. b) The function must be of the type scalar. c) The function can return multiple values. d) The generated value can be overwritten at runtime.
b. the function must be of the type scalar d. the generated value can be overwritten at run time
While converting currencies, which parameter is as important as source and target currencies? Please choose the answer. a) Money b) Time c) Season d) Location
b. time
Why do you assign semantic types to measures or attributes in calculation views? Please choose the answer. a) To provide meaningful value help when using variables b) To allow client applications to present data in appropriate formats c) To enable the activation of the calculation view d) To ensure consistency across calculation views
b. to allow client applications to present data in appropriate formats
In SAP HANA Text Analysis, why would you use the 'Voice of Customer' dictionary? Please choose the answer. a) To identify close matches in words and expressions, to catch misspellings b) To extract the sentiment from customer feedback on social media c) To identify the problem which customers are facing d) To extract common entities such as company, country, currencies, and so on, found in documents
b. to extract the sentiment from customer feedback on social media
In which type of node can you create calculated columns? There are 2 answers to this question. a) Rank node b) Union node c) Graph node d) Projection node
b. union node d. projection node
When would you use a function? Please choose the answer. a) To break SQL into smaller statements. b) When you need to define complex data sources for my calculation view that require conditional logic. c) When you need to write results back to a table. d) To develop a calculation view with the best possible performance.
b. when you need to define complex data sources for my calculation view that require conditional logic
What is SQLScript? Please choose the answer. a) A simplified query language aimed at business users that generates SQL. b) A subset of standard SQL that is exposed to HANA database procedures. c) An extension to standard SQL that provides additional expressions, functions and datatypes. d) A subset of standard SQL that is exposed to HANA modelers.
c. An extension to standard SQL that provides additional expressions, functions and datatypes
You have logs from a website. How do you show the total number of website visitors that used a mobile phone? There are 2 answers to this question. a) Create a rank column. b) Create a hierarchy expression parameter. c) Create a filter expression. d) Create a restricted column.
c. Create a filter expression d. Create a restricted column
Which component of the SAP SQL Data Warehousing do you use to move tables with data that are used together often to the same node to enhance query performance? Please choose the answer. a) Data Warehouse Scheduler (DWS) b) Data Warehouse Monitor (DWM) c) Data Distribution Optimizer (DDO) d) Data Lifecycle Manager (DLM)
c. Data Distribution Optimizer (DDO)
Which of the following can a level hierarchy do? Please choose the answer. a) Have time-dependency b) Be used for a bill of materials (BOM) structure c) Enable drilldown in a value help list d) Show variable deepness in the data
c. Enable drill down in a value help list
What type of load does SAP HANA perform when starting up? Please choose the answer. a) Log load b) Complete load c) Lazy load d) Fast load
c. Lazy Load
Which SAP solution does SAP HANA Live support? Please choose the answer. a) SAP BW/4HANA b) SAP Ariba c) SAP Business Suite d) SAP S/4HANA
c. SAP Business Suite
What tool generates files to help configure SAP Landscape Transformation Replication Server table replication? Please choose the answer. a) SAP HANA Studio b) Authorization Assistant c) SAP HANA Live Browser d) SAP HANA Live Extension Assistant
c. SAP HANA Live Browser
Which deployment scenario can you use to accelerate reporting from an old SAP R/3 system? Please choose the answer. a) SAP HANA as a platform b) SAP HANA Multitenant Database Containers (MDC) c) SAP HANA as a side-by-side accelerator d) SAP HANA as a database
c. SAP HANA as a side-by-side accelerator
What do you use in a SQL query to sort fuzzy text search results by relevance? Please choose the answer. a) RANK() b) SORT BY c) SCORE() d) TOP
c. SCORE()
You have to build a parent-child hierarchy. What type of join do you expect to use? Please choose the answer. a) Temporal join b) Relational join c) Self-join d) Dynamic join
c. Self- Join
Why might you want to reference a user-provided service in a project? Please choose the answer. a) To access data from your project container b) To access data from another container c) To access data from a classic database schema
c. To access data from a classic database schema
42. When can you use the referential join? Please choose the answer. a) When you have to report on all posted facts b) When you have to report on facts with matching dimensions c) When referential integrity is assured d) When you have to report on all dimensions to confirm if there are matching facts or not.
c. When referential integrity is assured
47. Which of the following would you create to build a predictive model? Please choose the answer. a) A function b) A decision tree c) A flowgraph d) A procedure
c. a flowgraph
You have two calculation views for viewing manufactured products. The WORLD calculation view shows worldwide information. The INDIA calculation view is built on top of the WORLD calculation view and shows information for Indian products. What privilege must you assign to see your department's specific data in a report built on the INDIA calculation view? Please choose the answer. a) An analytic privilege on the WORLD calculation view b) An object privilege on the WORLD calculation view c) An analytic privilege on both calculation views d) An analytic privilege on the INDIA calculation view
c. an analytic privilege on both calculation views
What do you use to build a financial report for the company's board members that allows them to choose if they want the report to be in euros or dollars? Please choose the answer. a) A variable from the Semantics node b) A variable from a Projection node c) An input parameter from the Semantics node d) An input parameter from an Aggregation node
c. an input parameter from the semantics node
A referential join gives the same results as which other join type? Please choose the answer. a) Spatial join b) Star join c) Inner join d) Left outer join
c. inner join
41. Which type of cloud solution is SAP HANA Enterprise Cloud an example of? Please choose the answer. a) Infrastructure as a service (IaaS) b) Software as a service (SaaS) c) Managed cloud as a service (MCaaS) d) Platform as a service (PaaS)
c. managed cloud as a service (MCaaS)
What do you call the data displayed in the data foundation of an SAP HANA information view? Please choose the answer. a) Characteristics b) Facets c) Measures d) Key figures
c. measures
What paradigm describes the SQL language? Please choose the answer. a) Application-focused b) Object-oriented c) Set-oriented d) Procedural
c. set- oriented
Why do we still need a persistent layer? There are 2 answers to this question. a) To hold the delta store for newly arrived records b) To store data that is frequently used c) To enable full database recovery if we have a power failure d) To store data that has been unloaded from memory
c. to enable full database recover if we have a power failure d. to store data that has been unloaded from memory
When do you use the SQL Analyzer? Please choose the answer. a) To investigate the generated SQL for each node in my calculation view. b) To highlight syntax errors in my SQL code. c) To identify the longest running SQL statements. d) To hide the syntax errors in my SQL code.
c. to identify the longest running SQL statements
Identify the principles that you need to follow during modeling. There are 2 answers to this question. a) You should push data processing to the client as much as possible. b) You should perform calculations before aggregation. c) You should reduce data transfer between the views by applying filters as low down as possible. d) You should create joins on key columns.
c. you should reduce data transfer between the views by applying filters as low down as possible d. you should create joins on key columns
What PAL algorithm would you use to analyze shopping baskets? Please choose the answer. a) Decision tree b) Link prediction c) K-means d) Apriori
d. Apriori
The relational model of SAP HANA Live is built using which type of views? Please choose the answer. a) Analytic views and attribute views b) Calculation views of data category cube with star join c) Scripted calculation views d) Calculation views of data category cube without star join
d. Calculation views of data category cube without star join
Which storage is required if you implement multistore tables for SAP HANA? Please choose the answer. a) Nearline storage b) Delta storage c) Remote storage d) Extended storage
d. Extended Storage
What combination enabled real-time computing? Please choose the answer. a) Multicore CPUs with large level 1 caches b) In-memory technology with solid-state disks c) Multicore CPUs and solid-state disks d) In-memory technology and multicore CPUs
d. In- memory technology and multicore CPUs
What must be installed for PAL to work? Please choose the answer. a) SAP HANA AFM b) SAP HANA SINA c) SAP HANA BFL d) SAP HANA AFL
d. SAP HANA AFL
Which interface client is used for XSA application development? Please choose the answer. a) SAP HANA Studio b) SAP Web IDE c) SAP HANA Web-based Workbench d) SAP Web IDE for SAP HANA
d. SAP Web IDE for SAP HANA
What spatial data type would you use to store multiple shop locations? Please choose the answer. a) ST_Polygon b) ST_MultiLineString c) ST_Point d) ST_MultiPoint
d. ST_MultiPoint
Which database artifact do you use to access external data from an XS Advanced project? Please choose the answer. a) User-provided service b) Logical schema c) Calculation view d) Synonym
d. Synonym
You have a view with two tables joined by a left outer join. If you redesign the view and accidently swap the two tables around, what should you do to the join? Please choose the answer. a) Change the join to a referential join. b) Keep the left outer join. c) Change the join to a text join. d) Change the join to a right outer join.
d. change the join to a right outer join
Which views in SAP S/4HANA embedded analytics may you extend? Please choose the answer. a) Query views b) Composite views c) Interface views d) Consumption views
d. consumption views
Where can you set the default value for the SAP client for the entire calculation view? Please choose the answer. a) In the default node of the calculation view b) In the Preferences option of the Tools menu c) In the Join node of the calculation view d) In the semantic layer of the calculation view
d. in the semantic layer of the calculation view
What technique is used to convert record updates into insert statements in the delta buffer? Please choose the answer. a) Sorted inserts b) Parallelism c) Unsorted inserts d) Insert-only
d. insert- only
Identify the join that checks the From and To column on the left table.**** i think there is supposed to be a picture with this one but there wasnt a screenshot in the word document*** Please choose the answer. a) Right Outer Join b) Full Outer Join c) Text Join d) Temporal Join e) Left Outer Join
d. temporal join
6. What should you keep in mind when using imperative logic in SQLScript? Please choose the answer. a) It matches SQL's set-oriented paradigm. b) You can only use if-then logic. c) It delivers the best possible performance. d) You can loop through records.
d. you can loop through records
