HA300- LEARNING Flashcards
Valid partition types
HASH , RANGE, ROUND ROBIN
Table Type
- Row
- Col
- History
- Global temp
- Local temp
- Virtual
Multi Join
- > 2.0
- Inside Out
- Outside In.
- Central Table
Partition
- Hash
- Round Robin
- Range
- > No Need not to drop a table
- > Can not Partition on Row Store.
Full Outer Join
- Supported by Calculation view only
2. Star Join can have only 1 Dim cal view.
Union Node Pruning
Union Node Pruning
SDA (Smart Data Access) can be used for?
Pushing down queries to remote DB, expose data to VT (Virtual Tables) in HANA, and Transform data in remote sources.
What technology uses log based real time replication?
SRS
Which Data Provisioning technologies use batch replication?
) SDI
2) SDQ
3) DS
4) DXC
What is loaded into memory when tables are accessed?
Only columns and partitions required by the application.
What is the role of the customer in SAP HEC (HANA Enterprise Cloud)?
1) Customer brings the licensed Software
2) SAP Manages the Infrastructure
Modeling Best Practice. Pt. 1
1) Avoid transfer of large amounts of data result sets between the SAP HANA DB and the Client Application.
2) Do calculations after Aggregation.
3) Avoid Complex expressions and instead push down into the model.
4) Aggregate data records (group by)
Modeling Best Practice. Pt. 2
1) Join on Key Columns because they become indexed.
2) Avoid Calculations before aggregations on line item levels.
3) Replace sequential cursor looping with set processing
4) Filter data amount as early as possible in the lower layers.
What are the different SAP HANA Cloud Managed Services?
1) IaaS (Infrastructure as a Service)
2) MCaaS (Managed Cloud as a Service)
3) PaaS (Platform as a Service)
4) DBaaS (Database as a Service)
5) SaaS (Software as a Service)
What is transparent Filter used for?
It allows you to add distinct measures from LOWER level Calculation Views to UPPER Calculation views
What must I create to develop a predictive model?
a) Procedure
b) Flowgraph
c) Predictive Analysis Library
d) Calculation View
Answer is b) Flowgraph
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
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
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
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
- 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
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
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 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
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 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 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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)
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
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
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
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
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
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
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
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)
- 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
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
- 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 built has failed.
- 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
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 storage
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
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
- 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 Sync (RDSync)
c) SAP HANA streaming analytics
d) SAP SQL Anywhere
- 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
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
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
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
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 Services (CDS)
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
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 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()
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
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
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.
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
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 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
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 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
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.
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 paradigm describes the SQL language? Please choose the answer. a) Application-focused b) Object-oriented c) Set-oriented d) Procedural
c) Set-oriented
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
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.
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
What statement is allowed in a user-defined function? Please choose the answer. a) INSERT b) JOIN c) EXEC d) COMMIT
b) JOIN
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
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
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
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 servers in the event of hardware failure.
b) Use of multiple servers to spread processing and improve performance.
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
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.
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 drilldown in a value help list
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
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
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
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
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
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
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
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) It’s a column in the result set.
c) It’s created in the output area.
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
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
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 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 databas
c) SAP HANA as a side-by-side accelerator
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
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 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
You have Model B that is based on Model A. You have successfully built both models. You delete Model B. What happens during the build?
There are 2 answers to this question.
a) You get an error when you build the entire HDB module
b) The build of the entire HDB module is successful
c) The build of Model A is successful
d) Model B gets deleted from the HDI container
e) You get a build error when you build Model A
b) The build of the entire HDB module is successful
c) The build of Model A is successful
What do you create to find the number of unique items sold per shop?
Please choose the answer.
a) An analytic view with a calculated column in a Star Join node
b) A calculation view with a counter in a Projection node
c) A calculation view with a counter in an Aggregation node
d) A calculation view with a restricted column in an Aggregation node
c. a calculation view with a counter in a Projection node
n which SAP HANA deployment scenarios will end users be created as users in the SAP HANA system? There are 2 answers to this question. a) SAP HANA Live b) SAP S/4HANA c) SAP HANA as a platform d) SAP BW powered by SAP HANA
a. SAP HANA Live
c. SAP HANA as a platform
What are advantages of column store tables?
There are 3 answers to this question.
a) Only the columns required are actually loaded to memory
b) Data footprint is automatically reduced through compression
c) They are optimized for high-volume read / write transactional processing
d) Columns can be partitioned
a. only the columns required are actually loaded to memory
b. data footprint is automatically reduced through compression
d. columns can be partitioned
When we refer to mixed modeling, what do we mean?
Please choose the answer.
a) Models from BW on any DB combined with models from BW on HANA
b) Classic BW models combined with SAP HANA optimized BW models
c) NetWeaver models combined with native SAP HANA models
d) BW models combined with native SAP HANA models
d. BW models combined with native SAP HANA models
You want to publish your business intelligence content directly to SAP Analytics Cloud. Which tool do you use? Please choose the answer. a) SAP Lumira, discovery edition b) SAP Analysis for Microsoft Office c) SAP Crystal Reports for Enterprise
a) SAP Lumira, discovery edition
What are key features of SAP HANA? There are 3 answers to this question. a) In-memory database b) Removes the need for cache c) Combined OLTP and OLAP processing on one platform d) Automatic compression of data
a) In-memory database
c) Combined OLTP and OLAP processing on one platform
d) Automatic compression of data
What are the two views in the Web IDE for SAP HANA? There are 2 answers to this question. a) Catalog b) Development c) Database Functions d) Database Explorer
b. development
d. database explorer
What can you use to limit users to see only 2018 data? There are 2 answers to this question. a) A view with a restricted column b) An object privilege c) A view with a filter d) A SQL analytic privilege
a) A view with a restricted column
d) A SQL analytic privilege
You have successfully built an SAP HANA database (HDB) module. It contains a dimension calculation view that is only consumed by one cube calculation view.- In the dimension calculation view, you change the name of a column that is referenced by the cube calculation view.
You then accidentally delete the design-time object of the cube calculation view.
During the build, which of the following scenarios are possible?
There are 2 answers to this question.
a) When you build only the dimension calculation view, the build is successful.
b) When you build the HDB module, the build fails.
c) When you build only the dimension calculation view, the build fails.
d) When you build the HDB module, the build is successful.
c. when you build only the dimension calculation view, the build fails
d. when you build the HDB module, the build is successful
What do you need to do after creating a new project with an HDB module?
Please choose the answer.
a) Convert the new module to an HDB module
b) Select a space for running the project
c) Create an .hdinamespace file
b) Select a space for running the project
What are the two storage components used to restore the database in case of power failure? There are 2 answers to this question. a) Data volume b) Memory c) Log area d) Delta store
a) Data volume
c) Log area
Which recent technology advances have made SAP HANA possible? There are 2 answers to this question. a) Faster internet speeds b) Faster disk speeds c) Multicore processors d) Larger and cheaper memory
c) Multicore processors
d) Larger and cheaper memory
You create a full-text index. For what text feature clause do you need to specify a configuration?
a) TEXT MINING
b) TEXT ANALYSIS
c) FUZZY SEARCH INDEX
d) SEARCH ONLY
b) TEXT ANALYSIS
You have a list of map locations for clinics. The government wants to build a new clinic where there is the greatest need. You need to find the largest distance between any two clinics.With your current knowledge, how do you do this?
Please choose the answer.
a) Use a temporal join to find the distance between clinics.
Use a union with constant values to “pivot” the values.
b) Use a spatial join to find the distance between clinics.
Use an aggregation with the maximum option.
c) Use a spatial join to find the distance between clinics.
Use a level hierarchy for drilldown.
d) Use a dynamic join to find the longest distance between clinics.
Use a ranking to find the top 10 values.
b) Use a spatial join to find the distance between clinics.
Use an aggregation with the maximum option.
In which SAP HANA views will you find measures?
There are 2 answers to this question.
a) Calculation view of type dimension
b) Calculation view of type cube
c) Calculation view of type cube with star join
d) Database views
b) Calculation view of type cube
c) Calculation view of type cube with star join
You want to build a hierarchy on a time-based data structure, such as year, month, and day. What type of hierarchy do you use? Please choose the answer. a) Level hierarchy b) Parent-child hierarchy c) Unbalanced hierarchy d) Ragged hierarchy
a) Level hierarchy