POWER BI MCQ with Answers

Hello friends in this post we are going to discuss about POWER BI MCQ with answers | POWER BI Multiple choice questions | POWER BI Objective type questions | POWER BI Accenture Question Answers

1.The marketing team needs a new dashboard to show the uptake of social users on the company’s corporate forum. The dashboard will contain one particular report that shows the total number of users that registered for the site In each of the months of the year. For this report you want to create a dataset with a calculated column that displays the date with the abbreviated month name followed by the four digit year e.g. 1/1/2018 Which DAX expression should you use

a)FORMATf [RegistrationDate], “MMM yyyf)
b)FORMAT( [RegistrationDate], “MM yyyy”)
c)FORMAT( [RegistrationDate], “mm yyyy’)
d)FORMAT( [RegistrationDate], “M yyyy” )

Ans: a

2.As part of a large data project you want to create a dashboard using the Power Bl Service. Data will come from a variety of different sources. Do you know which of the following sources would require a Power Bl Enterprise Gateway

  1. Spark on Azure HD Insight
  2. SQL Server Analysis Services (on-premise)
  3. Azure SQL Data Warehouse
  4. CSV file saved on OneDrive for Business

Ans: 2

3.The Internal finance team needs a new dashboard creating to show projected revenue for the coming years so they can adequately plan for future budgets. All of the data for this dashboard will come from SQL Server 2005 that Is running on the company’s main SQL Server machine. The IT team has informed you that the SQL Server machine has many instances of SQL Server installed including 2005, 2008, 2012 and even 2016. If the server name was ACMESQL and the Instance name provided by IT was SQL2005, what would you type Into the Server name textbox when connecting through Power Bl?


Ans: a

4. With Power Bl Publish to web. you can easily embed Interactive Power Bl visualizations online, such as In blog posts, websites, through emails or social media, on any device

a) You have published a visualization but unfortunately, changes to the underlying data are not immediately visible to users. What might be wrong?

b) You must refresh the data manually after publishing to the web
c) It takes up to an hour for data to refresh
d) You cannot refresh data after publishing to the web, the visuals are static
e) The user does not have the appropriate row level security permissions

Ans: a

5.The DAX FORMAT (Unction Is used to convert a value to text according to the specified format that you provide as the second avgunent to the function. Which DAX expression below would format the number so that It’s displayed as 20.00%?

a) FORMAT( 0.2, “Percent”)

b) FORMATf 0.2, “p”)
c) FORMAT( 0.2, )
d) FORMAT( 20, “Percent’’)

Ans: a

6.A ratal analysis dashboard contains a smal colecbon of datasets Including Sales, Items and Stores You have dragged the Category fteid from the hem dataset onto the report canvas You now want to give users the option to select one many ar al Categories to Sier the vtsuais on the report Which element should you pick from the

a) Slicer
b) Multi-row card
c) Card
d) Funnel

Ans: a

7. If you want to combine data from multipie sources Into a single model, for example, to join some data from a corporate SQL Server database with some local data maintained In an Excel file. Is DirectQuery a good choice for this scenario rather than Import

Ans- no

8.Say you and your teammates want to distribute your Power Bl Insights to your organization. The best way to do that Is to create an app. An app is a collection of dashboards and reports built to deliver key metrics for your organization.create an app, you need a app workspace, with your teammates as members Think of the app workspace as a staging area where you and they can collaborate on your Power Bl dashboards and reports. All of you can create reports In Power Bl Desktop and publish those reports to the app workspace, and all of you need Power Bl Pro licenses. If you Just want to share a finished dashboard with colleagues should you add those colleagues to the app workspace?

Ans- no

Leave a Reply

Your email address will not be published. Required fields are marked *