Questions
ayuda
option
My Daypo

ERASED TEST, YOU MAY BE INTERESTED ONConceptos básicos Libro 1 y 2

COMMENTS STATISTICS RECORDS
TAKE THE TEST
Title of test:
Conceptos básicos Libro 1 y 2

Description:
Conceptos básicos Libro 1 y 2

Author:
Erik
(Other tests from this author)

Creation Date:
05/10/2016

Category:
Others

Number of questions: 234
Share the Test:
Facebook
Twitter
Whatsapp
Share the Test:
Facebook
Twitter
Whatsapp
Last comments
No comments about this test.
Content:
In which SAP HANA solution do you eliminate stored data, like year­to­date figures? Please choose the correct answer. SAP BW on SAP HANA SAP S/4HANA SAP HANA Enterprise Cloud SAP CRM on SAP HANA.
What can a variable be used for? Please choose the correct answer. Currency conversion Calculated column expression Filtering Call decision table in SQLScript.
What node uses a special configuration table to optimize performance? Please choose the correct answer. Aggregation node Union node Join node Projection node.
You want to pause the SLT replication in SAP HANA studio. What do you select to achieve this? Please choose the correct answer. Quick View Data Provisioning Stop Quick View Import Selected Import of Metadata Quick View Data Provisioning Suspend Quick View Configure Import Server.
You created a procedure without defining the security option. Which user’s authorizations are checked when the procedure is executed in production? Please choose the correct answer. The developer that created the procedure The user calling the function The _SYS_REPO user The system administrator that transported the procedure.
Which tab in SAP HANA studio shows validation check errors? Please choose the correct answer. Job Log History Problems Properties.
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. SAP BusinessObjects Design Studio SAP Crystal Reports for Enterprise SAP Lumira SAP BusinessObjects Web Intelligence.
You want to use a web­based transport system on your Apple iPad. What tool do you use? Please choose the correct answer. Developer mode SAP Solution Manager SAP HANA Application Lifecycle Manager CTS.
Where in SAP HANA studio can you unload a table’s data from memory? Please choose the correct answer. The list of export destinations The context menu of the table The data preview of the table The table definition.
What type of load does SAP HANA perform when starting up? Please choose the correct answer. Complete load Lazy load Log load Fast load.
True or False: The performance analysis mode is available for graphical cal­culation views in the SAP HANA web­based development workbench. Please choose the correct answer. False True.
You are using the SAP HANA studio. Which of the following SAP HANA modeling artifacts require the SAP HANA application function modeler (AFM) to be installed? There are 3 correct answers to this question. SAP HANA predictive analytics library (PAL) flows SAP HANA enterprise information manager (EIM) jobs SAP HANA smart data access (SDA) queries SAP HANA extended application services (XS) programs SAP HANA smart data streaming (SDS) projects.
Which development tools are available for creating SAP HANA information models? There are 2 correct answers to this question. Web­based development tool Java­based Eclipse tool iPad app for development Java applet in the browser.
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. The tables used by the join in the node The total number of records returned by the node The suggested filter for the tables in the join node The time taken by the join.
What SELECT statement is not recommended for use with column tables? Please choose the correct answer. SELECT in a subquery SELECT ALL SELECT * SELECT with a time­travel clause.
Which of the following database terms are used when providing OLAP data with hierarchies? There are 3 correct answers to this question. ODBC JDBC ODBO MDX BICS.
What technique is used to convert record updates into insert statements in the delta buffer? Please choose the correct answer. Unsorted inserts Parallelism Insert­only Sorted inserts.
What is the recommended way to create full­text indexes going forward? Please choose the correct answer. Core Data Services SQL statements in the SQL Console Procedures User­defined functions.
You have to build a parent–child hierarchy. What type of join do you expect to use? Please choose the correct answer. Temporal join Self-­join Dynamic join Relational join.
What are the advantages of columnar storage? There are 2 correct answers to this question. Improved data reading performance Improved compression Improved performance when all fields are selected Improved data writing performance.
What do you call the data displayed in the data foundation of an SAP HANA information view? Please choose the correct answer. Facets Measures Characteristics Key figures.
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. Create a filter expression Create a rank column Create a restricted column Create an action.
Which data provisioning tools can use SAP HANA adapters? There are 2 correct answers to this question. SDI SDA SRS SDS.
What must be installed for PAL to work? Please choose the correct answer. SAP HANA BFL SAP HANA SINA SAP HANA AFM SAP HANA AFL.
Which of the following describe design­time objects? There are 3 correct answers to this question. Inactive Repository objects Catalog objects Active Native objects.
What information can you find in the Explain Plan tool? There are 2 correct answers to this question. The execution engines used The time taken for each step The list of operators The number of records returned in each step.
A referential join gives the same results as which other join type? Please choose the correct answer. Inner join Star join Left outer join Spatial join.
Which of the following VDM views can be called by applications and reports? There are 2 correct answers to this question. Private views Query views Value help views Reuse views.
When loading data to SAP HANA using SAP Data Services, where can job definitions be stored? Please choose the correct answer. In an SAP HANA database In the SAP HANA studio In an SAP HANA XS application In an SAP HANA flowgraph.
In which deployment scenarios does security stay in the application server, and end users do not log into the SAP HANA system? There are 2 correct answers to this question. SAP HANA as an accelerator SAP HANA as a database SAP HANA as a platform with an SAP HANA XS application SAP HANA as a sidecar solution.
What combination enabled real­time computing? Please choose the correct answer. In­memory technology with solid­state disks Multicore CPUs and solid­state disks In­memory technology and multicore CPUs Multicore CPUs with large level 1 caches.
What do you use in a SQL query to sort fuzzy text search results by relevance? Please choose the correct answer. SCORE() TOP RANK() SORT BY.
Which can a level hierarchy do? Please choose the correct answer. Have time­dependency Be used for a bill of materials structure Enable drill­down in a value help list Show variable deepness in the data.
Which modeling objects can you create in a package in SAP HANA studio? There are 2 correct answers to this question. Procedures Schemas Triggers Calculation views.
What statement do you have to run before you can return table results from a procedure? Please choose the correct answer. CREATE TYPE CREATE VIEW CREATE TABLE CREATE TABLE TYPE.
Where do you create a variable? Please choose the correct answer. In the scenario area of an aggregate node In the context menu of a package In the semantics node In the output area of a join node.
Of which SAP HANA process are the transaction manager and page manager a part? Please choose the correct answer. Index server Statistics server Name server SAP HANA XS server.
What engine executes the spatial queries? Please choose the correct answer. SQL Join Calculation OLAP.
True or False: VMware vSphere virtual machines are fully supported for pro­ductive SAP HANA instances. Please choose the correct answer. True False.
True or False: You can create custom query views by directly modifying SAPdelivered query views. Please choose the correct answer. True False.
Which are valid descriptions of delivery units? There are 2 correct answers to this question. Can be imported Are used to transport runtime objects Can be exported Always consist of one package.
What can you use to limit users to see only 2016 data? There are 2 correct answers to this question. A SQL analytic privilege A view with a filter An object privilege A view with a restricted column.
In a graphical calculation view of type cube, two tables are joined on multiple columns in a join node. Most queries using the view have no problems, but one query always gets a query runtime error. What is the cause of this error? Please choose the correct answer. An incorrect column was selected when the join was formed. The two tables are joined with a dynamic join. The language column is NOT specified in the join. The two tables do NOT have referential integrity.
Which of the following statements describe a standard SAP system land­ scape used for transports? Please choose the correct answer. You perform development in the quality assurance system. The quality assurance system is normally a recent copy of the production system. It consists of only a quality assurance and a production system. Transports go from production to quality assurance.
What is a new and recommended way to work with SQL and SQLScript? Please choose the correct answer. Create runtime objects rather than design­time objects. Use table functions rather than scripted calculation views. Use CE­functions rather than SQL syntax. Use .procedure files rather than creating SQL and SQLScript via the package context menu.
What type of input parameters do you use to choose the data from a field in the current table? Please choose the correct answer. Derived from table Direct Column Value help.
What do you use a Transient Provider for? Please choose the correct answer. To expose an SAP HANA calculation view as an OData web service To expose an SAP BW information object inside SAP HANA To use an SAP HANA calculation view in the SAP BW application To use an SAP HANA calculation view in Microsoft Excel.
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 correct answer. Store green as a spatial data type Store green as a measure Store green as a CDS view Store green as an attribute.
The company’s board members want to run simulations on the year­end financial data. What do you use to build this for them? Please choose the correct answer. An expression A parent­child hierarchy A decision table A variable.
What can you use as data sources for a decision table? There are 2 correct answers to this question. Table types CDS views Calculation views Scalar functions.
In which programming languages can you create procedures in SAP HANA? There are 2 correct answers to this question. SQLScript R JavaScript L.
Look at Figure You are selling books that have been translated into various languages. What join type should you use? Text join Temporal join Referential join Left outer join.
What should you keep in mind about user­defined functions? Please choose the correct answer. They can use dynamic SQL. They can use imperative logic. They can commit transactions. They can call procedures.
In which type of node can you create calculated columns? There are 2 correct answers to this question. Union node Rank node Projection node Join node.
For which data types does SAP HANA automatically create full­text indexes? There are 3 correct answers to this question. BINTEXT NVARCHAR TEXT SHORTTEXT CLOB.
What is the default node for a calculation view of type cube? Please choose the correct answer. Aggregation node Join node Projection node Star join node.
Your newly created information view does NOT want to activate. For which system user must you grant read access to your schema? Please choose the correct answer. SYS SYSTEM _SYS_TASK _SYS_REPO.
To what subset of SQL does the SELECT statement belong? Please choose the correct answer. DCL DQL DML DDL.
True or False: SAP HANA Live replaces SAP BW. False True.
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. The SYSTEM user The owner of the function The user calling the function The _SYS_REPO user.
What character is used to terminate SQL statements? Please choose the correct answer. ? (question mark) . (period) : (colon) ; (semicolon).
What performance techniques should you implement to improve join per­ formance? There are 3 correct answers to this question. Use left outer joins instead of right outer joins. Use unions instead of joins for combining large data sets. Always specify the cardinality of a join. Join as many tables as possible in an analytic view’s data foundation. Always mark joins as dynamic to improve performance.
Which of the following SAP data provisioning tools can provide real­time data provisioning? There are 3 correct answers to this question. SAP Data Services DXC SLT SRS SDI.
What does SAP HANA load when starting up and before indicating that it is ready? There are 3 correct answers to this question. Some column tables All system tables All partitions All row tables Some row tables.
True or False: A database view stores data in the database. False True.
Which spatial data formats can you import into SAP HANA? There are 2 correct answers to this question. GeoJSON ESRI shapefiles Well Known Text (WKT) Scalable Vector Graphic (SVG).
Which words are associated with the log volume? There are 2 correct answers to this question. Synchronous Page manager Savepoint Transaction manager.
In which SAP HANA views will you find measures? There are 2 correct answers to this question. Calculation view of type cube with star join Attribute views Calculation view of type cube Database views.
You 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. What do you use? Please choose the correct answer. An input parameter from the semantics node A variable from a projection node An input parameter from an aggregation node A variable from the semantics node.
What join type should you use to see all the suppliers? Please choose the correct answer. Right outer join Referential join Left outer join Inner join.
Which modeling views are fading out and are not available in the SAP HANA web­-based development workbench? There are 2 correct answers to this question. Graphical calculation views Scripted calculation views Attribute views Analytic views.
Which of the following terms are associated with an operational system? There are 2 correct answers to this question. Data warehouse OLAP Transactional OLTP.
What performance technique should you implement to improve the performance of SAP HANA information views? Please choose the correct answer. Output as many fields as possible. Implement union pruning conditions. Build single large views. Supply reporting tools with all the data in one transfer.
True or False: With SAP HANA, you can run OLAP and OLTP together in one system with good performance. True False.
You want to call a procedure in a SELECT statement (like a table function). Which clauses do you have to specify? There are 2 correct answers to this question. SEQUENTIAL EXECUTION WITH RESULTS VIEW LANGUAGE SQLSCRIPT READS SQL DATA.
In which subarea (folder) in the Systems view of SAP HANA studio can you find the SAP HANA database schemas? Please choose the correct answer. Security area Catalog area Provisioning area Content area.
True or False: A union returns all values in a result set, even duplicate records. True False.
What happens when you activate an information model? There are 2 correct answers to this question. It generates a runtime object. It checks the validation rules. It exports an active version. It reverts to the active version.
True or False: You can limit access to a subpackage if you have given access to the higher level package. True False.
For which deployment scenario does SAP deliver prebuilt data models? Please choose the correct answer. SAP HANA as a platform SAP HANA as an accelerator SAP HANA as a sidecar solution SAP HANA on the cloud.
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. The label property The label column property The mapping property The name property.
Modeling package Shops is a subpackage of package Regions. You want to authorize a user to list the content of package Regions, but prevent listing the content of package Shops. How can you achieve this? Please choose the correct answer. Revoke analytic privileges for models in package Shops. Refactor package Shops to another package. Assign REPO.READ privilege only to package Regions. Assign REPO.EXPORT only to package Shops.
You are writing a mobile application for the World Series. You have details about all the baseball players and the baseball scores for all the previous matches. How do you use the data of the player information and the scores? Please choose the correct answer. 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. The player information is used as transactional data, and the scores are used as master data. Both the player information and the scores are used as transactional data.
What information is available when you use the Explain Plan functionality on an SQL statement? There are 2 correct answers to this question. Execution engines Operator names Estimated execution time Estimated number of records.
Prior to modeling in SAP HANA, you want to check whether a table is row­based or column­based. How can you do this in the SAP HANA studio? There are 2 correct answers to this question. Select the Open Data Preview option. View the icon of the table. Select the Open Content option. Select the Open Definition option.
You want to reuse a decision table on multiple tables with a similar data structure. You design the decision table that passes a specific table name as an input parameter when you execute the decision table. What do you have to use in the data foundation to achieve this? Please choose the correct answer. A dynamic join A scripted calculation view A table type A virtual table.
You want to use a table to store results for each session but do not want to recreate the table for every session. What type of table should you create? Please choose the correct answer. Virtual table History column table Local temporary table Global temporary table.
Which text feature do you use to find sentiment in textual data? Please choose the correct answer. Full­text index Text mining Fuzzy text search Text analysis.
Which of the following are features of a data warehouse? There are 3 correct answers to this question. Data governance Consolidation Both OLTP and OLAP in one system Real­time reporting A full transactional history.
What statement is allowed in a user­defined function? There are 2 correct answers to this question. EXEC JOIN COMMIT INSERT.
What does the C in ACID­compliant stand for? Please choose the correct answer. Complete Constant Complexity Consistency.
What phrase describes the main table area in the delta merge scenario? Please choose the correct answer. Read­-optimized Row store Unsorted inserts Write­-optimized.
Which programming language do you use for streaming projects? Please choose the correct answer. SQLScript CCL JavaScript SQL.
True or False: A view always shows all the available columns of the underlying tables. True False.
What information can you find in the Visualize Plan tool? There are 2 correct answers to this question. The execution engines used The number of records returned in each step The time taken for each step The SQL Plan Cache.
You create a graphical calculation view that is consumed in ABAP. What setting in the currency semantics dialog box ensures that a currency column is interpreted correctly in the ABAP layer? Please choose the correct answer. Conversion Decimal shift Decimal shift back Rounding.
Which of the following node types can you use to build an analytic view? There are 3 correct answers to this question. Semantics node Data foundation node Aggregation node Star join node Union node.
Which of the following ways of publishing SAP HANA information model content could require some JavaScript knowledge? There are 2 correct answers to this question. Creating business intelligence content with SAP BusinessObjects Design Studio Creating a composite provider in SAP BW Creating a REST web service in the SAP HANA XS engine Creating a report in SAP Crystal Reports for Enterprise.
As what are most of the views in SAP HANA Live created? Please choose the correct answer. Table functions Calculation views CDS data sources Cubes.
What issue do you have to address after you have migrated your old views to calculation views? Please choose the correct answer. Check the analytic privileges for star join situations Unhide the hidden fields in the semantics node Manually migrate the base view for derived views Change filters on table columns to filter expressions.
True or False: When you use a parent–child hierarchy, the depth in your hierarchy levels can vary. True False .
What can you use to limit the number of records produced by a calculation view? There are 3 correct answers to this question. Filter expressions SAP client restrictions Generated columns Domain fix values Restricted columns.
Which type of cloud solution is Amazon Web Services (AWS) an example of? Please choose the correct answer. Community cloud Public cloud Hybrid cloud Private cloud.
True or False: The full­text index is stored in table $TA. False True.
Which business intelligence tool queries SAP HANA using MDX? Please choose the correct answer. SAP BusinessObjects Web Intelligence SAP Lumira Microsoft Excel SAP BusinessObjects Analysis, edition for Microsoft Office.
Which of the following SAP data provisioning methods provide complex transformations? There are 2 correct answers to this question SAP HANA smart data quality SAP HANA smart data access SAP Replication Server SAP Data Services.
You use parallelism to calculate a year­to­date value quickly, and you eliminate a table from the database. What are some of the implications of this action? There are 3 correct answers to this question. Better user interfaces Smaller database backups Faster response times Faster inserts into the database Less code.
What spatial data type would you use to store multiple shop locations? Please choose the correct answer. ST_Point ST_MultiPoint ST_Polygon ST_MultiLineString.
For what type of data are SAP HANA calculation views of type dimension used? Transactional data Master data Materialized cube data Calculated data.
Which are the recommended assignments in SAP HANA? There are 2 correct answers to this question Privileges to users Roles to users Roles to roles Roles to privileges.
True or False: SAP Data Services can read all the SAP extractors. True False.
What can be used to return multiple result sets? There are 2 correct answers to this question. Scalar function Table function Procedure View.
What system privilege do you need to create a delivery unit? Please choose the correct answer. REPO.EXPORT REPO.IMPORT REPO.MAINTAIN_DELIVERY_UNITS REPO.WORK_IN_FOREIGN_WORKSPACE.
True or False: When you mark a calculation view as deprecated, that view no longer works. True False.
In which schema does SAP HANA store an activated graphical calculation view? Please choose the correct answer. SYSTEM SYS _SYS_BI _SYS_BIC.
You have a list of map locations for clinics. The government wants to build a new clinic, but wants to build it 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 correct answer. Use a temporal join to find the distance between clinics. Use a union with constant values to “pivot” the values. Use a spatial join to find the distance between clinics. Use a level hierarchy for drilldown. Use a dynamic join to find the longest distance between clinics. Use a ranking to find the top 10 values. Use a spatial join to find the distance between clinics. Use an aggregation with the maximum option.
Where is SAP HANA Live installed? Please choose the correct answer. On SLT On the SAP ERP application server In the reporting tool In the SAP HANA database.
With which statement can you call a table function? There are 2 correct answers to this question. CALL INSERT INTO SELECT EXEC.
Which statements describe the mass copy feature in SAP HANA? There are 2 correct answers to this question. It can be used to create a sandbox (playpen) environment. It is used to import an application from an SAP partner. It is used to transport data tables. It can be used to fix models when schemas have different names.
Which tables do you need for currency conversion? Please choose the correct answer. DD07* TCUR* BICS* SHINE*.
True or False: You can view metadata of SAP HANA Live views with the business user version of the SAP HANA Live Browser. True False.
In which package in SAP HANA will you find the SAP HANA Live views? Please choose the correct answer. /sap/hana/democontent /public /sap/hba /sap/bc.
In which SAP HANA studio perspective do you find the Quick View tab options? Please choose the correct answer. Administration perspective Developer perspective Modeler perspective Plan visualizer perspective.
True or False: When you upgrade SAP HANA Live content, you can choose to keep your modifications. False True.
True or False: Object privileges on a table with SELECT rights will allow you to access to all the data. True False.
True or False: CDS only works with runtime objects. True False.
What API would you use in SAP HANA SPS 11 to display search results in an ABAP system? Please choose the correct answer. The esh_search procedure SAP HANA Simple Info Access API (SINA) SAP HANA Text Mining XS JavaScript API SAP HANA Text Analysis XS JavaScript API.
How do you move code to SAP HANA? There are 2 correct answers to this question. Delete the application server Use stored procedures in SAP HANA Use graphical data models in SAP HANA Use row tables in SAP HANA.
What node can you use to generate a column for use in sorting results? Please choose the correct answer. Aggregation node Projection node Rank node Union node.
You want to build a hierarchy on a time­based data structure. What type of hierarchy do you use? Please choose the correct answer. Parent­child hierarchy Level hierarchy Ragged hierarchy Unbalanced hierarchy.
Which features are similar between an analytic view and a calculation view of type cube with star join? There are 3 correct answers to this question. Fact tables Spatial joins Temporal joins Referential joins Star join nodes.
Which SAP HANA studio function displays the views that will be affected when you rename an attribute view? Please choose the correct answer. Neighbor Where­used list Properties Tables used.
You created a user­defined function with a return type of BIGINT. What type of function have you created? Please choose the correct answer. SQL function Scalar function Table function Window function.
What performance technique should you implement to improve join performance? Please choose the correct answer. Use joins instead of unions for combining large data sets. Join on key fields between tables in a dimension view. Do NOT use dynamic joins if you require optimal performance. Always use referential joins in star join views.
Which type of cloud solution is SAP HANA Enterprise Cloud (HEC) an exam­ple of? Please choose the correct answer. Platform as a Service (PaaS) Infrastructure as a Service (IaaS) Software as a Service (SaaS) Managed Cloud as a Service (MCaaS).
For which of the following tasks can you use Auto Documentation? Please choose the correct answer. Documenting all transported information models Documenting all graphical information models Documenting all activated information models Documenting all created information models.
What are the values for X, Y, and Z? Please choose the correct answer. X = Customer 2, Y = 400, Z = 800. X = Customer 1, Y = 800, Z = 800. X = Customer 2, Y = 200, Z = 400. X = Customer 1, Y = 400, Z = 400.
You want to use a field in a formula but do not want to expose the values of the original field to the end users. What do you do? Please choose the correct answer. Change the data type of the field Rename the field Make the field a key column Mark the field as hidden.
Where in the Systems view of SAP HANA studio can you create new SAP HANA models? Please choose the correct answer. In the packages of the Content area In the schemas of the Content area In the schemas of the Catalog area In the packages of the Catalog area.
A traditional cube is represented by which SAP HANA view type? There are 2 correct answers to this question. Attribute view Calculation view of type dimension Calculation view of type cube with star join Analytic view.
What is the correct sequence for loading data with SAP Data Services? Please choose the correct answer. Extract Transform Load Load Transform Extract Load Extract Transform Extract Load Transform.
What should you keep in mind when using imperative logic in SQLScript? Please choose the correct answer. You can loop through records. You can only use if­then logic. It delivers the best possible performance. It matches SQL’s set­oriented paradigm.
True or False: CDS can improve security in a production environment. True False.
What does the migration tool allow you to migrate? Please choose the correct answer. XML analytic privileges to table functions Object privileges to SQL analytic privileges XML analytic privileges to SQL analytic privileges SQL analytic privileges to XML analytic privileges.
What paradigm describes the SQL language? Please choose the correct answer. Procedural Set­-oriented Application­-focused Object­-oriented.
What do you have to assign to users to allow single sign­on? Please choose the correct answer. SQL analytic privileges Kerberos authentication TRUST ADMIN system privilege Application privileges.
You are given an old government paper form with lines, blocks, and fields. You are asked to create a report that looks like this form. Which business intelligence tools do you use? Please choose the correct answer. SAP BusinessObjects Web Intelligence SAP Crystal Reports for Enterprise SAP BusinessObjects Design Studio SAP Lumira.
Which join type makes use of date ranges? Please choose the correct answer. Spatial join Text join Inner join Temporal join.
What variable type do you use if you want to allow the user to choose dates from 2011 to 2014? Please choose the correct answer. Range Single value Interval Multiple entries.
Where do you graphically create a design­time role in SAP HANA? Please choose the correct answer. In the Roles area under Security in SAP HANA studio In the Repository area in the development perspective in SAP HANA studio In the Security area of the SAP HANA web­-based development workbench In the Editor area of the SAP HANA web-­based development workbench.
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. Change the join to a text join. Change the join to a referential join. Change the join to a right outer join. Keep the left outer join.
What SAP HANA information object does AFM create? Please choose the correct answer. Calculation view Attribute view Procedure Table function.
Which of the following are results of deploying SAP HANA as a distributed (scale­ out) solution? There are 3 correct answers to this question. Partitioning Failover Disaster recovery High availability Backups.
What do you create to find the number of unique items sold per shop? Please choose the correct answer. A calculation view with a counter in a projection node A calculation view with a counter in an aggregation node A calculation view with a restricted column in an aggregation node An analytic view with a calculated column in an star join node.
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 correct answer An analytic privilege on the WORLD calculation view An analytic privilege on the both calculation views An analytic privilege on the INDIA calculation view An object privilege on the WORLD calculation view.
Which of the following views can you extend with the SAP HANA Live Extension Assistant? Please choose the correct answer. Your own custom views Reuse views All SAP­delivered views Query views with a union.
You want to retrieve data from a web application. Which of the following could you use? There are 3 correct answers to this question. REST BICS OData JSON JDBC.
What type of join should you use? Please choose the correct answer. Temporal join Text join Referential join Inner join.
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. SAP S/4HANA SAP HANA as a platform SAP HANA Live SAP BW powered by SAP HANA.
What PAL algorithm would you use to analyze shopping baskets? Please choose the correct answer. Decision tree K-­means Link prediction Apriori.
Which technologies does SAP HANA use to load more data into memory? There are 3 correct answers to this question. Use multicore CPU parallelism Use dictionary compression Use RAR compression Eliminate indices Store data in column tables.
Which of the following data provisioning tools can you use to read data directly from Twitter? There are 3 correct answers to this question. SAP Data Services SRS SAP HANA XS engine SDA SDI.
What data source is available for join nodes in calculation views? Please choose the correct answer. Calculation views from other tenants in an MDC system Scalar functions from all SAP HANA systems All procedures in the current SAP HANA system Web services from the Internet.
You are writing SQLScript code for handling sensitive data. What statement is prone to the SQL injection? Please choose the correct answer. CREATE TYPE EXEC INSERT INTO GRANT.
True or False: Delimited identifiers are treated as case­-sensitive. False True.
What PAL algorithm category can you use for supervised learning? Please choose the correct answer. Social network analysis Classification Clustering Association.
What does SAP HANA smart data integration use for data provisioning? There are 3 correct answers to this question Database triggers Database logs Real-­time adapters SAP HANA smart data access SAP HANA smart data streaming.
For what SQL keyword is the aggregation node the equivalent? Please choose the correct answer. DISTINCT UNIQUE GROUP BY ORDER BY.
Where in SAP HANA studio can you see if a table is row-­based or column­-based? There are 2 correct answers to this question. The table’s icon The context menu of a table The tooltip that appears on mouse hover over the table title The table definition.
What can you do in the Raw tab of the data preview in SAP HANA studio? There are 2 correct answers to this question. Create a graph while analyzing the entire data result set. Sort the entire data result set and show the top 200 records. Show all distinct values in the entire data result set. Export the entire data result set to your local machine.
True or False: SAP HANA contains both row and column tables. True False.
Which are features of a calculated column? There are 2 correct answers to this question. It is created in the semantics node It is a column in the result set Its calculations are persisted It is created in the output area.
You want to use a web­based transport system on your Apple iPad. What tool do you use? Please choose the correct answer. Developer mode CTS SAP HANA Application Lifecycle Manager SAP Solution Manager.
Which actions does refactoring typically use? There are 2 correct answers to this question. Renaming Deleting Moving Transporting.
With which of the following do you build the vocabulary of a decision table? Response: Actions Measures Conditions Attributes.
For what tasks would you use the Where­-Used feature in SAP HANA? Please choose the correct answer. To find all places a transport is imported To find all places an information model is used To find all places where translations exist To find all places a user updated information models.
You have created a SQL analytic privilege on an information view. Where do you tell the view to enable SQL analytic privileges? Please choose the correct answer. In the restrictions settings of the SQL analytic privilege In the SAP HANA studio preferences In the semantic node of the information model In the migration tool.
You are working with a currency measure. What is decimal shift used for? Please choose the correct answer. Increase the accuracy of the currency conversion For currencies with more than two decimal places Avoid rounding errors during the conversion To undo the decimal adjustment for ABAP.
Why would you recommend SAP Replication Server? Please choose the correct answer. If database administrators do not want triggers in their database. If the data is financial ticker tape data. If the data contains some rubbish information in several places. If the source data is in a virtual table.
You are loading data into SAP HANA using DXC. Which of the following are executed in the embedded SAP BW system? There are 3 correct answers to this question. Transformation IMDSO InfoPackage Activation Extractor.
Your schemas in development and production have different names. What do you use to ensure you do not receive activation errors when importing information models into production? Please choose the correct answer. CDS Mass copy Schema mapping Refactoring.
In what type of view can you use fuzzy text search directly? Please choose the correct answer. Calculation views of type cube Analytic views Calculation views of type dimension Attribute views.
What feature is similar between an attribute view and a calculation view of type dimension? Please choose the correct answer. Derived views Full outer join Left outer join Fuzzy text search attributes.
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. SAP Lumira SAP BusinessObjects Analysis, edition for OLAP SAP BusinessObjects Web Intelligence SAP BusinessObjects Design Studio.
What SQL construct do you use to return multiple result sets from a single SQL statement? There are 2 correct answers to this question. UNION JOIN SELECT subquery GROUPING SETS.
You create a full­text index. For what text feature clause do you need to specify a configuration? Please choose the correct answer. TEXT ANALYSIS TEXT MINING SEARCH ONLY FUZZY SEARCH INDEX.
What is normally used to build SAP HANA XS applications inside SAP HANA? There are 2 correct answers to this question. Java SAPUI5 ABAP JavaScript.
In which subfolder of the _SYS_BIC schema do you find activated information models? Please choose the correct answer. Procedures Functions Views Column Views.
What predicate do you use for fuzzy text search in the WHERE clause of a SQL statement? Please choose the correct answer. ANY CONTAINS IN LIKE.
Which business intelligence tools use BICS connectivity to SAP HANA? There are 2 correct answers to this question. SAP Lumira Microsoft Excel SAP BusinessObjects Design Studio SAP BusinessObjects Analysis, edition for Microsoft Office.
You are writing SQLScript code for handling prone sensitive data. What statement is to the SQL injection? Please choose the correct answer. CREATE TYPE GRANT EXEC INSERT INTO.
Which of following are features associated with SAP HANA Live? There are 2 correct answers to this question. Web­-based tools Hundreds of predeveloped views A new data warehouse Precalculated aggregates stored in cubes.
What character is prepended to a SQLScript variable when it is used as an input variable? Please choose the correct answer. _ (underscore) : (colon) & (ampersand) ! (exclamation mark).
Which of the following are examples for validation rules? There are 2 correct answers to this question. Check formulas in calculated columns Check that graphical calculation views have no orphan nodes Check that tables contain data Check that attribute views have a key attribute specified.
What should you keep in mind when using dynamic SQL? There are 2 correct answers to this question. It could be used for SQL injection. It delivers the best possible performance. You can dynamically change your data sources. It is always bad for security.
Schema mapping is used during which process? Please choose the correct answer. Validation Activation Exporting Importing.
Why would you recommend SAP Replication Server? Please choose the correct answer. If database administrators do not want triggers in their database. If the data contains some rubbish information in several places. If the data is financial ticker tape data. If the source data is in a virtual table.
What performance technique should you implement to improve the performance of SAP HANA information views that include SQLScript? Please choose the correct answer. Use SELECT *. Break large statements into smaller steps. Use dynamic SQL Use imperative logic.
What enables the delta buffer technique to speed up both reads and inserts in SAP HANA? Please choose the correct answer. Using only the insert­only technique Using both row-­based and column-­based tables Using column-­based tables only Using row­-based tables only.
True or False: The default behavior of SAP HANA is to allow access. Please choose the correct answer. False True.
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. Use a left outer join. Filter to show only customers 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 right outer join. Filter to show only the NULL values on the right table.
You have created a SQL analytic privilege on an information view. Where do you tell the view to enable SQL analytic privileges? Please choose the correct answer. In the migration tool In the SAP HANA studio preferences In the semantic node of the information model In the restrictions settings of the SQL analytic privilege.
Where can you create a filter expression? Please choose the correct answer. In the semantics node In a projection node In a data foundation node In an aggregation node.
What performance techniques should you implement to improve the performance of SAP HANA information views? There are 3 correct answers to this question. Apply filters as late as possible. Minimize the transfer of data between the execution engines. Perform calculation before aggregation in your analytic views. Push down aggregations to SAP HANA. Investigate partitioning of large tables.
What type of join should you use? Please choose the correct answer. Temporal join Referential join Inner join Text join.
What tool generates files to help configure SLT table replication? Please choose the correct answer. SAP HANA Live Extension Assistant SAP HANA Live Browser Authorization Assistant SAP HANA studio.
What node is used to link dimension views to a data foundation (fact tables)? Please choose the correct answer. Union node Projection node Join node Star join node.
Which of following are features associated with SAP HANA Live? There are 2 correct answers to this question. Web-­based tools Hundreds of predeveloped views Precalculated aggregates stored in cubes A new data warehouse.
Which of the following data operations can you perform with SDA? There are 3 correct answers to this question. Data federation Logical data warehouse Big data Physical data warehouse Real­-time replication.
What is the preferred way to create a procedure? Please choose the correct answer. Create a .procedure file. Use the CREATE PROCEDURE statement in the SQL Console. Use the context menu of a package. Create a .hdbprocedure file.
Which export option can you use to make backups of your own information models? SAP Support mode Delivery units CTS Developer mode.
Refactoring is used with which of the following actions? Improving your modeling design Translating Documenting Transporting.
In which direction do you build calculation views when including the source tables in join nodes? From the join nodes up to the semantic node From the join node down to the default node From the semantic node down to the join nodes From the semantic node up to the default node.
Which sentence best describes SAP HANA Live? Analytical reporting moving back to the OLTP system Operational reporting moving back to the OLAP system Operational reporting moving back to the OLTP system Analytical reporting moving back to the OLAP system.
What predicate do you use for fuzzy text search in the WHERE clause of a SQL statement? LIKE ANY IN CONTAINS.
Which types of calculation views can you create? Standard Materialized Derived Time-based.
What artifacts do you use in the output area of a decision table node? Restrictions Input parameters Conditions Actions.
You are creating a currency conversion. What options do you have for the Target Currency field? Use the Derived from Table option Use an input parameter Select a column Select a fixed currency Select a table type.
What is normally used to build SAP HANA XS applications inside SAP HANA? SAPUI5 ABAP Java JavaScript.
What should you keep in mind about procedures? They may have input parameters. They can call views. They are NOT open to SQL injection. They can call table functions. They must return values.
Which of the following data provisioning tools can provide a delta load of a table from the source system? DXC SDS Flat files SDA.
You created a calculated column in an analytic view for a table containing the number of units ordered, the price per unit, and the number of units in stock. You get the wrong results in your results. What could be the problem? Please choose the correct answer. You did NOT enable the currency conversion You chose the SQL expression syntax You mistyped the calculated column expression You did NOT enable calculate before aggregation.
Which tasks are part of the migration tool workflow? There are 2 correct answers to this question. The tool produces a table function linked to a graphical calculation view. The tool requires a graphical calculation view as input. The tool requires a script-based calculation view as input. The tool produces only a table function.
You get the following requirements from a customer: They have a lot of purchasing data in their SAP system which they wish to analyze in SAP HANA. They want to have reports every morning showing the total expenditure per department. Their SAP BW developers have not yet had any SAP HANA training. Which data provisioning tool would you recommend? EIM DXC SLT SDA.
When do you always have both an active and an inactive version of an infor- mation model available in the SAP HANA development system? Please choose the correct answer. When you create a new model When you edit an existing model When you selected Revert to Active on an inactive version When validation of a model fails.
Which steps do you have to perform once before you can create SAP HANA development objects? There are 2 correct answers to this question. Create an SAP HANA XS project. Create a predictive model using PAL. Create a dataflow model in the AFM. Create a repository workspace.
You want to show a male and female option to users. What feature do you use? There are 3 correct answers to this question. Domain fix values Value help Input parameters Expressions Variables.
Which deployment scenario can you use to accelerate reporting from an old SAP R/3 4.6C system? Please choose the correct answer. SAP HANA multitenant database containers SAP HANA as a platform SAP HANA as a database SAP HANA as a sidecar solution.
What information can you find in the Administration Console? There are 2 correct answers to this question. The SQL Plan Cache The execution engines used The list of operators The trace and log files.
You want to publish your business intelligence content directly to SAP Cloud for Analytics. Which tool do you use? There are 2 correct answers to this question. SAP Predictive Analytics SAP Lumira SAP BusinessObjects Analysis, edition for Microsoft Office SAP Crystal Reports for Enterprise.
What is used in SQL to indicate that there is no value? Spaces Zero Empty quotes NULL.
Where can you set the default value for the SAP client for the entire calcula- tion view? In the Window menu of SAP HANA studio In the semantic layer of the calculation view In the default node of the calculation view In the join node of the calculation view.
Which of the following are reasons you should use Core Data Services (CDS) to create a schema? There are 2 correct answers to this question. The database administrator might type the name wrong. The database administrator should not get those privileges in the production system. The focus is on the database administration requirements. The focus is on the business requirements.
Which business intelligence tool can publish storyboards? SAP BusinessObjects Design Studio SAP BusinessObjects Analysis, edition for Microsoft Office SAP Predictive Analytics SAP BusinessObjects Web Intelligence.
Report abuse Consent Terms of use