Are you a candidate looking to sharpen your skills? Try our practice tests or view sample interview questions & Get hired by the best. Click Here×

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

Useful for hiring

  • Power BI Developer
  • Power BI Expert
  • Senior BI Consultant Developer

Start hiring job-fit candidates using this assessment

GET A DEMO

"We are impressed with Interview Mocha's comprehensive IT skill test batteries and their ability to provide tailor-made assessments quickly. The results we got from Interview Mocha exceeded our expectations, employees found the tests quick, fun, and a benchmark of their knowledge."

Ajay Garg, Siemens,
Associate Manager
Question

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?

Answer
    • 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

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?

Answer
    • use Pivot columns

    • use Reverse rows

    • use Aggregate option

    • use Unpivot columns

Question

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?

Answer
    • Using Query parameters

    • By running the query on a multithreaded SQL Server instance

    • This is not possible using one query

    • None of the mentioned

Good News! You can customize this test as per your requirement

  • Choose and add questions from Interview Mocha question libraries

  • Add your own set of questions

  • Customize test settings like duration, number of questions, passing score, web proctoring and much more

  • Mail us at support@interviewmocha.com to create a custom test

Looking for a tailor-made test, to suit your assessment needs?

Get in touch

Global companies using Mocha assessments

  • altran
  • credit suisse
  • sephora
  • nielsen
  • capgemini
  • akamai

How Mocha assessments are brewed

Speed up your IT recruitment with Interview Mocha

  • 500+ IT skill tests
  • 20+ coding languages
  • 50+ domain knowledge tests
  • 100+ digital 2.0 skill tests
  • Customer focus aptitude tests
  • Enterprise ready features & more...
GET A DEMO

Why hiring managers and recruiters across the globe love Interview Mocha

Take your first step to hire job fit candidates

GET A DEMO