C_HANAIMP_1 무료 덤프문제 온라인 액세스

Where does SAP recommend you create calculated measures?

• A.In an attribute view
• B.In a business layer
• C.In an analytic view
• D.In a column view

Your customer has the following reporting requirements:
-Real-time profitability reporting on large-scale data volumes -On-the-fly analysis of profitability data at any level of granularity, aggregation, and dimension -Cost allocation reports with significantly faster processing time
Which application do you recommend?

• A.SAP Bank Analyzer with SAP HANA
• B.SAP Deposits Management with SAP HANA
• C.SAP HANA CO-PA Accelerator
• D.SAP HANA for Banking

A customer wants to reproduce the following SQL statement in SAP HANA:
SELECT P.PROD_NAME, P.PROD_ID, PT.PROD_DESC
FROM PRODUCTS P,
PROD_TEXTS PT
WHERE P.PROD_ID=PT.PROD_ID;
Which of the following SQLScript constructs is equivalent to this SQL statement and yields the best performance?

• A.SELECT P.PROD_NAME, P.PROD_ID, NULL as PROD_DESC FROM PRODUCTS P UNION
  SELECT NULL as PROD_NAME, PT.PROD_ID, PT.PROD_TEXTS FROM PROD_TEXTS PT;
• B.ot_products= CE_COLUMN_TABLE(PRODUCTS);
  ot_prodtexts= CE_COLUMN_TABLE(PROD_TEXTS);
  ot_all=CE_UNION_ALL(:ot_products, :ot_prodtexts);
  output=CE_PROJECTION(:ot_all, [PROD_NAME, PROD_ID, PROD_DESC]);
• C.SELECT P.PROD_NAME, P.PROD_ID, PT.PROD_DESC FROM PRODUCTS P JOIN
  PROD_TEXTS PT ON P.PROD_ID=PT.PROD_ID;
• D.ot_products= CE_COLUMN_TABLE(PRODUCTS);
  ot_prodtexts= CE_COLUMN_TABLE(PROD_TEXTS);
  ot_all=CE_JOIN(:ot_products, :ot_prodtexts, [PROD_ID]);
  output=CE_PROJECTION(:ot_all, [PROD_NAME, PROD_ID, PROD_DESC]);

You created a model on a table XYZ.PRODUCTS. You successfully activated the model. When you run the data preview you receive an error message "Insufficient privilege. Not authorized".
Which of the following 4 statements do you execute to resolve the error before you reactivate the model?

• A.GRANT SELECT on PRODUCTS to _SYS_REPO WITH GRANT OPTION
• B.GRANT SELECT on SCHEMA XYZ to _SYS_REPO
• C.GRANT SELECT on PRODUCTS to _SYS_BIC
• D.GRANT SELECT on SCHEMA XYZ to _SYS_BIC WITH GRANT OPTION

Using SAP BusinessObjects Data Services, in which of the following can you perform data transformations? (Choose two)

• A.Script
• B.Datastore
• C.XML File
• D.Query