Infosys Certified L2 Junior BI Professional Consultant
Practice with real exam-pattern questions for Infosys Certified L2 Junior BI 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 L2 Junior BI Professional Consultant practice questions with answers
Real Lex exam-pattern multiple-choice questions for the Infosys Certified L2 Junior BI Professional Consultant certification. Each question includes the correct answer. The full question bank is available to Premium members.
- Question 1
If product price is a slowly changing dimension , how do you model product price if you want to report on the price at the time of query?
- ✓ As a characteristic on the material dimension Correct
- B As a time-dependent navigational attribute of material
- C As a time-dependent hierarchy of material
- D None of the given choices
- Question 2
Which of the following refer to pointer tables that provide the technical link to the master data outside of the InfoCube?
- ✓ Dimension tables Correct
- B M tables
- C SID tables
- D All of the given choices
- Question 3
Which of the following is an example of a slowly changing dimension?
- ✓ Customer on a sales order Correct
- B Date
- C Person responsible for a cost center
- D Value of a purchase order
- Question 4
Fact tables may be partitioned by which of the following characteristics?
- ✓ 0CalDay Correct
- B 0CalMonth
- C 0CalYear
- D 0CalWeek
- Question 5
A Fact table consists of which of the following elements?
(Select two options)- ✓ Characteristic InfoObjects Correct
- B Key figure InfoObjects
- C Calculated Key figure InfoObjects
- D Hierarchies
- Question 6
If you worked for a retail company that changed prices on a very frequent basis, how would you model the price?
- ✓ In the master data table as an attribute Correct
- B In the transaction table as a new characteristic
- C In the DSO to enhance performance
- D In the fact table
- Question 7
How many hierarchies can be created for a key figure?
- ✓ 10 Correct
- B 2
- C 5
- D None of the given choices
- Question 8
Navigational attributes behave in a query like which of the following?
- ✓ Attributes Correct
- B Variables
- C Characteristics
- D Filters
- Question 9
When should an attribute be placed in a separate dimension?
- ✓ Always Correct
- B If the attribute changes frequently
- C If the attributes have a large number of distinct values
- D Never
- Question 10
Which of the following objects is not provided in business content?
- ✓ SAP R/3 Extractor Program Correct
- B KPIs
- C Queries
- D None of the given choices
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.