Infosys Certified Power BI for Insights Professional
Practice with real exam-pattern questions for Infosys Certified Power BI for Insights Professional. 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 Power BI for Insights Professional practice questions with answers
Real Lex exam-pattern multiple-choice questions for the Infosys Certified Power BI for Insights Professional certification. Each question includes the correct answer. The full question bank is available to Premium members.
- Question 1
What is the major difference between the old version and a new version of Power BI tool?
- ✓
The latest version has more robust features
Correct - B
This is an all in one solution for Power View, Power Pivot, and Power Query in the backend.
- C
Power BI offers many add-ins for Excel, which is useful for better visualizations.
- D
All of the above
- ✓
- Question 2
What does this function do : RELATED
- ✓
Returns a related value from another related table.
Correct - B
Used to join a table and get a value where there is no relationship defined
- C
used in aggregation without related tables
- D
Used to filter data from a standalone table in the data model
- ✓
- Question 3
What is query collapsing?
- ✓
The process of converting the steps in power query editor to SQL and executing it by the source database is called query collapsing.
Correct - B
Reducing the number of steps in loading the data
- C
Restructing of M-Code
- D
Querying database using DAX functions
- ✓
- Question 4
Who are the essential users of the Power BI? (Select all applicable)
- ✓
Business & Data Analyst
Correct - B
Developer & Database Administrator
- C
IT Team, IT Professional
- D
Consumer for End User Report
- E
Data Scientist
- ✓
- Question 5
What does this function do : ERROR
- ✓
Raises an error with an error message.
Correct - B
Checks if the aggregation has an error and returns TRUE or FALSE
- C
If aggregation has a error, executes an alternate statement
- D
none of the above
- ✓
- Question 6
What does this function do : VAR
- ✓
Stores the result of an expression as a named variable
Correct - B
Calculates the variance of values in a column
- C
Calculates the variance of values in a given filer condition
- D
used to return a variable from a DAX expression
- ✓
- Question 7
List out benefits of using Variables in DAX. (Select one)
- ✓
By declaring and evaluating a variable, the variable can be reused multiple times in a DAX expression, which helps you to avoid additional queries of the source database.
Correct - B
Variables can make DAX expressions more useful and logical.
- C
Variables is only scoped, which should be measure or query which can’t be among measures.
- D
All of the above
- ✓
- Question 8
Define the term ‘M language.”
- ✓
It is a programming language used in Power Query. It’s a functional, case-sensitive language which is similar to other programming languages
Correct - B
It’s a functional language used in the dashbaord to define functions, and its not case-sensitive
- C
It is a formula expression language that can be used with various visualization tools like Power BI
- D
All of the above
- ✓
- Question 9
The principal arrival of Power BI depended on the…
- ✓
Excel
Correct - B
Tally
- C
Forpro
- D
SpreadSheet
- ✓
- Question 10
What is the SQL command to return the values from a table?
- ✓
DISTINCT
Correct - B
SELECT
- C
WHERE
- D
ORDER BY
- ✓
More in DNA
Infosys Certified Databricks Analyst
Infosys Certified Snowflake Advanced Developer
Infosys Certified Tableau Desktop Advanced Developer
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.