Infosys Certified SAP HANA Basics Consultant
Practice with real exam-pattern questions for Infosys Certified SAP HANA Basics Consultant. Each question includes a detailed explanation to help you understand the concept, not just memorise the answer. Try 10 questions free — no login required.
Full question bank for this exam + 1,357+ others. Cancel anytime.
Join Premium10 Infosys Certified SAP HANA Basics Consultant practice questions with answers
Real Lex exam-pattern multiple-choice questions for the Infosys Certified SAP HANA Basics Consultant certification. Each question includes the correct answer. The full question bank is available to Premium members.
- Question 1
Lauren has created a time attribute view of Calendar type ‘Gregorian’ with granularity as ‘Hour’. She selected the Auto Create option while creating this view. Which table will be added by default in the Data Foundation of this time attribute view?
- ✓ M_TIME_DIMENSION Correct
- B M_TIME_DIMENSION_MONTH
- C M_TIME_DIMENSION_YEAR
- D M_TIME_DIMENSION_WEEK
- Question 2
Daniel is working on a HANA system and has imported the data from a CSV file into a table. He wants to know whether this particular task was completed successfully or not. Which of the following window in Modeler perspective will he use to fulfil this requirement?
- ✓ Systems Correct
- B Job log
- C Where used
- D History
- Question 3
Which of the following information models support Variables?
- ✓ Scripted Calculation View Correct
- B Dimension Calculation View
- C Attribute Views
- D Cube Calculation View
- Question 4
A table “CUSTOMER_INVOICES_RECORDS” has the customer invoices from the year 2011 to 2018. As HANA implements the data aging strategies, where will the records of the customers for the years 2016 and 2017 will be stored? Note: Consider the current year as 2018
- ✓ Warm Storage – disk based tier Correct
- B Hot Storage – in memory tier
- C Cold Storage – outside the database
- D Red Hot Storage – in memory tier
- Question 5
Jack has created a decision table with return value, named as “DT_DISCOUNT_CALC” and it returns two additional columns named “DISCOUNT_PERCENTAGE” and “DISCOUNT_AMOUNT”. He wants to execute this decision table in the SQL console. Which of the following statement can he use for executing this Decision table? Note: System Schema denotes the name of the System schema where the Decision table is stored after activation
- ✓
CALL
. “DT_DISCOUNT_CALC”(?) Correct - B
CALL
. “DT_DISCOUNT_CALC” - C
SELECT “DISCOUNT_PERCENTAGE”, “DISCOUNT_AMOUNT” FROM
. “DT_DISCOUNT_CALC” - D
Select * from
. “DT_DISCOUNT_CALC”
- ✓
CALL
- Question 6
Ray has created a graphical calculation view and used RANK node. He added the columns ‘COUNTRY_NAME’ and ‘COMPANY_NAME’ in the Partition block. He has selected the checkbox ‘Dynamic Partition Elements’. In the upper node i.e. Aggregation node, he added only ‘COUNTRY_NAME’ as the output column and did not add ‘COMPANY_NAME’ as the output column. On which column or columns will the data by partitioned in this view?
- ✓ Data will be partitioned only on ‘COMPANY_NAME’ Correct
- B Data will be partitioned only on ‘COUNTRY_NAME’
- C Data will be partitioned on both - ‘COUNTRY_NAME’ as well as ‘COMPANY_NAME’
- D Data will not be partitioned at all
- Question 7
Erica is working on a requirement where one VARCHAR value and one INTEGER value should be returned as output from a logic container. Which of the following logic containers can she use for fulfilling this requirement?
- ✓ Tables Correct
- B Procedures
- C Scalar user defined functions
- D Table user defined functions
- Question 8
Hugo is working on a Cube with Star Join Calculation view CV_SALES_DATA_PRODUCTS that references a graphical Dimension Calculation view called DIM_PRODUCTS with a level hierarchy. Hugo has selected an option called “Enable Hierarchies for SQL Access” in the view CV_SALES_DATA_PRODUCTS. What is the usage of this option?
- ✓ This option helps to include a new node column for the hierarchy. This column can be used via SQL console for displaying filtration and aggregation of data Correct
- B This option helps to include a new node column for the hierarchy. This column can be used via SQL Access tool for displaying filtration and aggregation of data
- C This option helps to include a new node column for the hierarchy. This column will be displayed in the Data Preview of the model to show the hierarchy
- D This option helps to include a new node column for the hierarchy. This column can be used via Microsoft Excel for displaying filtration and aggregation of data
- Question 9
Reynold has created a procedure for working with arrays. He has added the following script in the procedure and returning a table OUTPUT_TABLE with column names as ID and NAME. DECLARE ARR_CARID INTEGER ARRAY := ARRAY(101,102); DECLARE ARR_CARTYPE VARCHAR(50) ARRAY := ARRAY('Sedan','Luxury','Convertible'); OUTPUT_TABLE = UNNEST(:ARR_CARID,:ARR_CARTYPE) AS ("ID","NAME"); END; What will be the result when this procedure is executed?
- ✓ UNNEST will convert the arrays into a table and values in the table will be 101 Sedan 102 Luxury ? Convertible Correct
- B UNNEST will convert the arrays into a table and values in the table will be 101 Sedan 102 Luxury
- C UNNEST will convert the arrays into a table and values in the table will be 101 Sedan 102 Luxury 0 Convertible
- D UNNEST will convert the arrays into a table and values in the table will be 101 Luxury 102 Convertible
- Question 10
Which of the following objects can be transported as a part of Delivery unit?
- ✓ Information Models Correct
- B Decision tables
- C Tables in a schema
- D Indexes in a schema
- E Analytic Privileges
More in SAP
Infosys Certified SAP MDG Functional Professional Consultant
Infosys Certified SAP C4C50 Professional Consultant
Infosys Certified SAP S4 HANA Embedded Analytics Professional Consultant
Pay once. Clear every cert this year.
One subscription, full Telegram channel access, every PDF posted during your membership.
- Full access to all 1,357+ certifications
- Monthly updated question banks
- Telegram private channel access
- Cancel anytime
- Everything in Monthly
- Save ₹2,100 vs monthly billing
- Priority answer key requests
- Best for increasing DQ score fast
- Everything in Quarterly
- Lifetime channel access — no renewals
- All future certifications included
- Priority response from admin team
Common questions, straight answers.
A monthly-updated Telegram channel where we post real exam-pattern question banks and detailed answer keys for 1,357+ Infosys Lex certifications. You join once, you get every PDF posted during your membership.
Right after payment on our Graphy page, you'll receive a private invite link to the Telegram channel. Access is instant — usually under 30 seconds.
We compile question banks from the actual Lex test pattern, sourced and verified by 180K+ community members who've recently cleared these exams. Match rate is consistently 85–95%.
Every single month. When Infosys rolls out new versions of certifications, we post updated dumps within 7–10 days. You'll see channel activity weekly.
Clearing certifications is one of the highest-weighted DQ factors. Members typically clear 3–5 certifications in their first 3 months, which moves DQ scores up by a full band.