Search Adaface test library by skills or roles
⌘ K

Adaface Sample Power BI Questions

Here are some sample Power BI questions from our premium questions library (10273 non-googleable questions).

Skills

🧐 Question

Medium

Default summarization
Data Visualisation
Solve
                                    Review the following table in Power BI:
                                    
 image
                                    Here’s the visualisation generated when Book and ReadingChallenges columns are added to a table visualisation:
                                    
 image
                                    Why do we see only 4 rows?
                                    

Options:

  • Default Summarization on Book
  • Data Category of Book is set to Book
  • Default Summarization on ReadingChallenges
  • The ReadingChallenges column data type is set to text

Medium

Many-to-one error
Data Modeling
Solve
                                    Consider the following two tables in Power BI:
                                    
 image
                                    We received the following error when we tried to set many-to-one cardinality between devices to users tables: “The cardinality you selected isn’t valid for this relationship”. What should we do before creating the many-to-one relationship?
                                    

Options:

  • Query Editor → Remove Errors from Device Table
  • Query Editor → Remove Duplicates from User Table
  • Query Editor → Filter out blank values from User Table
  • Add a new index column to the Device Table named Device ID

Medium

Power Query Functions
Power Query
Solve
                                    Review the following Microsoft SQL Server table:
                                    
 image
                                    Complete the following Power Query formula used to create a custom column to replace the numbers present in last 11 characters of ISBN with 11 ‘*’. Example ‘978-0-365-51051-4’ is converted to ‘978-0-***-*****-*’
                                    
 image
                                    A: Text.Insert
            B: Text.Replace
            C: Text.Start
            D: Text.End
                                    

Options:

  • A B
  • A C
  • A D
  • B C
  • B D
  • B A

Easy

DAX
Solve
                                    We want to create a DAX formula in Power BI that automatically calculates the previous month number. If month is May, the formula would return 4. We have already created the DAX formula: 
                                    
                                    Today Month = MONTH (Sales[Todays Date])
                                    
                                    Which of the DAX formulas below would be the right choice next?
                                    
                                    A: Previous Month = Sales[Today Month]-1
            B: Previous Month = PREVIOUSMONTH(Sales[Today Month])
            C: Previous Month = STARTOFMONTH(Sales[Today Month])-1
            D: Previous Month = IF (Sales[Today Month] =1, 12,Sales[Today Month]-1) (correct)
                                    

Options:

  • A
  • B
  • C
  • D

Medium

Sample data in Power BI
Power Query
Solve
                                    Consider the following Microsoft SQL Server tables:
                                    
 image
                                    Which of the following will enable us to import sample data from Sales table in Power BI Desktop?
            
            A: Query Editor → Filter table by Sale Date
            B: Power BI Model → Create a calculated table
            C: Query Editor → Create a custom column using sample function
            D: Query Editor → Add SELECT statement with WHERE clause on Date
                                    

Options:

  • A B
  • A C
  • A D
  • B C
  • B D
  • C D
🧐 Question🔧 Skill

Medium

Default summarization
Data Visualisation
2 mins
Power BI
Solve

Medium

Many-to-one error
Data Modeling
2 mins
Power BI
Solve

Medium

Power Query Functions
Power Query
2 mins
Power BI
Solve

Easy

DAX
3 mins
Power BI
Solve

Medium

Sample data in Power BI
Power Query
2 mins
Power BI
Solve
🧐 Question🔧 Skill💪 Difficulty⌛ Time
Default summarization
Data Visualisation
Power BI
Medium2 minsSolve
Many-to-one error
Data Modeling
Power BI
Medium2 minsSolve
Power Query Functions
Power Query
Power BI
Medium2 minsSolve
DAX
Power BI
Easy3 minsSolve
Sample data in Power BI
Power Query
Power BI
Medium2 minsSolve

Adaface questions are trusted by enterprises globally

Amazon Morgan Stanley Vodafone United Nations HCL PayPal Bosch WeWork Optimum Solutions Deloitte Microsoft NCS Doubtnut Sokrati J&T Express Capegemini

We evaluated several of their competitors and found Adaface to be the most compelling. Great default library of questions that are designed to test for fit rather than memorization of algorithms.


Swayam Narain, CTO, Affable

hashtag image heart icon Swayam
Join 1200+ companies in 75+ countries.
Essayez l'outil d'évaluation des compétences le plus candidat aujourd'hui.
Ready to streamline your recruitment efforts with Adaface?
Ready to streamline your recruitment efforts with Adaface?
Discute avec nous