Questions
ayuda
option
My Daypo

ERASED TEST, YOU MAY BE INTERESTED ONSh_2

COMMENTS STATISTICS RECORDS
TAKE THE TEST
Title of test:
Sh_2

Description:
Learning Test

Author:
Sh L
(Other tests from this author)

Creation Date:
24/05/2018

Category:
Others

Number of questions: 110
Share the Test:
Facebook
Twitter
Whatsapp
Share the Test:
Facebook
Twitter
Whatsapp
Last comments
No comments about this test.
Content:
Which spatial data formats can you import into SAP HANA? There are 2 correct answers to this question. Response: ESRI shapefiles Geo JSON Scalable Vector Graphic (SVG) Well Known Text (WKT).
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. Response: A scripted calculation view A virtual table A dynamic join A table type.
Which of the following are examples for validation rules? There are 2 correct answers to this question. Response: Check formulas in calculated columns Check that tables contain data Check that graphical calculation views have no orphan nodes Check that attribute views have a key attribute specified.
In which programming languages can you create procedures in SAP HANA? There are 2 correct answers to this question. Response: L R SQL Script JavaScript.
Which development tools are available for creating SAP HANA information models? There are 2 correct answers to this question. Response: Java applet in the browser Web-based development tool Java-based Eclipse tool iPad app for development.
In which schema does SAP HANA store an activated graphical calculation view? Please choose the correct answer. Response: _SYS BIC SYS _SYS_BI SYSTEM .
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.
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. Response: IMDSO Extractor Info Package Activation Transformation .
You want to build a hierarchy on a time-based data structure. What type of hierarchy do you use? Please choose the correct answer. Response: Parent-child hierarchy Ragged hierarchy Level hierarchy Unbalanced hierarchy.
What SAP HANA information object does AFM create? Please choose the correct answer. Response: Procedure Attribute view Table function Calculation view.
Which programming language you use for streaming projects? Please choose the correct answer. Response: SQL Script JavaScript SQL CCL .
When do you always have both an active and an inactive version of an information model available in the SAP HANA development system? Please choose the correct answer. Response: When you edit an existing model When you selected Revert to Active on an inactive version When you create a new model When validation of a model fails.
You want to use a web-based transport system on your Apple iPad. What tool do you use? Please choose the correct answer. Response: Developer mode SAP HANA Application Lifecycle Manager SAP Solution Manager CTS .
In which type of node can you create calculated columns? There are 2 correct answers to this question. Response: Join node Union node Projection node Rank node.
What information can you find in the Visualize Plan tool? There are 2 correct answers to this question. Response: The SQL Plan Cache The execution engines used The number of records returned in each step The time taken for each step.
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 filter expression Create an action Create a rank column Create a restricted column.
Which words are associated with the log volume? There are 2 correct answers to this question. Response: Synchronous Save point Transaction manager Page manager.
What PAL algorithm would you use to analyze shopping basket? Please choose the correct answer. Response: Decision tree K-means Apriority Link prediction .
You want to retrieve data from a web application. Which of the following could you use? There are 3 correct answers to this question. Response: JDBC JSON Data REST BICS .
What statement is allowed in a user-defined function? There are 2 correct answers to this question. Response: COMMIT EXEC JOIN INSERT.
What do you use a Transient Provider for? Please choose the correct answer. Response: 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 To expose an SAP HANA calculation view as an Data web service.
Which of the following are features of a data warehouse? There are 3 correct answers to this question. Response: Consolidation A full transactional history Real-time reporting Data governance Both OLTP and OLAP in one system .
Which tasks are part of the migration tool workflow? There are 2 correct answers to this question. Response: The tool requires a graphical calculation view as input. The tool requires a script-based calculation view as input. The tool produces a table function linked to a graphical calculation view. The tool produces only a table function.
Which export option can you use to make backups of your own information models? Please choose the correct answer. Response: Delivery units CTS Developer mode SAP Support mode.
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. Response: SAP HANA as a database SAP HANA as a sidecar solution SAP HANA as a platform with an SAP HANA XS application SAP HANA as an accelerator.
As what are most of the views in SAP HANA Live created? Please choose the correct answer. Response: Table functions Calculation views Cubes CDS data sources.
What must be installed for PAL to work? Please choose the correct answer. Response: SAP HANA AFM SAP HANA AFL SAP HANA BFL SAP HANA SINA.
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 SAP BusinessObjects Web Intelligence SAP Crystal Reports for Enterprise SAP BusinessObjects Design Studio.
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. Response: SYSTEM _SYS_TASK _SYS REPO SYS.
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 label property The mapping property The name property.
What information can you find in the Administration Console? There are 2 correct answers to this question. Response: The trace and log files The list of operators The execution engines used The SQL Plan Cache.
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 HANA XS engine SDI SDA SRS SAP Data Services.
You want to show a male and female option to users. What feature do you use? There are 3 correct answers to this question. Response: Input parameters Expressions Value help Domain fix values Variables.
You want to rename an information view with the SAP HANA Modeler without losing its existing behavior. What are the next steps after the renaming utility has finished? There are 2 correct answers to this question. Response: Adjust references to the information view in graphical calculation views. Adjust references to the information view in analytic views. Adjust references to the information view in procedures. Adjust references to the information view in table functions.
What do you call the data displayed in the data foundation of an SAP HANA information view? Please choose the correct answer. Response: Facets Key figures Characteristics Measures.
What SQL construct do you use to return multiple result sets from a single SQL statement? There are 2 correct answers to this question. Response: GROUPING SETS SELECT subquery JOIN UNION .
Which actions does refactoring typically use? There are 2 correct answers to this question. Response: Deleting Moving Renaming Transporting.
For what SQL keyword is the aggregation node the equivalent? Please choose the correct answer. Response: UNIQUE ORDER BY DISTINCT GROUP BY.
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: The total number of records returned by the node The suggested filter for the tables in the join node The tables used by the join in the node The time taken by the join.
With which statement can you call a table function? There are 2 correct answers to this question. Response: SELECT INSERT INTO CALL EXEC.
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: Flat files SDA DXC SDS.
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. Response: The focus is on the business requirements. The database administrator should not get those privileges in the production system. The database administrator might type the name wrong. The focus is on the database administration requirements.
Which join types are available in a join node of a calculation view? There are 2 correct answers to this question. Response: Cross joins Temporal joins Referential joins Spatial joins.
Refactoring is used with which of the following actions? Please choose the correct answer. Response: Translating Documenting Transporting Improving your modeling design .
Which modeling objects can you create in a Package in SAP HANA studio? There are 2 correct answers to this question. Response: Calculation views Triggers Procedures Schemas .
For which of the following tasks can you use Auto Documentation? Please choose the correct answer. Response: Documenting all transported information models Documenting all activated information models Documenting all created information models Documenting all graphical information models.
The entity is the core artifact for persistence-model definition using the CDS syntax You create a database entity as a design-time file in the SAP HANA repository. Which are the following prerequisites to create an entity in CDS (core data services)? There are 2 correct answers to this question Response: You must have deployed to schema for the CDS catalog objects You must have access to schema for the CDS catalog objects You must have access to an SAP HANA system You must have already created a development workspace and a project.
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. Response: Interval Range Single value Multiple entries.
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. Response: History column table Local temporary table Virtual table Global temporary table.
What should you keep in mind when using dynamic SQL? There are 2 correct answers to this question. Response: It is always bad for security. You can dynamically change your data sources. It could be used for SQL injection. It delivers the best possible performance.
If exchange the transaction "Laura buys 10 apples" to "Laura buys 10 green apples," how would we store the color green? Please choose the correct answer. Response: Store green as a CDS view Store green as a spatial data type Store green as a measure Store green as an attribute .
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. Response: You chose the SQL expression syntax You mistyped the calculated column expression You did NOT enable the currency conversion You did NOT enable calculate before aggregation.
What feature is similar between an attribute view and a calculation view of type dimension? Please choose the correct answer. Response: Fuzzy text search attributes Left outer join Full outer join Derived views.
Which deployment scenario can you use to accelerate reporting from an old SAP R/ 3 4.6C system? Please choose the correct answer. Response: SAP HANA as a sidecar solution SAP HANA multitenant database containers SAP HANA as a platform SAP HANA as a database.
In which subfolder of the _SYS BIC schema does you find activated information models? Please choose the correct answer. Response: Functions Column Views Procedures Views .
When loading data to SAP HANA using SAP Data Services, where can job definitions be stored? Please choose the correct answer. Response: In an SAP HANA database In an SAP HANA flowgraph In the SAP HANA studio In an SAP HANA XS application.
For which data types does SAP HANA automatically create full-text indexes? There are 3 correct answers to this question. Response: NVARCHAR CLOB BINTEXT TEXT SHORTTEXT .
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. Response: 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.
What is the default node for a calculation view of type cube? Please choose the correct answer. Response: Projection node Join node Aggregation node Star join node.
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. Response: Temporal joins Star join nodes Spatial joins Referential joins Fact tables.
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. Response: A parent-child hierarchy An expression A variable A decision table.
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 Table function Scalar function Window function.
In which SAP HANA solution do you eliminate stored data, like year-to-date figures? Please choose the correct answer. Response: SAP S/4HANA SAP BW on SAP HANA SAP HANA Enterprise Cloud SAP CRM on SAP HANA.
What information can you find in the Explain Plan tool? There are 2 correct answers to this question. Response: The number of records returned in each step The execution engines used The list of operators The time taken for each step.
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 user calling the function The SYS REPO user The owner of the function The SYSTEM user.
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. Response: Both the player information and the scores are used as transactional data. 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.
Which tab in SAP HANA studio shows validation check errors? Please choose the correct answer. Response: Properties History Problems Job Log.
You execute the performance validations for a calculation view. Which columns are checked by the 'Calculation in filter expression' rule? Please choose the correct answer. Response: Generated columns Restricted columns Numeric columns Aggregated columns.
Which SAP HANA studio function displays the views that will be affected when you rename an attribute view? Please choose the correct answer. Response: Neighbor Where-used list Properties Tables used .
Where can you create a filter expression? Please choose the correct answer. Response: In an aggregation node In a projection node In a data foundation node In the semantics node.
What node is used to link dimension views to a data foundation (fact tables)? Please choose the correct answer. Response: Join node Projection node Star join node Union node.
What is the role of core modelling in SAP HANA? There are 2 correct answers to this question. Response: To develop more secure user authentication To develop reusable data processing logic in the database To simplify applications To push data-intensive processing up to the application to obtain the best performance.
While converting currencies, which parameter is as important as source and target currencies? Please choose the correct answer. Response: Location Money Time Season.
What do you have to assign to users to allow single sign-on? Please choose the correct answer. Response: Kerberos authentication Application privileges TRUST ADMIN system privilege SQL analytic privileges .
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: Procedure Both Procedure and Function None of these Function.
Which recent technology innovations have triggered the opportunity to build a next generation data processing platform? There are 2 correct answers to this question. Response: Larger memory availability Multi-core processing Faster disk access Secure user authorization.
Which statements describe the mass copy feature in SAP HANA? There are 2 correct answers to this question. Response: It is used to transport data tables. It can be used to fix models when schemas have different names. It can be used to create a sandbox (playpen) environment. It is used to import an application from an SAP partner.
Which are features of a calculated column? There are 2 correct answers to this question. Response: Its calculations are persisted It is created in the semantics node It is a column in the result set It is created in the output area.
Why would you recommend SAP Replication Server? Please choose the correct answer. Response: If the source data is in a virtual table. If the data contains some rubbish information in several places. If the data is financial ticker tape data. If database administrators do not want triggers in their database.
What are the features of dynamic analytic privileges? There are 2 correct answers to this question. Response: Filter the condition based on a variable entered by the user when they query the view Filter the data based on a variable entered by the user when they query the view Change the filter condition in the underlying tables and views Reuse the same analytic privilege for several users who need to access different data.
The entity is the core artifact for persistence-model definition using the CDS syntax. You create a database entity as a design-time file in the SAP HANA repository. Which are the following prerequisites to create an entity in CDS (core data services)? There are 2 correct answers to this question Response: You must have access to an SAP HANA system You must have deployed to schema for the CDS catalog objects You must have already created a development workspace and a project. You must have access to schema for the CDS catalog objects.
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 SYSTEM user The user calling the function The owner of the function The _SYS_REPO user.
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. Response: An analytic privilege on the both calculation views An analytic privilege on the INDIA calculation view An object privilege on the WORLD calculation view An analytic privilege on the WORLD calculation view.
Where do you graphically create a design-time role in SAP HANA? Please choose the correct answer. Response: In the Security area of the SAP HANA web-based development workbench In the Roles area under Security in SAP HANA studio In the Editor area of the SAP HANA web-based development workbench In the Repository area in the development perspective in SAP HANA studio.
15 Question: Identify the principles that you need to follow during modelling. There are 2 correct answers to this question. Response: You should push data processing to the client as much as possible. You should reduce data transfer between the views by applying filters as low down as possible. You should create joins on key columns. You should perform calculations before aggregation.
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 mapping property The label column property The name property The label property.
Where will you find the Data Distribution Optimizer? Please choose the correct answer. Response: SAP HANA Data Warehousing foundation SAP S4/HANA Dictionary SAP HANA Studio SAP BW/4HANA.
Which programming language do you use for streaming projects? Please choose the correct answer. Response: CCL SQLScript JavaScript SQL.
Where in SAP HANA studio can you unload a table’s data from memory? Please choose the correct answer. Response: The data preview of the table The list of export destinations The table definition The context menu of the table.
20 Question: When creating a system connection in SAP HANA Studio, which of these is essential information? There are 3 correct answers to this question. Response: URL A valid user and password Instance Host.
What type of node is recommended to combine two data sources that have a similar set of dimensions? Please choose the correct answer. Response: Star join Join Union Inner join .
You are writing SQLScript code for handling sensitive data. What statement is prone to the SQL injection? Please choose the correct answer. Response: EXEC GRANT INSERT INTO CREATE TYPE.
A referential join gives the same results as which other join type? Please choose the correct answer. Response: Inner join Star join Spatial join Left outer join.
What is the function of the Aggregation node in a graphical calculation view? Please choose the correct answer. Response: Map the sources to the target. Combine the result sets. Combine the source target with result sets. Control the aggregation.
What do you have to do to set up SAP HANA Live in a side-car scenario? There are 2 correct answers to this question. Response: Replicate source tables Assign _SYS_BI_CP_ALL to reporting users Configure schema mapping Install the Application Function Library.
Which data provisioning tools can use SAP HANA adapters? There are 2 correct answers to this question. Response: SRS SDA SDI SDS.
What is used in SQL to indicate that there is no value? Please choose the correct answer. Response: Zero Spaces NULL Empty quotes.
What are the basic spatial shapes you can store in SAP HANA Spatial? There are 3 correct answers to this question. Response: Polygons Lines Graphs Points.
What is an example of a use of Text Analysis? Please choose the correct answer. Response: Cluster documents that discuss similar topics. Developing a user input field where misspellings are tolerated. Extraction of key facts from entire database transactions Extraction of key facts from a business article. .
What do you use in a SQL query to sort fuzzy text search results by relevance? Please choose the correct answer. Response: SCORE() RANK() SORT BY TOP.
Which of the following are results of deploying SAP HANA as a distributed (scale-out) solution? There are 3 correct answers to this question. Response: High availability Backups Partitioning Disaster recovery Failover.
Which of the following are valid types of privileges in SAP HANA? There are 3 correct answers to this question. Response: Application privileges Attribute privileges Data privileges Package privileges System privileges.
In SAP HANA Text Analysis, why would you use the ‘Voice of Customer’ dictionary? Please choose the correct answer. Response: To identify close matches in words and expressions, to catch misspellings To extract the sentiment from customer feedback on social media To identify the problem which customers are facing To extract common entities such as company, country, currencies, and so on, found in documents.
For what tasks would you use the Where-Used feature in SAP HANA? Please choose the correct answer. Response: To find all places where translations exist To find all places a transport is imported To find all places a user updated information models To find all places an information model is used.
What are the values for X, Y, and Z?Please choose the correct answer. Response: X = Customer 2, Y = 400, Z = 800. X = Customer 1, Y = 400, Z = 400. X = Customer 1, Y = 800, Z = 800. X = Customer 2, Y = 200, Z = 400.
What type of load does SAP HANA perform when starting up? Please choose the correct answer. Response: Fast load Complete load Log load Lazy load.
What issue do you have to address after you have migrated your old views to calculation views? Please choose the correct answer. Response: Check the analytic privileges for star join situations Manually migrate the base view for derived views Change filters on table columns to filter expressions Unhide the hidden fields in the semantics node.
What can you use to limit the number of records produced by a calculation view? There are 3 correct answers to this question. Response: Filter expressions Restricted columns Domain fix values SAP client restrictions Generated columns.
With which of the following do you build the vocabulary of a decision table? Please choose the correct answer. Response: Conditions Measures Actions Attributes.
What is scale-out? There are 2 correct answers to this question. Response: Use of standby servers in the event of hardware failure. Use of commodity servers that are used in high volume steaming applications. Use of multiple servers to spread processing and improve performance. Use of remote servers to store archived data that is rarely used.
Report abuse Consent Terms of use