Microsoft Power BI Online Assessment Test

Topics covered

File Optimization, Data source connectors
Power BI Conditional Column, Power BI Template files
Dashboard sharing, Power BI Direct Query, Power BI - DAX
Import to Power BI, Power BI Desktop file

  • MAQ (Multiple Answer Question)
  • MCQ (Multiple Choice Question)
  • Descriptive Question
  • White Board Simulator
  • Coding Simulator
  • Audio Question
  • Video Question
  • Case Study Question

Microsoft Power BI is a data visualization and business intelligence tool that mainly converts data from different data sources to interactive dashboards and BI reports. It helps to provide multiple software, connector, and services - Power BI desktop, Power BI service based on SAAS, and mobile Power BI apps available for different platforms. Power BI developer also maintains database performance by identifying and resolving production and application development problems.
Our Microsoft Power BI quiz test is created & validated by experienced Microsoft Power BI Experts (SMEs) to assess Power BI skills of candidates as per industry standards. Microsoft Power BI assessment test helps HR and hiring managers to evaluate the expertise of candidates in core concepts that are required to carry out Power BI developing process.

Microsoft Power BI skills test contains questions on below topics:

  • File Optimization

  • Data source connectors

  • Power BI Conditional Column

  • Power BI Template files

  • Dashboard sharing

  • Power BI Direct Query

  • Power BI - DAX

  • Import to Power BI

  • Power BI Desktop file

Our Power BI quiz test ensures the recruiters to hire best applicants, who have effective skills such as building Power BI dashboards, good communication with stakeholders and knowledge of SQL, Power BI. The score reports give you a detailed analysis of every candidate that provides better insights on who could be the best fit for your organization.

This pre-employment test is useful for hiring:
  • Power BI Developer
  • Power BI Expert
  • Senior BI Consultant Developer

Test details:

The Microsoft Power BI skills assessment test enables employers to identify & hire potential prospects by evaluating their working skills and job readiness. For this reason, an emphasis is laid upon evaluating the knowledge of applied skills gained through real work experience, rather than theoretical knowledge.
The Power BI test may contain MCQ's (Multiple Choice Questions), MAQ's (Multiple Answer Questions), Fill in the Blank, Descriptive, Whiteboard Questions, Audio / Video Questions, True or False.

Test Duration: 20 minutes

10 Application Questions

Our Power BI assessment test contains a combination of application and theory questions that help you to evaluate the application as well as practical skills of candidates.

Microsoft Power BI Test

Question #1 of 3

You loaded data to your Power BI desktop from a Microsoft Access database file (file.accdb) which is around 20 MB in size. However, when the data was loaded and copied into a power bi desktop file (file.pibx) the size of this file was observed to be around 3 MB in size. What could be the possible reason for this noticeable reduction in size?

    • Unlike access db file the Power BI desktop file stored data row-by-row instead of col-by-col

    • Unlike access db file the Power BI desktop file stored data col-by-row instead of row-by-row

    • Power BI ignores copying the duplicate data in the file along with ignoring copying any BLOB type data which leads to considerable size reduction

    • None of the mentioned

Question #2 of 3

In Power BI Query editor, what do you do to translate the currently selected columns into attribute-value pairs, combined with the rest of the values in each row in an organized manner?

    • use Pivot columns

    • use Reverse rows

    • use Aggregate option

    • use Unpivot columns

Question #3 of 3

You have a business tool built over Power BI and all the customers using the tool has the same database schema. However, the databases have different names and are hosted in different instances of SQL Server. How can you connect to different databases just using one query?

    • Using Query parameters

    • By running the query on a multithreaded SQL Server instance

    • This is not possible using one query

    • None of the mentioned

Candidate Name
Assessment Name
Invited by
Assessment Date
IP Address

24.00 Out of 40.00
23 Minutes

Java EE




Oracle PL/SQL


Analytical Thinking


Note:If score<= 30% then its a Weakness. If score >=70% then its a Strength.


Java EE, Oracle PL/SQL, Analytical Thinking




It was a good test for me, the questions were on the latest technology of java on which I am currently working. It was a great experience. Thank you!

Sign up for a free trial today

Get your free trial and test up to 10 candidates. No strings attached. No credit card required.


Schedule a Demo

How Interview Mocha works?

  • Add this test to your account

  • Invite candidates to take this test online

  • Candidates take the test

  • View and share actionable test reports

Trusted by leading brands worldwide

  • altran
  • credit suisse
  • sephora
  • nielsen
  • capgemini
  • hexaware
Why hiring managers and recruiters across the globe love Interview Mocha
  • Largest number of ready pre-employment skill tests
  • Relevant test compositions and quality questions designed by Subject Matter Experts (IM SME)
  • Fastest custom test creation DNA
  • World’s most super easy skill assessment platform
  • High level of platform security implementation
  • Friendly and quick customer support
  • Ready to listen and implement your feedback, we are all ears
  • Affordable pricing

Sign up for a free trial today

Get your free trial and test up to 10 candidates. No strings attached. No credit card required.


Schedule a Demo