What combination enabled real-time computing? In-memory technology with solid-state disks In-memory technology and multicore CPUs Multicore CPUs and solid-state disks Multicore CPUs with large level 1 caches. What are the advantages of columnar storage? (There are 2 correct answers.) Improved compression Improved data reading performance Improved data writing performance Improved performance when all fields are selected. What performance technique should you implement to improve join performance? 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. What performance techniques should you implement to improve join performance? (There are 3 correct answers.) 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. Use left outer joins instead of right outer joins. Always mark joins as dynamic to improve performance. What performance technique should you implement to improve the performance of SAP HANA information views? Build single large views. Implement union pruning conditions. Output as many fields as possible. Supply reporting tools with all the data in one transfer. What performance technique should you implement to improve the performance of SAP HANA information views that include SQLScript? Use imperative logic. Use SELECT *. Break large statements into smaller steps. Use dynamic SQL. What performance techniques should you implement to improve the performance of SAP HANA information views? (There are 3 correct answers.) Perform calculation before aggregation in your analytic views. Minimize the transfer of data between the execution engines. Investigate partitioning of large tables. Apply filters as late as possible. Push down aggregations to SAP HANA. What engine executes the spatial queries? Calculation OLAP Join SQL. What information can you find in the Explain Plan tool? (There are 2 correct answers.) The execution engines used The number of records returned in each step The time taken for each step The list of operators. What information can you find in the Visualize Plan tool? (There are 2 correct answers.) The execution engines used The number of records returned in each step The time taken for each step The SQL Plan Cache. What information can you find in the Administration Console? (There are 2 correct answers.) The execution engines used The trace and log files The list of operators The SQL Plan Cache. What information can you find in Performance Analysis Mode when you view the analysis for a join node? (There are 2 correct answers.) The suggested filter for the tables in the join node The total number of records returned by the node The time taken by the join The tables used by the join in the node.
