NO.1 Which are views of the SAP supplied virtual data model of Embedded Analytics? There are 2 correct answers to this question. Response:
Composite Calculation Basic Attribute .
NO.2 For what tasks would you use the Where-Used feature in SAP HANA? Please choose the correct answer.
Response:
To find all places where a developer updated information models To find all places where an information model has been deployed To find all places where an information model is used To find all places where translations exist.
NO.3 From where does the Extract Semantics feature get the definition of hierar- chies? Please choose the correct answer. From the current calculation view From the table data sources From the SQL view data sources From the underlying dimension views.
NO.4 Referring to the diagram which privileges would a user require to view United States data when querying the CUBE Calculation view?
Please choose the correct answer. A SELECT privilege on the CUBE and an analytic privilege (Country = United States) on the DIMENSION calculation view ASELECT privilege and an analytic privilege (Country = United States) on the DIMENSION calculation view Analytic Privilege and SELECT privilege on the CUBE calculation view SELECT privileges and Analytic Privileges on both views.
NO.5 Which interface client is used for XSA application development? Please choose the correct answer.
Response: SAP HANA Web-based Workbench SAP Web IDE for SAP HANA SAP HANA Studio SAP Web IDE.
NO.6 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 correct answers to this question. Response:
When you build the HDB module, the build fails. When you build only the dimension calculation view, the build fails. When you build only the dimension calculation view, the build is successful. When you build the HDB module, the build is successful.
NO.7 Identify the principles that you need to follow during modeling. There are 2 correct answers to this question.
Response: You should reduce data transfer between the views by applying filters as low down as possible. You should push data processing to the client as much as possible. You should perform calculations before aggregation.
You should create joins on key columns.
NO.8 What technique is used to convert record updates into insert statements in the delta buffer? Please choose the correct answer.
Response:
Sorted inserts Parallelism Insert-only Unsorted inserts.
NO.9 Where in a calculation view can you add a Graph node? Please choose the correct answer.
Response:
Anywhere from the bottom (leaf) node to the default node Only as the top node Always as the bottom (leaf) node.
NO.10 Which types of calculation views can you create? There are 2 correct answers to this question.
Response: Time-based Derived Materialized Standard.
NO.11 Which business intelligence tool does NOT use BICS connectivity to SAP HANA? There are 2 correct answers to this question.
Response: Microsoft Excel SAP Analysis for Microsoft Office SAP Lumira, designer edition SAP Lumira, discovery edition.
NO.12 Why did SAP move from XS to XSA? There are 2 correct answers to this question. Response: To move to Cloud Foundry architecture to allow flexible application deployment options To provide better source code management tools inside SAP HANA To implement micro-services architecture To include ABAP as a key development language for native SAP HANA applications.
NO.13 Which table partitioning types does SAP HANA support? There are 3 correct answers to this question.
Response: Hash Composite Cluster Range Round-robin.
NO.14 Which views in SAP S/4HANA embedded analytics may you extend? Please choose the correct answer.
Response: Consumption views Interface views Composite views Query views.
NO.15 Which of the following are characteristics of SAP HANA Smart Data Streaming? Please choose the correct answer.
Response: It uses databases queries It is a standalone product for use with any target system. It provides reports and analysis on the received data. It acts based on combinations of events.
NO.16 Your calculation view includes the following SALES_ORDER_ID and ITEM as attributes, and QUANTITY and PRICE as measures. You create a calculated column, ITEM_TOTAL, with the formula QUANTITY*PRICE.
In which node do you define the calculation to display the correct aggregated result? Please choose the correct answer.
Response: Join Projection Union Aggregation.
NO.17 You are building a new calculation view, A, Which includes a projection node that refers to another calculation view, B.
WHY would you use the extract semantics feature? Please choose the correct answer.
Response: To improve the performance of calculation view A by only referencing the semantics calculation view B and not duplicating it. To automatically map the input parameters from calculation view B to an input parameter of calculation A TO apply the semantics of calculation view B TO the semantics of calculation view A TO SET the semantics of calculation view A TO THE DEFAULT VALUES.
NO.18 What should you keep in mind when using dynamic SQL? There are 2 correct answers to this question.
Response: It delivers the best possible performance. It could be used for SQL injection. It's always bad for security. You can dynamically change your data sources.
NO.19 Identify the features and benefits of a calculation view. There are 3 correct answers to this question.
Response: It can be defined as a graphical view or a scripted view. It is not possible to join several fact tables in a calculation view. It can contain calculated attributes. It supports you to include more advanced calculations.
NO.20 How should you create a procedure? Please choose the correct answer.
Response: Create a design-time object in a HANA project. Create a runtime object in a HANA project Create a design-time object in a SQL console Create a runtime object in the SQL console.
NO.21 Where do you create a variable? Please choose the correct answer.
Response: In the work area of an Aggregate node In the output area of a Join node In the context menu of a workspace In the Semantics node.
NO.22 What are features of Business Suite on SAP HANA? There are 2 correct answers to this question.
Response: ABAP is replaced with JAVA Embedded Analytics Combine operational analytics and transaction processing Massive performance improvement.
NO.23 What spatial data type would you use to store multiple shop locations? Please choose the correct answer.
Response: ST_Polygon ST_MultiLineString ST_MultiPoint ST_Point.
NO.24 If I need to create multiple, tabular output structures from an SQLscript, which HANA modeling object do I use?
Please choose the correct answer. Response: Both Procedure and Function Function None of these Procedure.
NO.25 What are the rules for defining a stepparent in a hierarchy? There are 2 correct answers to this question.
Response: A stepparent only applies to parent-child hierarchies. The stepparent node must already exist in the hierarchy at the root level. The stepparent node ID must be entered according to the node style you selected for the hierarchy. The stepparent node must already exist in the hierarchy at any level.
NO.26 Which SAP solution does SAP HANA Live support? Please choose the correct answer.
Response: SAP S/4HANA SAP Business Suite SAP BW/4HANA SAP Ariba.
NO.27 One SQL analytic privilege authorizes you to view data for Europe and the USA in the sales calculation view, and another one authorizes you to view data for Asia and the USA in the income calculation view.
The income view uses the sales view as a data source. Both calculation views check SQL analytic privileges.
What data can you visualize when consuming the income calculation view? Please choose the correct answer.
Response: Data from Europe, Asia, and the USA Data from the USA Data from Europe and the USA Data from Asia and the USA.
NO.28 On a weekly basis, you need to extract and transform data from multiple sources such as SAP ERP Microsoft Excel and Apache Hadoop and load the data into SAP HANA.
Which tools can you use?
There are 2 correct answers to this question.
Response: SAP Landscape Transformation Replication Server SAP HANA smart data integration SAP Data Services SAP HANA smart data access.
NO.29 Which of the following must you consider when you define namespaces in an SAP HANA database (HDB) module?
There are 3 correct answers to this question. Response: A namespace is a mandatory component of the object identifier The namespace defined in a design-time object must match the namespace properties of the folder in which it is located Modeling content should be created before the namespace rules have been defined synonyms can have different namespaces Two different objects can have the same name if they are assigned to different namespaces.
NO.30 For which deployment scenario does SAP deliver prebuilt data models? Please choose the correct answer.
Response: SAP HANA as an SQL Data Warehouse SAP HANA on the cloud SAP HANA as a side-by-side accelerator SAP HANA as a platform.
NO.31 What can you extract using the standard text analysis configuration: Voice of the Customer? There are 2 correct answers to this question.
Response: Suggestions Requests Sentiments Recommendations.
NO.32 You're working with a currency measure. What is decimal shift used for? Please choose the correct answer.
Response: For currencies with more than two decimal places To avoid rounding errors during the conversion To increase the accuracy of the currency conversion To undo the decimal adjustment for ABAP.
NO.33 What is the default node for a calculation view of type cube? Please choose the correct answer.
Response: Join node Star join node Projection node Aggregation node.
NO.34 You rename a field in the Semantics node to add clarity for end users. What does SAP HANA use to keep track of what the original field name is?
Please choose the correct answer. Response: The label column property The name property The label property The mapping property.
NO.35 A company sends out a lot of quotes. Some customers accept the quotes, and they're invoiced. The company asks you to find a list of the customers that did NOT accept the quotes. How do you find the customers that received quotes but did NOT receive invoices?
Please choose the correct answer.
Response: Use a right outer join.
Filter to show only the NULL values on the right table. Use a left outer join.
Filter to show only the NULL values on the right table. Use a right outer join.
Filter to show only customers on the left table. Use a left outer join.
Filter to show only customers on the right table.
NO.36 What performance technique should you implement to improve join performance? Please choose the correct answer.
Response: Always use referential joins in star join views. Use joins instead of unions for combining large datasets. Do NOT use dynamic joins if you require optimal performance. Join on key fields between tables in a dimension view.
NO.37 Which of the following are no longer required in the architecture of SAP S/4HANA? There are 2 correct answers to this question.
Response: Indexes Aggregates Synonyms Column tables.
NO.38 You're creating a currency conversion. What options do you have for the Target Currency field?
There are 3 correct answers to this question. Response: Select a table type. Select a column. Use the Derived from Table option. Use an input parameter. Select a fixed currency.
NO.39 In which key areas can we expect there to be improvements when running SAP BW on SAP HANA?
There are 2 correct answers to this question. Response: Tighter security Reporting performance Data loading performance Superior data quality.
NO.40 What is a role of the SAP HANA Cockpit? Please choose the correct answer.
Response: To provide key system performance information for one or more HANA instances To secure the SAP HANA Database To provide KPIs to help focus on business performance To provide an application developer collaboration hub.
NO.41 Which modeling features can you use in flowgraphs? There are 2 correct answers to this question.
Response: Graph Spatial Text Predictive.
NO.42 Which of the following tasks are required to get the database objects created in the HDI container?
There are 2 correct answers to this question. Response: Assign the project to a space to which you have developer authorizations. Create at least one namespace in the HDB module. Build the MTA project. Explicitly build the HDB module instead of the MTA project.
NO.43 Why do you create a time dimension calculation view? Please choose the correct answer.
Response: To support temporal joins in a cube calculation view with star schema To enable time dependency on parent-child hierarchies To provide date-based help values for a DIRECT type input parameter To enhance a calculation view with a drilldown on a time hierarchy.
NO.44 While converting currencies, which parameter is as important as source and target currencies?
Please choose the correct answer. Response: Money Season Location Time.
NO.45 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 correct answer. Response: Change the join to a referential join. Change the join to a text join Keep the left outer join. Change the join to a right outer join.
NO.46 You are a data analyst working with medical records that contain confidential patient information. Why do you use the anonymization node in a calculation view?
There are 2 correct answers to this question. To add noise to the data to hide the actual values To restrict data access for specific users or roles To hide individual patients in groups of similar records To provide partial values such as #3434 3#34##.
NO.47 You're writing a mobile application for the World Series. You have details about all the baseball players and the baseball scores for all the previous games.
How do you use the data of the player information and the scores? Please choose the correct answer.
Response: The player information is used as master data, and the scores are used as transactional data. Both the player information and the scores are used as master data. Both the player information and the scores are used as transactional data. The player information is used as transactional data, and the scores are used as master data.
NO.48 What do you use in a SQL query to sort fuzzy text search results by relevance? Please choose the correct answer.
Response: TOP SORT BY RANK() SCORE().
NO.49 Why do you build a calculation view of type DEFAULT? Please choose the correct answer
Response: To support optimized multidimensional reporting To provide a data source that is only consumed by other calculation views. To ensure all reporting tools can consume the calculation view To provide a leaner model when only attributes are required.
NO.50 Which are the recommended assignments in SAP HANA? There are 2 correct answers to this question.
Response: Roles to roles Roles to users Privileges to users Roles to privileges.
NO.51 What do we implement to restrict access to specific data rows of a calculation view? Please choose the correct answer.
Response: HANA Database Procedure SQL permission Authorisation object Analytic privilege.
NO.52 What performance technique should you implement to improve the performance of SAP HANA information views?
Please choose the correct answer. Response:
Output as many fields as possible. Build single large views. Implement union pruning conditions. Supply reporting tools with all the data in one transfer.
NO.53 Where is SAP HANA Live installed? Please choose the correct answer.
Response: On the SAP ERP application server In the SAP HANA database On SAP Landscape Transformation Replication Server In the reporting tool.
NO.54 Why would you use the XS Advanced migration Assistant? There are 2 correct answers to this question.
Response: To move HDI-developed calculation views to repository packages To convert studio-developed objects for use with Web IDE FOR SAP HANA To convert attribute views to CDS VIEWS TO convert analytic views to calculation views.
NO.55 Which storage is required if you implement multistore tables for SAP HANA? Please choose the correct answer.
Response:
Remote storage Delta storage Nearline storage Extended storage.
NO.56 Which type of tables required extended storage? Please choose the correct answer.
Response: Row tables Column tables Multistore tables In-memory tables.
NO.57 Which join type makes use of date ranges? Please choose the correct answer.
Response: Temporal join Spatial join Text join Inner join.
NO.58 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 correct answer. Response: SAP Lumira, designer edition SAP Crystal Reports for Enterprise SAP Lumira, discovery edition SAP BusinessObjects Web Intelligence.
NO.59 You created a user-defined function with the INVOKER security option. Which user's authorizations are checked when the function is executed?
Please choose the correct answer. Response: The container's technical user The SYSTEM user The user calling the function The owner of the function.
NO.60 What character is prepended to a SQLScript variable when it's used as an input variable? Please choose the correct answer.
Response: & (ampersand) ! (exclamation mark) : (colon) _ (underscore).
NO.61 Why does SAP issue warnings about the use of imperative or procedural SQL Script statements?
Please choose the correct answer. Response: They are deprecated They introduce security risks due to SQL injection They can harm SQL optimization NOT all reporting tools can consume the results.
NO.62 To maintain good read performance in a constantly changing database, which two components are used?
There are 2 correct answers to this question. Response: Memory store Delta storage Main storage Column store.
NO.63 What information can you find in Performance Analysis Mode when you view the analysis for a Join node?
There are 2 correct answers to this question. Response: Time taken by the join Total number of records returned by the node Tables used by the join in the node Suggested filter for the tables in the Join node.
NO.64 When creating a system connection in SAP HANA Studio, which of these is essential information?
There are 3 correct answers to this question. Response: Host A valid user and password URL Instance.
NO.65 What can you discover using Data Lineage? Please choose the correct answer.
Response: Frequency of load Underlying calculation views and tables Data changes since last refresh Access statistics.
NO.66 You want to read a table from an SAP HANA classical schema. What do you need to do to get it working?
There are 3 correct answers to this question. Response: Create a synonym Make use of a user-provided service Make use of the built-in HDI service Use an explicit reference to the schema Assign the provided ::access role to your container's technical user.
NO.67 You join two tables using a referential join and set the cardinality to 1...n What type of join is executed at runtime if your query does not request columns from the right table?
Please choose the correct answer. Response: Full outer join Inner join left outer join Right outer join.
NO.68 Where will you find the Data Distribution Optimizer? Please choose the correct answer.
Response: SAP S4/HANA Dictionary SAP HANA Studio SAP BW/4HANA SAP HANA Data Warehousing foundation.
NO.69 What information can you find in the SAP HANA Cockpit? There are 2 correct answers to this question.
Response: SQL generated in each step List of operators Trace and log files SQL Plan Cache.
NO.70 In your calculation view, you need to define a custom data source using SQL Script. In which object do you write your SQL Script?
Please choose the correct answer. Response: Procedure Table function CDS View Scalar function.
NO.71 What PAL algorithm category can you use for supervised learning? Please choose the correct answer.
Response: Association Classification Social network analysis Clustering.
NO.72 In which SAP HANA solution do you eliminate stored data, such as year-todate figures? Please choose the correct answer.
Response: SAP S/4HANA SAP CRM on SAP HANA SAP BW on SAP HANA SAP HANA Enterprise Cloud.
NO.73 In SAP HANA Series Data, which of the following methods do you use to convert finer interval readings to a coarser interval?
Please choose the correct answer. Response: Horizontal disaggregation Horizontal aggregation Vertical disaggregation Vertical aggregation.
NO.74 What are valid types of calculation view? There are 3 correct answers to this question.
Response: Dimension with star schema Cube with star schema Dimension Cube.
NO.75 How does SAP S/4HANA embedded analytics differ from SAP HANA Live? There are 2 correct answers to this question.
Response: It uses ABAP CDS views. It uses ABAP CDS views. Authorizations are at the database level. It uses SAP HANA calculation views. Authorizations are at the application level.
NO.76 What does the C in ACID-compliant stand for? Please choose the correct answer.
Response: Constant Complexity Consistency Complete.
NO.77 When can you use the referential join? Please choose the correct answer.
Response: When referential integrity is assured When you have to report on facts with matching dimensions When you have to report on all dimensions to confirm if there are matching facts or not When you have to report on all posted facts.
NO.78 You have a cube calculation view that consumes a dimension view. You suspect some dimension columns have been renamed in the cube calculation view.
Which function of SAP Web IDE for SAP HANA do you use to check where the output columns originate from?
Please choose the correct answer.
Response:
Impact Analysis Impact Analysis Show lineage Database explorer Where used.
NO.79 Using the table in the diagram, you need to create a cube calculation view. What is the simplest approach to create the output form the screenshot?
Please choose the correct answer.
Response: Create a restricted column for each year Create a filter expression that uses an OR operator Implement a union node and map each year as a separate column.
NO.80 You want to see in a Union node which data sources return no results for a query. How do you achieve this?
Please choose the correct answer. Response: Create a standard union. Create a union pruning configuration table. Set the Empty Union Behavior property. Set the is Null property in the Manage Mapping dialog.
NO.81 What performance techniques should you implement to improve the performance of SAP HANA information views?
There are 3 correct answers to this question. Response: Minimize the transfer of data between the execution engines. Perform calculation before aggregation in your analytic views. Apply filters as late as possible. Investigate partitioning of large tables. Push down aggregations to SAP HANA.
NO.82 You imported the following objects. Which of them always require an activity from you before they can be built?
There are 2 correct answers to this question. Response: Multi-target application SAP HANA database module Synonyms definition Logical schema definition.
NO.83 You have successfully built a project you imported in the Web IDE workspace, but you cannot see the corresponding runtime database objects.
What could be the reason?
Please choose the correct answer. Response: The project is not assigned to a space You have the Developer role in the assigned space Building a project does not generate the database content of its HDB modules You do not have the Developer role in the assigned space.
NO.84 In which of the following scenarios would you benefit from enabling table portioning in SAP HANA?
Please choose the correct answer. Response: Your stacked model consists of multiple calculation views. Your column tables' delta store is frequently larger than its main store. you have a larger column store table that is consumed in a view with a variable on COUNTRY column. You have a large row store table that is consumed in view with a variable on COUNTRY column.
NO.85 Using a calculation view containing the projections shown in the graphic, how would you identify which companies sold products in January 2018 AND February 2018?
Please choose the correct answer. Projection Sales January 2018 Projection Sales February 2018
Company Product Quantity Company Product Quantity
Response: Use a union node Use a left outer join Use a full outer join User an intersect node.
NO.87 Where can you set the default value for the SAP client for the entire calculation view? Please choose the correct answer.
Response: In the default node of the calculation view In the semantic layer of the calculation view In the Join node of the calculation view In the Preferences option of the Tools menu.
NO.88 What should you keep in mind about procedures? There are 3 correct answers to this question.
Response: They must return values. They can call table functions. They may have input parameters. They can call views. They are NOT open to SQL injection.
NO.89 How many processing tiers do you usually find in a native SAP HANA application stack? Please choose the correct answer.
Response: 2 1 1 4 3.
NO.90 When you create a full text index, why do you specify FAST_PREPROCESS OFF? Please choose the correct answer.
Response: To avoid the generation of the term document matrix To enable a full linguistic search To generate text analysis results in multiple languages To prevent the creation of a fuzzy search index.
NO.91 A column in your table will be used for text search. Why do you define the column as a text type instead of a string type?
Please choose the correct answer. Response: To enable a linguistic analysis To enable lower memory consumption To allow processing of multiple languages To enable the full set of SQL operations.
NO.92 What can a variable be used for? Please choose the correct answer.
Response: Call a procedure in SQL Script Currency conversion Calculated column expression Filtering.
NO.93 What is the correct sequence for loading data with SAP Data Services? Please choose the correct answer.
Response: Extract - Load - Transform Load - Extract - Transform Extract - Transform - Load Load - Transform - Extract.
NO.94 What should you keep in mind about user-defined functions? Please choose the correct answer.
Response: They can use imperative logic. They can call procedures. They can use dynamic SQL. They can commit transactions.
NO.95 In an XSA/HDI environment, where do you find run-time objects? Please choose the correct answer.
Response: Repository package _SYS_BIC schema Container schema Database user schema.
NO.96 Which of the following benefits characterize the use of a design time filter? There are 3 correct answers to this question.
Response: The filter is applied on the result set of a query. It is applied before a table join is executed. The filter is applied on the table before the query is executed. It reduces the result set of data. It is defined on the runtime in the SQL query.
NO.97 When modeling in the Web ID for SAP HANA, which object do you build to provide access to tables in external schemas?
Please choose the correct answer. Response: Role Analytic privilege Container Synonym.
NO.98 A partitioned column table is present only in the persistent layer of an SAP HANA system Which columns and partitions are loaded into memory when the table is accessed by an application? Please choose the correct answer.
Response: ONLY the required columns and the required partitions ONLY the required partitions and all the columns All the partitions but ONLY the required columns.
NO.99 Where do you use SQLScript outside of the development environment discussed in this chapter?
There are 3 correct answers to this question. Response: Security Creating tables Reporting tools Text analytics Calculation views.
NO.100 In which package in SAP HANA will you find the SAP HANA Live views? Please choose the correct answer.
Response: /sap/hana/democontent /sap/hba /public /sap/bc.
NO.101 Which text feature do you use to find sentiment in textual data? Please choose the correct answer.
Response: Full-text index Text analysis Fuzzy text search Text mining.
NO.102 Which recent trends have triggered the need for a next generation data processing platform?
There are 3 correct answers to this question. Response: Increasing connectivity of people and devices Move transactional processing and analysis to separate servers for better scalability Massive growth in data volume Increase in use of mobile devices.
NO.103 In SAP HANA Series Data processing, what is the definition of a profile? Please choose the correct answer.
Response: The object you collect data against, such as house, building, or town The granularity of time intervals, such as day, hour, or minute The values that you are storing, such as temperature, energy consumption, or speed A variant of data set, such as actual, forecast, or long-term plan.
NO.104 Your newly created analytic privilege does NOT want to build. What must you do? Please choose the correct answer.
Response: Assign the ::access role to the HDI container user. Grant rights to the _SYS_REPO user. Change the Apply Privileges property of the view. Change the analytic privilege to use an SQL Expression.
NO.105 When do you use the hidden attribute in a dimension calculation view? Please choose the correct answer.
Response: When you want to include an attribute that is not required for cube consumption. When you want to hide the attribute in your cube calculation view. When you want to hide an attribute that is not required for client consumption. When you need to include the attribute in your calculation view to define a join.
NO.106 You have logs from a website. How do you show the total number of website visitors that used a mobile phone?
There are 2 correct answers to this question. Response:
⦁ Create a restricted column.
⦁ Create a hierarchy expression parameter.
⦁ Create a rank column.
⦁ Create a filter expression.
Answer: AD
Create a restricted column. Create a hierarchy expression parameter. Create a rank column. Create a filter expression.
NO.107 Which technologies does SAP HANA use to load more data into memory? There are 3 correct answers to this question.
Response: Store data in column tables Eliminate indices Use ZIP compression Use multicore CPU parallelism.
NO.108 What conditions must be met before you can implement time dependency on a hierarchy in a calculation view?
There are 2 correct answers to this question. Response: The hierarchy must be enabled for SQL access The hierarchy must be a level hierarchy. The key date parameter must be derived from an input parameter The hierarchy must be a parent-child hierarchy.
NO.109 What should you use to create tables in an HDI container? There are 2 correct answers to this question.
Response: SAP Enterprise Architecture Designer SQL Console Core Data Services (CDS) Database Explorer.
NO.110 In a calculation view, where can you use SQL? There are 3 correct answers to this question.
Response: Filter expression Calculated column expression Input parameter Union pruning conditions Aggregation node.
NO.111 Which of the following views can you extend with the SAP HANA Live Extension Assistant? Please choose the correct answer.
Response: Query views with a union All SAP-delivered views Your own custom views Reuse views.
NO.112 Which of the following would you create to build a predictive model? Please choose the correct answer.
Response: A flowgraph A decision tree A function A procedure.
NO.113 What are the four SAP HANA platform services? There are 4 correct answers to this question.
Response: Processing Services Database Services Integration Services Security Services Application Services.
NO.114 Which of the following techniques can you use to improve the performance of calculation views?
There are 2 correct answers to this question. Response: Implement union pruning Partition large tables Avoid aggregating data early in the data flow Minimize layering of calculation views.
NO.115 Which are of the following languages supported by SAP HANA Graph are optimized for graph processing?
There are 2 correct answers to this question. Response:SQL Script SQL Script SQL GraphScript Cypher Query Language.
NO.116 In SAP Web IDE for SAP HANA, what can a flow graph generate in a predictive analysis scenario?
There are 2 correct answers to this question Response:
⦁ Procedure
⦁ Container
⦁ Task
⦁ Function
Answer: AD
Procedure Container Task Function.
NO.117 Where do you build a flowgraph? There are 2 correct answers to this question. Response:
Web IDE for SAP HANA Web-based development workbench SAP HANA Studio development perspective SAP HANA Studio modeler perspective.
NO.118 What are typical characteristics of SAP HANA data replication? There are 2 correct answers to this question.
Response: Virtualization Real-time Duplicate data Streaming.
NO.119 What must be installed for PAL to work? Please choose the correct answer. SAP HANA AFM SAP HANA AFL SAP HANA BFL SAP HANA SINA.
NO.120 How does SQL Script extend SQL? There are 3 correct answers to this question. Response: It adds imperative expressions to control data flow. It provides the data definition language (DDL) to create column tables. It enables usage of variables to break up complex code. It improves push-down opportunities. It allows an alternative syntax to simplify expressions.
NO.121 What is the preferred way to create a procedure? Please choose the correct answer.
Response: Use the CREATE PROCEDURE statement in the SQL console. Use the Import menu in the SAP Web IDE for SAP HANA. Create a .procedure file. Create a .hdbprocedure file.
NO.122 Which of the following data provisioning tools can you use to read data directly from Twitter?
There are 3 correct answers to this question. Response: SAP Replication Server SAP Data Services SAP HANA XS engine SDA SDI.
NO.123 What conditions must be met to ensure the Dynamic join feature works properly? There are 2 correct answers to this question.
Response: The join must be defined on key columns At least one joined column must be specified in the query. Cardinality must be set Multiple columns must be defined in the join.
NO.124 What are features of SDA?
There are 2 correct answers to this question. Response: Automatic data type translation Evaluation and execution of push down possibilities to remote sources Data cleansing Merging data from multiple sources.
NO.125 You created a table using the SQL console inside the HANA deployment infrastructure (HD) container of project You export project and re-import it with a different project name to same database.
What do you observe the SAP HANA database module? Please choose the correct answer.
Response: The build fails and the table is NOT present The build is successful and the table and its data are present The build is successful but the is NOT present.
NO.126 What enables the delta buffer technique to speed up both reads and inserts in SAP HANA? Please choose the correct answer.
Response: Using row-based tables only Using both row-based and column-based tables Using column-based tables only Using only the insert-only technique.
NO.127 What do you call the data displayed in the data foundation of an SAP HANA information view?
Please choose the correct answer. Response:
Key figures Characteristics Measures Facets.
NO.128 What information can you find in the Plan Graph? There are 2 correct answers to this question.
Response: Number of records returned in each step Time taken for each step Execution engines used SQL Plan Cache.
NO.129 What performance technique should you implement to improve the performance of SAP HANA information views that include SQLScript?
Please choose the correct answer. Response:
Use SELECT *. Break large statements into smaller steps. Use imperative logic. Use dynamic SQL.
NO.130 What can be used to return multiple result sets? Please choose the correct answer.
Response: Scalar function Table function View Procedure.
NO.131 Which of the following features of an XS Advanced application are provided by an HDB module?
There are 2 correct answers to this question. Response: Business logic User interface Persistence layer Virtual data modeling.
NO.132 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 correct answer. Response: A variable from the Semantics node A variable from a Projection node An input parameter from the Semantics node An input parameter from an Aggregation node.
NO.133 Which type of cloud solution is SAP HANA Enterprise Cloud an example of? Please choose the correct answer.
Response: Managed cloud as a service (MCaaS) Software as a service (SaaS) Platform as a service (PaaS) Infrastructure as a service (IaaS).
NO.134 In which direction do you build calculation views when including the source tables in Join nodes?
Please choose the correct answer. Response: From the Join node down to the default node From the Semantics node down to the Join nodes From the Semantics node up to the default node From the Join nodes up to the semantics node.
NO.135 In a calculation view, what is the purpose of a variable? Please choose the correct answer.
Response: To capture the interim result of a calculation in an expression To break up complex SQL into smaller steps To provide a run-time attribute filter based on a user input To pass values between procedures and calculation views.
NO.136 Which of the following are correct statements relating to the flat file import function of SAP HANA Studio?
There are 3 correct answers to this question. Response:
The supported file types for upload are .csv, and .txt The new table always has a 1:1 mapping between the file and table columns Renaming of columns and changing data types is allowedwhen loading data to new HANA tables When loading new data in a table that already contains data, the new data is appended to the existing data.
NO.137 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 correct answers to this question. Response: The generated value can be overwritten at runtime. The function must be of the type scalar. The input parameter must be set to mandatory. The function can return multiple values.
NO.138 What do you need to do after creating a new project with an HDB module? Please choose the correct answer.
Response: Select a space for running the project Create an .hdinamespace file Convert the new module to an HDB module.
NO.139 Which business intelligence tool can publish storyboards? Please choose the correct answer.
Response: SAP Analysis for Microsoft Office SAP BusinessObjects Web Intelligence SAP BusinessObjects Analysis, edition for Microsoft Office SAP Lumira, designer edition.
NO.140 You are building a cube calculation view with an aggregation node that calculates total sales, based on the data shown in the graphic.
The price may vary based on SHIRT_ID and PROMO_LEVEL only. The calculation is Total Sales = PRICE
* QUANTITY.
How do you ensure accurate results, regardless of the columns in the query output? Please choose the correct answer.
Response: Set the Calculate before Aggregation property. Set the Keep Flag property for SHIRT_ID Set the Keep Flag property for SHIRT_ID and PROMO_LEVEL. Set the Dynamic Partition property for SHIRT_ID and PROMO_LEVEL.
NO.141 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 correct answers to this question. Response: You get a build error when you build Model A The build of Model A is successful Model B gets deleted from the HDI container You get an error when you build the entire HDB module The build of the entire HDB module is successful.
NO.142 Why do you use the query debug mode in a calculation view? Please choose the correct answer.
Response: To observe the generated SQL for each node To check which database engines will be invoked by each node? To check if SAP HANA can paralyze the entire query To measure the overall run-time of the query.
NO.143 Which deployment scenarios feature security staying in the application server and end users not logging in to the SAP HANA system?
There are 2 correct answers to this question. Response: SAP HANA as a side-by-side accelerator SAP HANA as a reporting server SAP HANA as a database SAP HANA as a platform with an SAP HANA XS application.
NO.144 Why might you use the keep flag in an aggregation node? Please choose the correct answer.
Response: To retain the results of the aggregation node for reuse in a drill-down based on hierarchy To ensure that the aggregation behavior defined in the aggregation node for a measure CANNOT be overridden by a query To include columns that are NOT requested by a query but are essential for the correct result.
NO.145 Which sentence best describes SAP HANA Live? Please choose the correct answer.
Response: Operational reporting moving back to the OLAP system Analytical reporting moving back to the OLAP system Analytical reporting moving back to the OLTP system Operational reporting moving back to the OLTP system.
NO.146 How many tiers do you usually find in an SAP HANA application? There are 2 correct answers to this question.
Response: 3 1 4 2.
NO.147 In which programming languages can you create procedures in SAP HANA?
There are 2 correct answers to this question. Response: L SQLScript R JavaScript.
NO.148 Why would you create a procedure? There are 2 correct answers to this question. Response: If you need to insert records into a table If you need to define a calculated column expression If you need to provide a data source to a graphical calculation view If you need a mixture of scalar and tabular output parameters.
NO.149 Which join types are available in a Join node of a calculation view? There are 2 correct answers to this question.
Response: Temporal joins Referential joins Cross joins Spatial joins.
NO.150 Which of these is used to build the virtual data model for SAP S/4HANA? Please choose the correct answer.
Response: SAP HANA Live ABAP CDS SAP HANA CDS Universe.
NO.151 You want to use a field in a formula but don't want to expose the values of the original field to the end users. What do you do?
Please choose the correct answer. Response: Change the data type of the field. Mark the field as hidden. Rename the field. Make the field a key column.
NO.152 When can you expose a hierarchy that is defined in a calculation view for access with SQL? Please choose the correct answer.
Response: When the hierarchy is a local hierarchy When the hierarchy is a shared hierarchy When the hierarchy is defined in a calculation view of type CUBE When the hierarchy is defined in a calculation view of DEFAULT.
NO.153 Which of the following data provisioning tools can provide a delta load of a table from the source system?
Please choose the correct answer. Response: SAP Landscape Transformation Replication Server SDA SAP HANA streaming analytics Flat files.
NO.154 Which of the following database terms are used when providing OLAP data with hierarchies?
There are 3 correct answers to this question. Response: BICS ODBC JDBC MDX ODBO.
NO.155 Using SAP Analysis for Microsoft Office, your calculation view on SAP application data returns data from two clients. In SAP Web IDE, you have identified the column to be used as the client column.
Which of the following approaches will return data from only one client? Please choose the correct answer.
Response: Create a Union node with two sources. Filter one source on client 001 and the other source on client 002. Set the default client property of the Semantic node to Session Client Set the preferred client in the user settings of SAP HANA. Create a Context for each client. Assign the relevant Context to each user. Create a variable on the client column in the properties of the Star join node. Set flexible default values set for each user.
NO.156 What can you determine using the hierarchy function in a calculation view? There are 3 correct answers to this question.
Response: Number of siblings for a hierarchy node Distance between root and each hierarchy node Source attributes of a composite hierarchy node Hierarchy nodes that have no parent Time interval of hierarchy nodes.
NO.157 Which variable type would you define if you want to use operators such as Greater Than or Less Than?
Please choose the correct answer. Response: Multiple Entries Interval Expression Range.
NO.158 The company asks you to get data from IoT sensors. Which SAP tools could you use? There are 3 correct answers to this question.
Response: SAP Landscape Transformation Replication Server SAP HANA Remote Data Sync (RDSync) SAP HANA smart data access (SDA) SAP HANA streaming analytics SAP SQL Anywhere.
NO.159 What predicate do you use for fuzzy text search in the WHERE clause of a SQL statement? Please choose the correct answer.
Response: IN CONTAINS ANY LIKE.
NO.160 What are components of SAP HANA EIM?
There are 2 correct answers to this question. Response: SDQ SDA SDS SDI.
NO.161 What are the currency conversion functionalities supported by SAP HANA? There are 3 correct answers to this question.
Response: Determination of target currency based on attributes or input parameters Conversion based on customer-defined tables Enabling of decimal shifts Multiple exchange rate types.
NO.163 You created a user-defined function with a return type of BIGINT. What type of function have you created?
Please choose the correct answer. Response: SQL function Window function Scalar function Table function.
NO.164 You have a table with two columns, CUSTOMER NAME and COUNTRY NAME, In which Italian customers are stored. You have an identical table in which you store French customers.
What type of calculation view should you create to combine the customers in to two columns that mirror the structure of the sources tables?
Please choose the correct answer. Response: Calculation view of cube type with a join node Calculation view of cube type with a union node Calculation view of dimension type with a join node Calculation view of dimension type with a union node.
NO.165 Why is an integrated deployment approach preferred over the side-car approach to SAP HANA Live?
There are 2 correct answers to this question. Response: Data is available in real time using SLT There is no data movement. It provides a quick start for customers using Business Suite on non HANA databases. It offers a simplified landscape.
NO.166 You have Model B that is based on Model A.
You have NOT built any of the models yet. You delete Model A. What happens during the build?
There are 2 correct answers to this question. Response: The build of Model B is successful You get an error when you build the entire HDB module The build of the entire HDB module is successful You get a build error when you build Model B.
NO.167 Identify the object that adds a WHERE clause to the query. Please choose the correct answer.
Response: Variable Input parameter Attributes Modeler.
NO.168 What is normally used to build SAP HANA XSC applications inside SAP HANA? There are 2 correct answers to this question.
Response: JavaScript SAPUI5 ABAP Java.
NO.169 Which of the following data sources can you include in a graphical calculation view?
There are 2 correct answers to this question. Response: Table function Procedure SQL VIEW Scalar function.
NO.170 What node can you use for sorting results, for example, to show the top 100? Please choose the correct answer.
Response: Union node Rank node Aggregation node Projection node.
NO.171 What are the features of a parent-child hierarchy? There are 3 correct answers to this question.
Response: Recursive data structure defines the hierarchy. A single dedicated column is used to store the parent of each record of the table. Parent and child field have the same data type. Heterogeneous fields are combined in a hierarchy.
NO.172 In which SAP HANA deployment scenarios will end users be created as users in the SAP HANA system?
There are 2 correct answers to this question. Response: SAP BW powered by SAP HANA SAP HANA Live SAP HANA as a platform SAP S/4HANA.
NO.173 Why do you create a multistory table? Please choose the correct answer.
Response: To have a table that combines the characteristics of row and column stores To improve read performance when accessed by simultaneous applications To evenly distribute the data across all available server nodes To have the option to partition the table across different storage tiers.
NO.174 The relational model of SAP HANA Live is built using which type of views? Please choose the correct answer.
Response: Analytic views and attribute views Calculation views of data category cube without star join Calculation views of data category cube with star join Scripted calculation views.
NO.175 What are the advantages of columnar storage? There are 2 correct answers to this question.
Response: Improved performance when all fields are selected Improved data reading performance Improved data writing performance Improved compression.
NO.176 What does SQLScript provide in SAP HANA? There are 3 correct answers to this question.
Response: Variables to break up complex statements Powerful client-side processing Creation of column tables Flow control logic Aggregation functions such as AVG().
NO.177 You're given an old government paper form with lines, blocks, and fields. You're asked to create a report that looks like this form.
Which business intelligence tools do you use? Please choose the correct answer.
Response: SAP Lumira, discovery edition SAP Lumira, designer edition SAP Crystal Reports for Enterprise SAP BusinessObjects Web Intelligence.
NO.178 You need a business intelligence tool that is Microsoft Excel-based and can use parent-child hierarchies.
Which tool do you use?
Please choose the correct answer. Response SAP BusinessObjects Web Intelligence SAP Lumira, discovery edition SAP Analysis for Microsoft Office SAP Lumira, designer edition.
|
