Adaface Sample SAP HANA Questions

Musk joined as SAP HANA administrator at Grimes Inc. While working on HANA database, Musk noticed the following:

1: While joining the tables P and Q, Number of rows in the output is equal to row count P multiplied by row count in Q
            2: Log area is filling continuously and causing database to hang

Which of the following statements are correct?
            
            A: Musk is using Outer Join to join P and Q
            B: Musk is using Self Join to join P and Q
            C: Musk is using Cross Join to join P and Q
            D: Musk can limit file size to fix the log area issue
            E: Musk can use backint destination type to fix the log area issue
            F: Musk can enable automatic log backup to fix the log area issue

Jupiter Inc. is facing performance issues with SAP BusinessObjects reports based on SAP HANA data. Which of these would you recommend to improve performance?

A: Add only relevant data to the report queries
            B: Avoid aggregation and work on raw data
            C: Use drill-down or linked reports
            D: Merge all relevant data into a consolidated report
            

Tony joined Lokitwa as junior SAP HANA developer. Which of the following would you recommend to Tony for storing data in BW system running on SAP HANA?

A. Move less important data into an external storage system (cool data)
            B. Store the most relevant data in a compressed column store (hot data)
            C. Store the bulk of the data on disk for retrieval when required (warm data)
            D. Store all data in compressed column stores to maximize performance (hot data)
            E. Split the most relevant data by date and store between an uncompressed column store and tables stored on disk (warm data)