You want to join 2 tables in CV . When would you non-equi join? Join is part of Star join Join requires a <(Less than) Operator Cardinality is impossible to determine Cardinality is 1: n. In SAP Web IDE for SAP HANA , what can a flow graph generate in a predictive analysis scenario? Function Container Task Procedure. Which of the following are no longer required in the architecture of SAP S/4 HANA Synonyms Aggregates Column tables Indexes. In which of the following scenarios would you benefit from enabling table partitioning in SAP HANA Your stacked model consists of multiple CV. your column table`s delta store is frequent larger than its main store You have a large column store table that is consumed in a view with a variable on country column you have a large row store table that is consumed a view with a variable on country column. In your rank mode, why do you set the dynamic partition element flag To define the ranking threshold value based on input parameters To generate the ranking partition based on columns select in the query To determine the partitioning logic using an SQL expression To define time dependency on a partition. What can you identify using Performance Analysis Mode? Information about join cardinality Longest running query step sage statistics of the calculation view Joins that are based on calculated columns. Which of the following views can be extended by using the SAP HANA Live extension assistant custom view private view reuse view query view. What is the persistent storage layer used for? To enable data to be recovered if hardware fails TO improve the parallel processing of queries To store the data primarily used for transaction processing To unload the least-used data when the memory is full. You want to create a star schema using a calculation view. The measures are based on columns from two transaction tables Dimension calculation view provide the attributes. What is the correct approach? Combine the transaction tables using a star join node in a calculation view of type cube with star join. Use an aggregation node to join the dimensions to the fact table Combine the transaction tables using a star join node in a calculation view of type cube with star join. Use a join node to join the dimensions to the fact table. Combine the transaction tables using a join node in a calculation view of type cube with star join. Use a star join node to join the dimensions to the fact table. Combine the transaction tables using an aggregation node in a calculation view of type cube with star join. Use a star join node to join the dimensions to the fact table. In text processing, where do you use the Term Document Matrix? Text mining Fact and entity extraction Linguistic extraction Fuzzy text search. You are a data analysis working with medical records that contain confidential patient information. Why do you use the anonymization node in a calculation view? To restrict data access for specific users or roles To provide partial value such as #3434 3#34## To add noise to the data to hide the actual values To hide individual patients in groups of similar records. In SAP HANA Series Data, which of the following methods do you use to convert finer interval readings to a coarser interval? Please choose the correct answer. Horizontal disaggregation Vertical aggregation Vertical disaggregation Horizontal aggregation. What conditions must be met before you can implement time dependency on a hierarchy in a calculation view? The hierarchy must be a parent-child hierarchy The hierarchy must be a level hierarchy The key date parameter must be derived from an input parameter The hierarchy must be enabled for SQL access. What can you extract using the standard text analysis configuration: Voice of the Customer? Sentiments Request Recommendation Suggestions. You set up currency conversion in a calculation view. When your currency conversion failed, what could you choose to populate the target column? The source amount A default value Null <EMPTY>. What conditions must be met to ensure the Dynamic Join feature works properly? 2 correct At least one joined column must be specified in the query Multiple columns must be defined in the join Cardinality must be set The join must be defined on key columns. Before deploying your calculation views to a PROD environment, which sequence of steps is required? Please choose the correct answer Build the HDB module -> Build the project Activate the project -> Build the HDB module Build the project -> Build the HDB module Export the HDB module -> Export the project. Why do you use the query debug mode in a calculation view? To check if SAP HANA can parallelize the entire query To measure the overall run-time of the query To observe the generated SQL for each node To check which database engines will be involved by each node. In a calculation view, where can you use SQL? 3 correct Calculated column expression Filter expression Input parameter Aggregation node Union pruning condition. Using a calculation view containing the projections shown in the graphic, how would you identify which companies sold products in January 2018 AND February 2018? Please choose the correct answer. Use an intersect node Use a full outer join Use an left outer join Use a union node. Why would you use the XS Advanced Migration Assistant? 2 correct To convert attribute views to CDS views To convert Studio-developed objects for use with Web IDE for SAP HANA To move HDI-developed calculation views to repository packages To convert analytic views to calculation views. When can you expose a hierarchy that is defined in a calculation view for access with SQL? When the hierarchy is a local hierarchy When the hierarchy is a shared hierarchy When the hierarchy is defined in a calculation view of type CUBE When the hierarchy is defined in a calculation view of type DEFAULT. An SAP HANA Live model is displayed as an invalid view in the list of models in the SAP HANA Live browser. What could be the reason? 2 correctas The model has been deleted The model is missing an underlying table The model´s underlying table is not fully replicated The model is missing a dependent view. Which are views of the SAP supplied virtual data model of Embedded Analytics? There are 2 correct answers to this question. Composite Calculation Basic Attribute. On a weekly basis, you need to extract and transform data from multiple sources such as SAP ERP Microsoft Excel and Apache Hadoop and load the data into SAP HANA. Which tools can you use? There are 2 correct answers to this question SAP HANA smart data access SAP HANA smart data integration SAP Data Services SAP Landscape Transformation Replication Server. Using the table in the diagram, you need to create a cube calculation view. What is the simplest approach to create the output form the screenshot? Implement a union node and map each year as a separate column Create a restricted column for each year Create a filter expression that uses an OR operator. How can you optimize performance when writing SQL for use with calculation views? 2 correctas - Use calculation engine (CE) functions instead of plain SQL Increase paralization by using variables to break up statements Control the flow logic using IF-THEN-ELSE conditions Use declarative language instead of cursors. Which of the following data sources can you include in a graphical calculation view? 2 correctas SQL view Table function Procedures Scalar function. Why does SAP issue warnings about the use of imperative of procedural SQL Script statements? They are deprecated NOT all reporting tools can consume the results They introduce security risks due to SQL injection They can ham SQL optimization. You created a table function to sum the total weekly working hours for each employee and update the personnel table. You CANNOT activate the table function. What could be the problem? - You did NOT define a valid table type You do NOT have write permissions to the personnel table You CANNOT update records using a table function You did NOT create synonyms for the table. Why do you use parameter mapping in a calculation view? 2 correctas To push down filters to the lowest level calculation views To pass a value from a variable to an input parameter To convert the data types of input parameters To pass variable values to external value help views. Which types of data are used to represent spatial information? 2 correct Rasted data Column data Vector data Graph data. When modeling in the Web IDE for SAP HANA, which object do you build provide access to tables in external schemas? Container Analytic privileges Synonym Role. What can you use SAP HANA smart data access for? Note: these are 2 correct answers to this question. To load and harmonize data from disparate sources. To push down queries to data sources. To expose data from remote tables To replicate remote data sources. When using the CONTAINS predicate, what are the restrictions you must you keep in mind? 2 correctas. If several tables are joined, all columns mentioned in the CONTAINS predicate must come from only of the tables Wild cards * and ? are supported for text columns but not string columns The NOT (-) operator can only be specified directly after the OR operator. Non-physical columns, such as calculated columns, are not search relevant. You have two tables with two columns CUSTOMER_NAME and COUNTRY_NAME, one with Italian customers and other with French customers. What type of calculation view should you create to combine customers? Dimension type with join node Cube with join node Cube with union node Dimension with union node. ou want to map an input parameter of the calculation view A to the input parameter of calculation view B using the parameter mapping feature in the calculation view editor. However the input parameter of the calculation view B is not proposed to you as a source parameter. What might be the reason for this? Your source calculation view is of the type DEFAULT You did not push the Auto Map button You already mapped the input parameters in another calculation view You selected the wrong parameter mapping TYPE. In an XSA / HDI environment, which of the following is used for source version control of calculation views? SAP HANA studio Open-source Git MS (Change Management System) CTS (Change Transport System). You use the Show Lineage feature within a Calculation View
What information does this feature provide.
The Origin of column. The list of data sources for each node THe overview of all data sources An overview of information model that consumed in the view. What must you consider to create PAL functions 1. Function 2. Synonym 3. Wrapper Container. What can you discover using data Lineage. Data changes since last refresh Access Statistics Underlying calculation Frequency of load. 10. You create a hierarchy in a dimension calculation view. You then consume this dimension cal. View.
How do you allow SQL access to the hierarchy.
1. Enable SQL access in view proprieties of the dimension cal. View. Obtain generated node names in local hierarchies. 2. Enable SQL access in view proprieties of the cube cal. View. Obtain generated node names in shared hierarchies. 3. Enable SQL access in view proprieties of the cube cal. View. Obtain generated node names in local hierarchies. 4. Enable SQL access in view proprieties of the dimension cal. View. Obtain generated node names in shared hierarchies. Which of the following column types can you assign to rank column. 2 correct answers. 1. Calculated column 2. Attribute 2. Measure 4. Restricted Column. Which of the following allows data replications. SAP HANA SDQ SAP HANA SDI SAP HANA SDA SAP HANA Streaming Analytics. . A column in your table will be used for a text search, why do you define a column as a text type instead of string type To allow processing of multiple lang. To enable the full set up SQL Operations To enable lower memory consumption To enable linguistic analysis. What is the purpose of active/active-read enabled mode. To utilize dyn. Tiring for right intensive tasks . To utilize dyn. Tiring for read intensive tasks. . To use for not continuous back up , to assist in read intensive in task. . To use you're not continuous back up, to assist in write intensive task . What could you do to improve the performance of join in cube cal. Views. 2 correct ans Always flag joins as dyn. Use left outer joins instead of right otter joins. Use temporal joins instead of full outer joins. Specify the cardinality of the join. . How do you define a dynamic SQL analytic privilege Create a procedure that returns a table type parameter. Create a procedure that returns on SQL expression similar to Where clause in a select statement. Include a table function in the sQL expression of the analytic privilege Create a scalar function that returns a list of the allowed values for each secured . You joined two tables using a referential join and set the cardinality to 1..n. what type of join is execute at run time, If your query does not request columns from the right table. Inner join Right outer join Full outer join Left outer join. Why might you use SAP HANA Graph with text analysis? To uncover the dependencies between parts of sèech To highlight similarities between documents using hierarchies To illustrate multi-point relationships between text entities To provide a visual method to build a custom text analysis. You join two tables using a referential join and set the cardinality to 1..n What type of join is executed at runtime if your query does NOT request columns from the right table? Left outer join Right outer join Full outer join Inner join. In SAP HANA Series Data processing, what is the definition of a profile? The granularity of time intervals, such as day, hour, or minute he values that you are storing, such as temperature, energy consumption, or speed The object you collect data agained, such as house, building, or town A variant of the data set, such as actual, forecast, or long-term plan. When modeling a decision tree, what are the stages of the learning phase? 3 correctas Connecting Training Validation Testing Rejecting. In a calculation view, what is the purpose of a variable? To pass values between procedures and calculation views To provide a run-time attribute filter based on a user input To break up complex SQL into smaller steps To capture the interim result of a calculation in an expression. A partitioned column table is prevent only in the persistent layer of an SAP HANA system. Which columns and partitions are loaded into memory when the table is accessed by an application? ONLY the required columns and the required partitions ONLY the required partitions and all the columns All the partitions but ONLY the required columns. What are the components of a graph workspace? 2 correctas Space Edge Vertex Partition. You want to join 2 tables in a calculation view When would you use non-equi join? The join is part of start join The cardinality is 1:n The cardinality is impossible to determine The join requires a < (less than) operator. What does SQL script provide to extend standard SQL? 2 correctas Feature to encourage processing in the database Integrated source code version management Additional data types for the definition of text and spatial data Support for ABAP Syntax. Your calculation view presents employee names which must only be seen by managers. All other employees should see the employee name in the format M### G### Which steps are required to implement this? 2 correctas Create an SQL expression to define the concealing logic for the column Set the column to ‘hidden’ in the calculation view Assign the UNMASK privilege to the managers for the calculation view Include an anonymization node in the calculation view. In SAP Web IDE for SAP HANA, what can a flow graph generate in a predictive analysis scenario? Container Function Procedure Task. You are building a cube calculation view with an aggregation node that calculates total sales, based on the data shown in the graphic. The price may vary based on SHIRT_ID and PROMO_LEVEL only. The calculation is Total Sales = PRICE * QUANTITY. How do you ensure accurate results, regardless of the column in the query output? Set the Keep Flag property for both SHIRT_ID and PROMO_LEVEL Set the Transparent Filter property for STATE Set the Dynamic Partition flag for SHIRT_ID and PROMO_LEVEL Set STATE as an aggregated column. Which of the following must you consider when you define namespaces in an SAP HANA database (HDB) module? There are 3 correct answers to this question. The namespace defined in a design-time object must match the namespace properties of the folder in which it is located Modeling content should be created before the namespace rules have been defined Synonyms can have different namespaces A namespace is a mandatory component of the object identifier Two different objects can have the same name if they are assigned to different namespaces. In SAP Web IDE, you rename a dimension calculation view that is used by a cube calculation view. Afterwards, you perform the following build operations. - Build the dimension calculation view as a single object - Build the entire SAP HANA database module. What is the outcome of the build operations? The first build is successful The second build is successful The first build is successful. The second build fails The first build fails The second build fails The first build fails The second build is successful. What do SAP S/4HANA embedded analytics and SAP HANA live have in common? Note: these are 3 correct answers to this question They are built using ABAP CDS They expose operational data from SAP services Their data access is controlled using analytic privileges They are built and maintained by SAP They can be extended by customers. Which type of join supports a temporal condition in a calculation view? Referential join Text join Left outer join Inner join. A calculation view includes a rank node that users the source data and settings shown in the graphic. Your query requests all columns of the rank node. How many rows are in the output of your query? 8 rows 6 rows 2 rows 9 rows. What can you determine using the hierarchy function in a calculation view? 3 correctas Source attributes of a composite hierarchy node Number of siblings for a hierarchy node Distance between root and each hierarchy node Hierarchy nodes that have no parent Time interval of hierarchy nodes. Your calculation view includes the followings: SALES_ORDER_ID and ITEM as attributes, and QUANTITY and PRICE as measures. You create a calculated column, ITEM_TOTAL, with the formula QUANTITY * PRICE. In which node do you define the calculation to display the correct aggregated result? Union Aggregation Projection Join. You created a table using the SQL console inside the HANA Deployment Infrastructure (HDI) container of your project. You export your project and re-import it whit a different project name to the same database What do you observe in the SAP HANA database module? The build is successful and the table and its data are present The build is successful but the table is NOT present The build fails and the table is NOT present. You have a cube calculation view that consumes a dimension view. You suspect some dimension columns have been renamed in the cube calculation view Which function of SAP Web IDE for SAP HANA do you use to check where the output columns originate from? Where used Show lineage Impact analysis Database explorer. How can you define a variable that presents its value help hierarchically? 2 correctas Create a parent-child hierarchy and assign it to the variable Ensure the variables reference column is the parent attribute of the hierarch Create a level hierarchy and assign it to the variable Ensure the variables reference column is the leaf level of the hierarchy Create a parent-child hierarchy and assign it to the variable Ensure the variables reference column is the child attribute of the hierarchy Create a level hierarchy and assign it to the variable Ensure the variables references column is the top level of the hierarchy. In your calculation view, you need to define a custom data source using SQL Script. In which object do you write your SQL Script?In your calculation view, you need to define a custom data source using SQL Script. In which object do you write your SQL Script? - CDS view Table function Procedure Scalar function. Why do you build a calculation view of type DEFAULT? To provide a leaner model when only attributes are required To support optimized multidimensional reporting To ensure all reporting tools can consume the calculation view To provide a data source that is only consumed by other calculation views. You have assigned analytic privileges to users as shown in the diagram. What data can be viewed by the users? There are 2 correct answers to this question. - User 2 can view United States for 2017 User 1 can view any year for United States User 1 can view Canada for 2018 User 2 can view any year for United States. Why might you use the keep flag in an aggregation node? To ensure that the aggregation behavior delined in the aggregation node for a measure CANNOT be overridden by a query To include columns that are NOT requested by a query but are essential for the correct result To retain the results of the aggregation node for reuse in a drill-down based on a hierarchy. Which of the following techniques can you use to improve the performance of calculation views? Note: these are 2 correct answers to this question. Partition large tables Implement union pruning Avoid aggregating data early in the data flow Minimize layering of calculation view. You want to map an input parameter of the calculation view A to the input parameter of calculation view B using the parameter mapping feature in the calculation view editor. However the input parameter of the calculation view B is not proposed to you as a source parameter. What might be the reason for this? Your source calculation view is of the type DEFAULT You did not push the Auto Map button You already mapped the input parameters in another calculation view You selected the wrong parameter mapping TYPE. What does a graph neighborhood reveal? Please choose the correct answer. Vertices that are closely connected Shortest path between vertices Vertices that contain the same attributes Strongly connected Vertices. In SAP Web IDE for SAP HANA, which of the following tasks do you need to complete before you can build the SAP HANA database (HDB) module successfully? 2 correctas - Ensure that you have only one HDB module in your project Assign the project to a space to which you have developer authorizations Explicitly build the HDB module instead of the project Ensure that the name of your HDB module is included in the corresponding schema name. You have a calculation view which includes nodes as shown in the graphic. You decide to select the “ignore multiple output for filters” checkbox on projection node. What might the effects of this be? 2 correctas: Increased performance A change to the data that is returned by the view The view will return the profit calculation for only the US Decreased performance. What restrictions apply to a Graph mode that you include in a calculation view? It must be the first mode in the data flow Its data source must be provided by a projection mode It must be the final mode in the data flow It cannot be included in a calculation view of type dimension. Why do you create a multistore table? To have the option to partition table across different storage tiers To improve read performance when accessed by simultaneous application To have a table than combines the characteristics of row and column stores - To evently distribute the data across all available server nodes. why do you create calculation views of data category DIMENSION with type TIME? To provide the time intervals required by time-dependent parent-child hierarchies To apply automatic adjustments to unequal time snapshots on series data To enable time-dependent master data attributes to be consumed in a star schema To provide additional time-related navigation possibilities. Why do you use SAP HANA Graph? To develop a dashboard to present KPIs To access advanced chart types from calculation views To push down graphic processing to the database To model highly networked entities. Why do you use a hierarchy function node in a calculation view - To convert parent-child hierarchies to level hierarchies To generate additional meta data that can be used for analysis of a hierarchy structure To enable hierarchical navigation in reporting tools To display value help using hierarchies. In a calculation view of type cube with star join, you want to join three dimensions to the facts. Two of the dimensions use full outer joins and one dimension uses a left outer join you did not set cardinality of the data sources. Why will this NOT work? Full outer joins CANNOT be mixed on the same star join node with other join types Full outer joins require to be set Full outer joins restricted to one dimension in a star join node. Full outer joins are NOT available in the star join node. How could you improve the performance of joins in cube calculation views? Note: these are 2 correct answers to this question. - Avoid the use of referential joins. - Reduce the number of columns used in the join. Specify the cardinally of the join Join on calculated columns Avoid the use of referential joins. When you create a full text index, why do you specify FAST_PREPROCESS OFF? To generate text analysis results in multiple languages To avoid the generation of the term document matrix To enable a full linguistic search To prevent the creation of a fluzzy search index. Refering to the diagram, which privileges would a user require to view United States data when querying the CUBE Calculation View? A SELECT privilege on the CUBE and an analytic Privilege (Country = United States) on the DIMENSION Calculation View Analytic Privileges and SELECT Privileges on the CUBE Calculation View SELECT Privileges and Analytics Privileges on both views A SELECT Privilege and an Analytic Privileges. You are building a new calculation view, A, which includes a projection node that refers to another calculation view, B. Why would you use the Extract Semantics feature? To improve the performance of calculation view A by only referencing the semantics of calculation view B and not duplicating it. To automatically map the input parameters from calculation view B to an input parameter of calculation view A To apply the semantics of calculation view B to the semantics of calculation view A To set the semantics of calculation view A to the default values. You require faster performance for a frequently queried calculation view. You have just enabled the Static Results Cache for this calculation view with a cache period 120 minutes. What are the effects of this action? 3 correctas - Additional memory will be consumed by the calculation view CPU usage for the calculation view will be reduced Updating of the underlying tables in the calculation view will be delayed for 120 minutes Users may no longer see the most current data in the output Variables can no longer be used by this calculation view. In text processing, where do you use the Term Document Matrix? Text mining Fact and entity extraction Linguistic extraction Fuzzy text search. You import a project that includes an SAP HANA database (HDB) module to your workspace. You need to create a calculation view that uses data… Which of the following items must you build? 2 correct answers to this question. Authorization HDB module Synonym Project. In an XSA / HDI environment, where do you find run-time object? Database user schema Repository package Container schema _SYS_BIC schema. You are assigned a role that contains two SQL analytic privilege. --> AP_COUNTRY_US restricts the country attribute to US, --> AP_YEAR_2015 restricts the year attributes to 2015. both analytic privilege are assigned to a calculation view that is set to check the SQL analytic privilege. Which data is displayed when you query the cal. View using SAP analytics. The rows for which country = US and year = 2015 The rows for which country = US or Year = 2015 None of the rows of the cal. View All the rows of the cal. View. . 55. What are the elements of custom text analysis 1. Term document matrix 2. Configuration 3. Python script 4. Dictionary 5. Rule set. 49. In which parts of a SELECT statement can you include ST_WITHIN spatial predicate. 2 correct ans. 1. Join condition 2. Group by clause 3. Where clause 4. Having clause . 48. You cannot enable a hierarchy for time dependency, what could be the reason for this 1. You created a parent child hierarchy 2. You defined the temporal condition on an integer data type column 3. You created a level hierarchy 4. You did not include a hierarchy column table. 46. To which category of analysis functions K-Means belong. 1. Clustering 2. Association 3. Regression 4. Classification . 45. Why do you use the performance analysis mode to analyze the Join node. 2 correct ans. 1. To display the pruning rules 2. To identify the execution engines 3. To find the number of records in each join pair 4. To confirm the cardinality setting. . 44. You created a table using the SQL console inside the Hana deployment infrastructure HDB container of your project. … 1. You observe in the SAP Hana database module. 2. Child fails the table is not present 3. Child is success but table is not present 4. Child is successful and the table and its data present. 43. Which of the following are tasks that you must perform, before you can build predictive analytics. 3 correct answers. 1. Create a DB connection. 2. Assign authorisation. 3. Define a namespace 4. Install AFL 5. Start the script server . 42. In calculation view which object type do you assign to a projection node to consume a…. 1. Scalar functions 2. Synonym 3. Input parameter 4. Table function. 39. You are working on dynamic currency conversion, you pass the target currency at run time using input parameter. What data type does SAP recommend for the input parameter to ensure the consistency with TCUR* table data types. 1. NVARCHAR(3) 2. LCHAR(5) 3. CHAR(5) 4. VARCHAR(5). 38. Which of the following SAP Hana modeling principle does sAP recommend. 3 correct ans. 1. Join tables on key or indexed columns 2. Define filters on calculated columns 3. Implement input parameter to push down filter. 4. Reduce data transfer between views. 5. Perform the aggregation after calculation. . 34. In SAP WEB IDE for SAP Hana you created an SQL analytic privilege that secures your cal. View. What could be reason. 1. The data category property of the cal. View was not set correctly. 2. You did not assign the analytic privilege to a role. 3. Calculation views cannot be assigned to analytic privileges. 4. The apply privileges property of the cal. View was not defined correctly. . 24. Which of the following approaches can be used to implement union pruning. 2 correct ans. 1. Define union pruning condition in pruning configuration table. 2. Define the cardinality between the data sources. (this should not be the answer) 3. Define the constant value for each data source in the union node. 4. Define a restricted column and include it in both data sources of a union. . 23. When using the contains predicate which of the following must… 3 correct ans 1. The NOT(.)Operate can only be specified directly after the OR operate 2. Wildcard!? Are supported for text columns but not string columns 3. Nonphysical columns such as calculated Column search 4. If you specify multiple contains predicates in the where clause of the select statement… 5. Several tables are joined are column mentioned in the contains predicate must have …. 22. One SQL analytic privilege authorize you to view data for Europe and USA in the sales cal. View … view the income view uses the sales view as input both the calculation view and SQL .. Privileges. What data can you visualize when consuming income cal. View. 1. Data from Europe Asia and USA 2. Data from Europe and US 3. Data from US 4. Data from Asia and US. 21. An SAP Hana live model is displayed as in invalid view in the model in the SAP Hana live processor. What could be the reason. 2 correct ans. 1. The models underlying table is not fully replicated. 2. The model has been deleted. 3. The model Is missing an underlying table. 4. The model Is missing dependent view. . 19. What is the propose of active/active-read enabled mode. 1. To utilize dyn. Tiring for right intensive tasks 2. To utilize dyn. Tiring for read intensive tasks. 3. To use for not continuous back up , to assist in read intensive in task. 4. To use you're not continuous back up, to assist in write intensive task . 14. In a calcu. View what can you only do after you enable hierarchies for SQL access, 2 correct answers. 1. Consume the hier. In BI tools. 2. Use the hier. Mode in a group by clause. 3. Sort the members of hier. 4. Filter the results, set based on hier. Node. .