|Which BI (Business Intelligence) clients can connect directly to SAP HANA? choose 6 Design Studio Lumina/ Fiori Analysis for Office Web Intelligence Crystal Reports Predictive Analytics Analytic Privilege HADOOP.
Which are valid client connection technologies used to consume Calculation Views? choose 3 ODBC MDX BICS ODBO SQL.
A connection to Analysis Edition for Office requires a BusinessObjects Connection to be defined? True False.
What is the XS engine? A server used to offload heavy workloads A backup service An application server that is fully integrated with the HANA database.
What is the key role of the built in tool Smart Data Access (SDA)? Provide virtual access to remote data Automate data loading based on user consumption history Provide dynamic security based on SQL privileges Provide real time data loading .
What is the value proposition of SDI/SDQ? Simplifies data acquisition with tools built into HANA Provides the most comprehensive list of transformation tools compared to any other ETL tool Enables the development of a logical data warehouse Ensure the most accurate cleansing for low quality data sources.
Which BW modeling object should I create to integrate a BW DataStore Object with a Calculation View? InfoCube CompositeProvider InfoSet TransientProvider.
What are valid flat file types that can be used in the HANA Studio import wizard? choose 2 XLS TXT CSV XML.
What is the key role of Data Services? choose 2 Data security Data streaming Data integration Data transformation.
What is HANA Vora? Data cleansing toolset Intelligent data profiling tool Data archiving management Toolset to support harmonized querying on Big Data and enterprise data .
I want to enable real-time replication from my SAP ERP source to HANA using the simplest implementation and well known SAP Netweaver technologies. Which do I use? SAP Landscape Replication Server (SLT) Data Services Smart Data Access (SDA) SAP Replication Server.
What is a Delta Merge operation? Isolate differences between old and new HANA tables so a delta update can be generated Merge privileges that are overlapping in order to simplify maintenance Combine data from row store tables with column store tables to produce a hybrid table Periodically combine new data with existing data in column tables .
Which is the SAP HANA server that handles database operations? Statistics Server Script Server Index Server Name Server.
When might I consider the use of a row store table? choose 3 To take advantage of parallel processing When no aggregation is required on my data When all columns in the table are required for processing When compression is needed to reduce the footprint of the table When I am sure there will be a high volume of inserts / updates to columns.
How does HANA ensure no data is lost during a memory outage? choose 2 By automatically saving data pages to data volumes By automatically saving data pages to log volumes By saving committed changes between savepoints to data volumes By saving committed changes between savepoints to log volumes.
In which component are tables organized? Package Schema Delivery Unit Folder.
Which are valid components of a graph model? choose 3 Workspace Index Vertex Edge Segment.
What do we build to define a Graph Model? Procedure Flowgraph Workspace Project.
What is SAP HANA Text Analysis? Fault tolerant searching Text mining toolset A language translation tool Extraction of entities in text .
What is a freestyle search? A search that allows the user to select the column at runtime A search that considers synonyms in a column A search across multiple columns A search in any language.
What must you create to build a predictive model? Calculation view Procedure Decision Flowgraph.
Which is the recommended modeling view type? Column Attribute Analytic Calculation.
What are valid geo spatial data types? choose 2 ST_POINT ST_SPACE ST_POLYGON ST_VERTICLE.
I have two tables that I want to use in a calculation. One table contains customer master data, and the other table, sales transactions. Which of these join types do I use to ensure all customers, regardless of whether they bought something or not, are reported? Left Outer Referential Text Inner.
How does a referential join behave when columns from both the tables that are joined are requested in a query? an inner join is made an outer join is made a star join is made the join is ignored.
When is a design time filter applied? Before a join is executed After a join is executed At the same time as the join is executed.
Which statement about unions are true? A graphical Calculation View is limited to two sources for a union node Source column names must be identical in a union All source columns must be mapped in a union A constant can be defined to provide a fixed value for one or more input columns of a union.
I am getting an error when I try to activate my Calculation View. What could be wrong? I did not include an attribute view in the star join I have unmapped columns in a union I have not defined at least one column as a measure I did not set the join cardinalities I am referencing tables from different schemas .
When would I use a derived view? When I need to use an attribute view more than once in an analytic view So changes I make to an attribute view are immediately reflected in models where the attribute view is consumed When I need to apply filters to attributes When I need to calculate extra columns.
What happens when you add the same table to a data foundation? An alias name is proposed automatically but you can rename it You receive an error to indicate that you have added the same table more than once You are prompted to choose an alias name One of the tables will be marked as hidden.
What are valid calculation view types? choose 3 Cube with star join Cube Dimension Temporal Dimension with star join.
I want to calculate a measure before aggregation. In which node of a calculation view can this be set? Semantic Aggregation Rank Projection.
Why would I use the Lineage tool in my Calculation View? to identify the dependent views to drill to the source data of the view to follow the path of any specific column inside a Calculation View to identify who has worked on the view and when it was activated.
When defining a restricted column, how are multiple values based on the same attribute treated? AND OR.
What information about my Calculation View can I discover using Performance Analysis Mode? choose 2 Compression % for column tables used in model Time taken to process each step during execution Number of rows in referenced tables Partition type of referenced tables.
What is the purpose of schema mapping? To allow tables from one schema to be visible in another schema To automatically adjust models during import to use the final production schema and not the authoring schema To create a table in one schema that is derived from a table in another schema To ensure the correct access sequence is applied when a table appears in multiple schemas.
Why would I export content using Developer Mode? To export application source code To export models and include all their historic log files To export both the design time and run time objects To export individual objects
When would I use mass copy? To copy information models while keeping the references between all the copied objects consistent To copy multiple models using wild cards in the selection criteria To improve the performance when copying many models by using parallelization The allow the copy to be run in the background.
In a level hierarchy, how are levels defined? By choosing a parent node followed by a sequence of child nodes to create a drill down order By defining an explicit sort sequence of specific values chosen from a single column By specifying the columns in a hierarchy table that should be available for drill down By selecting at least two columns that are available in the semantic node and placing them in the desired drill down sequence.
What is a parent child hierarchy? A continual hierarchy formed by linking multiple hierarchies A hierarchy formed by selecting two columns and assigning them to the role of parent or child A hierarchy that is formed by selecting specific the values of a column and assigning the values to the role of parent or child The assignment of hierarchy nodes to the roles of parent or child.
Which are valid methods for reducing the data set in a Calculation View? choose 4 Create a design time filter on a table column Include an aggregation node and define at least one measure for aggregation Mark columns as hidden in the semantic layer Implement domain fixed values Define a variable.
Which statements are true regarding Input Parameters? choose 3 They can appear anywhere in the flow of a Calculation View Technically they result in a WHERE clause in the generated SQL Value help lists can be generated from external views They can derive their values from a stored procedure They are always bound to a single attribute of a calculation view in order to apply a filter to it .
Which statements are true regarding variables? choose 3 A variable is used for filtering the data set by attributes A variable value cannot be empty A variable can be assigned to multiple attributes for filtering Variables can be used in calculated column expression A variable generates an WHERE clause in SQL.
When would I use a decision table? To define access priority when table locking occurs To provide hints to the SQL execution engine to ensure best performance To define the flow logic of a Calculation View To define reusable business rules .
What is the purpose of EXPLAIN PLAN tool? To suggest optimal design changes to your model To highlight data quality issues that can affect performance To highlight which execution engines are called To generate documentation from the calculation view settings .
Which of these are recommended to ensure good performance? choose 2 Join on key or indexed columns Projection nodes should always be placed above aggregation nodes in a graphical calculation view Filter data as early as possible in the data flow Avoid calculations after aggregations.
You have set the flag in your view to execute only in the SQL engine. What design rules must you follow in order to achieve the best performance? choose 2 Avoid use of input parameters, always use variables Do not include scripted calculation views in your model Do not include analytic views in your model You should also set the SQL flag in the underlying views.
Which are good practices when writing SQL? choose 2 Use variables to break up complex statements Avoid Grouping Sets Use IF-THEN-ELSE statements to help control the data flow Avoid mixing CE plan operators and SQL relational operators .
What is the purpose of the PLAN VISUALIZE tool? choose 2 To suggest adjustments to your SQL to improve performance To support the high level design of the data model To produce a data flow that displays estimated run times for all steps To produce a data flow that displays actual run time for all steps.
What are valid types of privileges? choose 4 Package System Analytic Object Reporting Procedure.
Which statements are true regarding SAP HANA Live Analysis Authorization Assistant? choose 2 HANA analytic privileges are generated automatically based on ABAP authorizations ABAP authorizations are generated automatically based on HANA analytic privileges The tool can be used on customer created calculation views to generate privileges The tool assigns the generated HANA privileges to the HANA roles .
In order to access data in a view that consumes other views, I only need analytic privileges on the top level view? true false.
What is the purpose of _SYS_BI_CP_ALL ? Provide access to all Packages Provide access to all system admin functions Provide access to all data in all calculation views Provide access to all tables.
Which approach does SAP recommend to build analytic privileges? SQL XML DYNAMIC ODBO.
Why do I need to grant SELECT on my new schema to user _SYS_REPO? To be able to copy a model that I did not create To ensure views that reference tables in the new schema can be consumed in other views To be able to activate models that reference tables in your new schema In order for the data preview in HANA Studio feature to access data in tables of that schema .
What types of temporary tables are available? choose 2 GLOBAL LOCAL POINT GEO.
Since SPS11, what are Scripted Calculation views being replaced with? User defined table functions Analytic privileges SQL scripted views Analytic views.
Which are valid SQLScript table types that can be specified in a create <…> table statement? choose 3 Row Compressed Column Global Temporary Vertex.
Which are valid statements regarding procedures? choose 2 Procedures can have multiple input parameters A read-only procedure can call a read-write procedure You can include DDL statements in a read-only procedure Procedure can have multiple output parameters.
Where is SQL used in graphical Calculation Views? choose 3 Calculated Column Restricted Column Analytic Privileges Semantic Layer Restricted Row.
Which are valid statements regarding Functions? choose 3 Functions can have multiple input parameters A function can call another function You can include DDL statements in a Function Functions can have multiple tabular outputs structures Functions can only have one input parameter.
Calculation Engine (CE) functions should be used in preference to plain SQL to ensure the best performance? true false.
What is SAP HANA Live? Components to allow the loading of HANA tables in real-time The name of the web channel where you find the latest HANA news Models that contain all necessary joins, filters, aggregations and transformations to turn raw Business Suite data in consumable views Real-time adaptors to connect to non-SAP sources for virtual access.
From the top, what is the correct sequence for the layers of SAP HANA Live VDM? Private view > Reuse view > Customer extensions > Tables Customer extensions > Private view > Reuse view > Tables Reuse view > Query View > Private view Tables Query View > Reuse view > Private view > Tables
After installation, I cannot activate HANA Live models. What could be wrong? choose 2 I did not set the sequence for model activation before import There are missing tables in the schemas to which the models refer I did not create Analytic Privileges for the models I did not configure the SLT replication to ensure the tables are updated in real-time.
What can I do with SAP HANA Live Browser? choose 2 Identify which reports are consuming each model View the dependencies between views Preview the data output from any view Launch Web Intelligence using a selected view View access rights to views for each user .
Which are true statements regarding the SAP HANA Live Extension Assistant? choose 2 The tool can be used to extend customer created views You cannot extend views that have aggregation nodes anywhere other than the top node You can use the tool to extend a generated extension view You cannot extend a view that uses a union.
If I have heavy data transformation requirements and also need to integrate SAP and non SAP systems during data loading, which TWO tools should I consider? choose 2 Data Services SDQ SDI SLT.
If I have an SAP source and I require real time replication to SAP HANA what tools should I consider? choose 2 SLT SDI SDQ Data Services.
I need to standardize my addresses and also identify the gender of my contacts based on their names, which two tools should I consider? choose 2 SDQ Data Services SDI SLT.
My time recording machines collect data throughout the day in their on-board databases, but I only need them to send their data to SAP HANA every hour. What tool should I consider? Remote Data Sync SLT Data Services EIM.