Infosys Certified SAP HANA Professional Consultant
Practice with real exam-pattern questions for Infosys Certified SAP HANA Professional 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 Professional Consultant practice questions with answers
Real Lex exam-pattern multiple-choice questions for the Infosys Certified SAP HANA Professional Consultant certification. Each question includes the correct answer. The full question bank is available to Premium members.
- Question 1
Which of the following will NOT be a Use Case for SAP HANA?
- ✓ Event processing from multiple locations Correct
- B Business alerts and decisions in real-time
- C Planning and simulation scenarios with large data
- D Analytics with large data volumes that may not be possible today
- Question 2
in what form is HANA available today?
- ✓ HANA can sit as database below any SAP system Correct
- B HANA can sit below BW and MAP systems
- C HANA can sit as database below any BW system
- D HANA can sit as database below BW7.3 system only
- Question 3
Which SQL condition can be used to identify the missing fields ("?") in a Join Output
- ✓ IS NULL Correct
- B = NULL
- C ="?"
- D IF NULL
- Question 4
What is TRUE for Referential Join?
- ✓ If no fields from the right table is selected it will act similar to a left outer join Correct
- B It is similar to an outer join, but with an assumption that referential integrity is always maintained
- C Referential Joins will be always be executed
- D If no fields from the right table is selected it will act similar to a right outer join
- Question 5
What is FALSE for Unions
- ✓ Union types include "Union with Variables" and "Union with Constant Values" Correct
- B Use UNION in Calculated views combining several Analytical Views.
- C UNION is used for combining planned and actual values in COPA
- D Unions combine result sets of two or more SELECT statements
- Question 6
What is NOT a valid option of Data Preview?
- ✓ Export as Chart Correct
- B Raw data preview
- C Distinct values
- D Analysis
- Question 7
Which is FALSE for Calculated Attributes
- ✓ Allowed to use measure attributes as a part of calculation Correct
- B Can have either a static value or dynamic value calculated at runtime
- C Can be an arithmetic or character manipulation
- D Functions like String, Date functions are available.
- Question 8
Activating a view creates Column view in which Schema
- ✓ _SYS_BIC Correct
- B _SYS_BI
- C _SYS_REPO
- D _SYS_DATA
- Question 9
What is NOT a best practice for attribute views
- ✓ Use UNION in place of JOINS in attribute views Correct
- B Reuse similar attribute views
- C Make attribute views as generic as possible
- D Group tables related to one entity in one attribute view
- Question 10
What is TRUE, while creating a new Analytic View
- ✓ Package name is populated by default and it is not modifiable Correct
- B Package name is populated by default and it is editable
- C Schema name is populated by default and it is not modifiable
- D Schema name is populated by default and it is editable
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.