Infosys Certified Microsoft Power BI Advanced Developer
Practice with real exam-pattern questions for Infosys Certified Microsoft Power BI Advanced Developer. 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 Microsoft Power BI Advanced Developer practice questions with answers
Real Lex exam-pattern multiple-choice questions for the Infosys Certified Microsoft Power BI Advanced Developer certification. Each question includes the correct answer. The full question bank is available to Premium members.
- Question 1
Which two are the right syntaxes to create a measure using SELECTEDVALUE() DAX function, that intends to use the dynamic value of an attribute in a visual?
- ✓
courseName = "The selected course is " & SELECTEDVALUE(DIMCOURSES[COURSE],"None")
Correct - B
courseName = "The selected course is " & SELECTEDVALUE("Blank",DIMCOURSES[COURSE])
- C
courseName = "The selected course is " & SELECTEDVALUE(DIMCOURSES[COURSE])
- D
None of the above
- ✓
- Question 2
In a many-to-many relationship, is it mandotory to have at least one column with unique values in any 1 of the tables?
- ✓
true
Correct - B
false
- C
Depends upon the version of Power BI
- D
Not applicable.
- ✓
- Question 3
How does the FORMAT function behave if "format_string" argument is missing from FORMAT(
, )? - ✓
"format_string" is a mandatory parameter. It must not be blank
Correct - B
The value is formatted as "General Text"
- C
If "format_string" is blank , the value is formatted with a "General Number" or "General Date" format (according to the value type)
- D
The result is undefined
- ✓
- Question 4
Gosling requires to find the number of customers who are not having prime member access ID from their retail database. If the customer is not a prime member then NO value is present in the respective row. Which of the following statistical DAX functions should be used to solve this requirement?
- ✓
COUNTAX
Correct - B
COUNTNULL
- C
COUNTBLANK
- D
COUNTEMPTY
- ✓
- Question 5
Which of the following aptly summarizes the process of importing and transforming JSON data in Power BI?
- ✓
a process of connecting to a JSON data source and loading data. Power BI, being such a robust tool, does all required steps automatically.
Correct - B
a process of importing JSON data which includes drilling down and transforming from the upper most level of the file/data until one gets to the desired set of records needed for the final Power BI visualization.
- C
a process of importing JSON data which includes just drilling down from the upper most level of the file/data to a desired level. All the required transformation are automatically handled by Power BI.
- D
None of the above
- ✓
- Question 6
Consider a column having values in the form of 'Production-Technician-Support-AW-1000045'. A 'Split Column by delimiter' transformation is used on this column with 'left-most delimiter' radio button selected for 'Split-at' option in Query Editor. How many split columns will be created after this transformation is applied on the column?
- ✓
1.0
Correct - B
2.0
- C
5.0
- D
Depends on the delimiter
- ✓
- Question 7
Sheldon who is experienced in data modelling, imported few tables and created relations among them in Power BI. But with the relationships created as shown in the screenshot, Sheldon couldn’t extract Product details with respect to Time. What could be the issue with the relationship? Choose the best option.
- ✓
The relationship should be created with different keys.
Correct - B
Cross filtering properties of the required tables are set to ‘Both’ or ‘bi-directional’, which can cause this issue.
- C
Cross filtering properties of the required tables are set to ‘Single’ or ‘unidirectional’ which can cause this problem.
- D
There's no direct relationship between DimProduct and DimTime tables.
- ✓
- Question 8
In a modelling scenario where the dimension table "Dept" is linked to 2 Fact tables "Expense" & "Budget", what should be used as options for Cross filter direction?
- ✓
BOTH
Correct - B
SINGLE
- C
One-to-Many
- D
Many-to-Many
- ✓
- Question 9
In which of the scenarios Power BI can't generate insights on a dataset?
- ✓
When the data isn't statistically significant
Correct - B
When the data is fetched using Direct Query
- C
When the data is fetched directly from Local files
- D
When the data is fetched using Live connection
- ✓
- Question 10
To populate a parameter using a Query option, which of the following types of query is required?
- ✓
Table Query
Correct - B
List Query
- C
Table Query with a single column
- D
Function Query
- ✓
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.