Microsoft Power BI Linkedin Skill Test Question Answers

2

 Microsoft Power BI Test Question Answers



1. Which of the following is not self serviced BI tools?


SAP BO

Tableau

QlikSense

MS Power BI


2. Power BI has a limit of ____________GB data in free version.


1

2

3

4


3. What is NOT a built-in Power BI visual?


Power KPI

ArcGIS map

Funnel chart

Waterfall chart


4. Power BI Pro has a limit of ____________GB data in free version.


10

20

30

40


5. Natural Language Queries Feature is Available


SSRS

Tableau

Power BI Service

Power BI desktop


6. Power BI portable application is accessible for all these with the exception of_______


IOS

Android

BlackBerry

Windows Phone


7. Which isn't a data compose in Power BI?


Date

Double

Decimal Number

None of the above


8. Which area do you go to change and reshape data in Power BI


Data Editing

Question Editor

Data Modeling

Data Transformation


9. Data can be refreshed in Power BI service by


Apps

Gateway

Refresh service

Power BI Desktop


10. One Can create visualizations


Data Window

Page Sheet

Query window

Relation window


11. What are content packs?


documents

files

folders

All of above


12 Which  is a single page, often called a canvas, that uses visualizations to tell a story.


Power BI Service dashboard 

Power Bi Desktop Dashboard 

Power Bi Desktop Sheet 

Power BI Service Multiple sheets 


13 Which three views are available in Power BI Desktop? 


a) Dashboard 

b) Report 

c) Data 

d) Relationships 


a,b and c 

a,b and d 

b,c and d 

a,b,c and d 


14. Self serviced BI Tool  will 


Increase IT cost 

Reduce IT cost 

Increase dependency on IT 

Increase time to get reports into production 


15. In which window one can see data of choosen table in PowerBI Desktop 


Data Windows 

Visualization window 

Relationship window 

Page window 


16. A dataset that includes _ can be used to create a map visualization. (Select all that apply.)


A. house numbers, street names

B. geospatial data

C. city names, country names

D. longitude, latitude


A, B, C, D

A, C, D

B, C, D

D


17. How do you create a chart visual in Power BI Desktop Report view? (Select all that apply.)


A. Click New Visual on the Home tab.

B. Select a chart visual in the Visualizations pane.

C. Click New Visual on the Data Tools tab.

D. Select a field that contains values.


A, B, or D

B or D

B orC

A or B


18. What daily sales number does this DAX measure formula calculate?

CALCULATE(SUM([Sales]) ,DATESMTD([Date] ))


running total sales in each month that starts over each month

total sales for the entire month

running total in entire year for the entire month

rolling average over 12 months of sales


19. You are creating a report in Power BI Desktop and want to restrict the data to records where Country="Canada". To accomplish this, what do you need to create?


a directive

a custom column

an indexed column

a parameter


20. What is the primary benefit of using visualizations such as line charts, bar charts, and column charts?


They are easier to create than other visualizations.

They require fewer resources than more complex visualizations.

They are also used in Excel, so they feel familiar to users.

They are free to use.


21. What are the different views in Power BI Desktop?


Report View, Data View, Relationship View

Report View, Relationship View, Draft View

Data View, Draft View, Canvas View

Data view, Relationship View, Canvas View


22. In Power BI service, deleted pages are available after deletion until


midnight of the day on which they are deleted

the next billing cycle

you empty the Recycle Bin

the report has been saved


23. You need to add a required color to a bar chart. How can you add an exact color value to an existing bar chart?


Click the color in the visual (e.g., the bars) and right-click to select the color.

You cannot select custom colors in a bar chart or related visual.

Select the value closest to this color from the color formatting options.

Enter the hex value into the color formatting options.


24. The Excel function IF is nearly the same as which DAX function?


SWITCH

IF

IFX

IFS


25. Consider the Power BI extract, transform, and load process (ETL). During this process, data is read and then


stored in S#### QL Server

written to an OLAP cube

assigned a data type

sorted by primary key


26. When you use Publish to Web in the Power BI service, who can view your published content?

everyone in your environment

anyone on the internet

everyone in your organization

only you


27. The iterator functions SUMX and AVERAGEX are used to perform calculations _.


for Power BI mobile apps

in Power BI service rather than Power BI desktop

in the context of a record

for very large datasets


28. In Power BI Desktop Model view, what type of join will yield all results from Table 1 and any matching results from Table 2?


Right Outer Join

Left Outer Join

Left Inner Join

Right Inner Join


29. You want to combine several CSV files into a single data file after you connect a folder. What must be true about these CSV data files? (Select all that apply.)


A. They must be stored in the same folder. 

B. They must have the same schema. 

C. They must have the same file type. 

D. They must have no duplicate data rows.


B, C

A, B, C

A, B, D

B, C, D


30. If you delete a dateset in the Power BI service, what happens to the dashboards and reports supported by the dataset?


They will be stored as static dashboards and reports.

They will be deleted.

They will be converted to image files.

Nothing—they will be unchanged.


31. Power BI's Publish to Web option allows you to embed visualizations within _. (Select all that apply.)


A. blog posts

B. email messages

C. web sites

D. text messages


A,C

C

A, B, C

A, B, C, D


32. What can you do within the Power BI Desktop #### Query Settings pane? (Select all that apply.)


A. Rename a query step.

B. Delete a query step.

C. Delete from one query step to the end.

D. Reorder the steps.


B, C, D

A, B, C, D
A, B, D

A, B, C


33. After you enter text in the #### Q&A box or O&A visual, Power BI will \_ your data to create a list of appropriate visualizations.


filter and group

sort and filter

sort, filter, and group

sort and group


34. You have a sales data source and want to relate the tables. The table that contains sales transactions is a _ table that contains product information is a _ table .


dimension; fact

lookup; data

data; lookup

data; supporting


35. When you are creating a formula in the Power Query Editor, what does IntelliSense provide a list of? (Select all that apply.)


A. columns

B. tables

C. functions

D. data sources


B,C

A, C, D

C,D

A, B, C


36. You want to delete a dataset but the Power BI service will not let you. What is the most likely cause?


A tile on your dashboard contains data from that dataset.

The dataset is already being used in a published app.

A report contains data from that dataset.

The dataset is in your workspace.


37. One of your data columns includes the city, state, and postal code line of a mailing address. You need to separate the fields so you can access the geospatial elements for a map visualization. What transformation should you apply?


Replace values

Split column

Modify data type

Best fit geospatial


38. Formatting options within a visualization depend on what?


the visualization you are formatting

the editor you use

the visualization group

your permissions


39. What tool can you use in Power BI Desktop to reduce data?


report editor

Power Query Editor

dashboard

data modeler


40. What is NOT a valid data connection type for Power BI Desktop?


Azure data

file data

relationships data

database data


41. Which data type can be uploaded directly to powerbi.com?


Excel files

comma-separated value (CSV) files

Power BI Desktop files

all of these answers


42. What does Power BI Premium provide?


Power BI Report Server

report sharing without a per-user licens

all of these answers

dedicated capacity for your company


43. You have a report in Power BI service and want to save the state of a report page for easy access. What feature helps you do this?


views

filters

bookmarks

slicers


44. What should you do to increase the readability of a report?


all of these answers

Remove unnecessary field labels.

Select the most appropriate visualization.

Use borders.


45. Which feature in the Power BI service is most useful when you need to create pages that present the same visualizations for different territories, salespeople, or teams?


landscape mode

none of these answers

Shrink to Fit

templates


46. What should you use to highlight a specific visualization in a report?


Spotlight

Highlight

Magnify

None of the answers


47. What does My Workspace on powerbi.com include?


Visualizations and a fields list

Toolbars and preferences

Workbooks and visualizations

Dashboards and reports


48. You want to access the underlying data for a specific data point in a visualization. What should you choose?


Drill up

Drill down

Expand to next level

Collapse


49. You have a treemap visualization that groups by sales territory. To allow users to further analyze data for a specific territory, what filter should you apply?


Visual level

Page level

Drillthrough

Expand down


50. Facebook, Twilio, and MailChimp are all examples of Power BI _.


online services

Wiki data sources

database data sources

File data sources


51. Which DAX function compares a column of values in Table A with a similar column in Table B, and returns the values the are not found in Table B?


COMPARE

FINDUNIQUE

EXCEPT

SWITCH


52. Your data model includes two related tables, Customers and Orders. To determine the number of customers that have placed orders, create a measure on the _ table using the _ function.


Orders; DISTINCTCOUNT

Customers; COUNT

Orders; COUNT

Customers; DISTINCTCOUNT


53. Power BI works best with tables that are _,


short and wide

long and skinny

short and skinny

long and wide


54. You have two columns of numerical data and want to create a visual to help determine if there is a relationship between them. What kind of chart is designed to do this?


bar chart

bubble chart

line chart

scatter chart


55. In the report editor, which task can you NOT accomplish using drag and drop?


Add more information to a visualization.

All of these tasks can be done with drag and drop.

Create a new visualization.

Rearrange and resize visualizations.


56. In general, what is the best way to shape your data for Power BI?


User a star schema.

Load all tables from the data source.

all of these answers

Include multiple objects in each data table.


57. You can optionally include a filter in which DAX function?


CALCULATE

SUM

PICARD

COMPARE


58. Which Power BI visual is most fitting for estimating execution against an objective?


Entertainer

Projectile

Check

None of the these


59. What area do you go to change and reshape data in Power BI? 


Data Transformation

Data Editing

Question Editor

Data Modeling


60. What do you use to consolidate inquiries in Power BI? 


Join Queries

Union Queries

There is no alternative

Don't Know


61. In the recipe Total Cost = Sum('Fact'[Cost]), what kind of computation should Total Cost be according to best practice? 


Ascertained section

Measure

Variable

None of these


62. What does the accompanying DAX work compute? CALCULATE('Fact'[Total Labor Cost],'Countries'[Countries] IN { "Canada" } ) 


Add up to Labor Cost for Canada

Add up to Labor Cost for all regions in Canada

Add up to Labor Cost for all nations in Canada

Add up to Labor Cost for all nations barring Canada


63. One can Publish Power BI Desktop files to Power BI Service by clicking on which icon 

in Power BI Desktop 


Publish icon 

Save icon 

Save as icon 

export icon 


64. One can share dashboard to others in Power BI by specifying 


Access to Shared folder in power BI Desktop 

Email id fo recipient in Power BI Service 

Email id fo recipient in Power BI Desktop 

Access to Shared folder in power BI Service 


65. One can Collaborate on Power BI Desktop files  in 


DataView window 

Visualization window 

Page window 

App Workspace 


66. One Can create visualizations in 


Page Sheet 

Data Window 

relation window 

Query window 


67. Which one among  below is ranked number one in creating visualizations 


Tableau 

Qliksense 

Tableau 

SSRS 


68. Ask questions about data  through 


Natural Language query feature in Power BI service 

Natural Languagequery feature in Power BI Desktop 

Data Modelling feature in Power Bi Desktop 

Data Modelling feature in Power Bi service


69. Data can be refreshed in Power BI service by using 


Gateway

Power BI Desktop 

Apps 

Refresh service 


70.. You just deleted a dashboard in the Power BI service and want to get it back. What should you do?


Press Ctrl+Z. 

Select Undo from the toolbar.

You cannot undo the deletion of a dashboard.

Recover it from the Recycle Bin.


71. What are the group of data sources can Power BI connect to?


Files, SQL, Azure

Databases, SQL, Azure

Files, Content Packs, Connectors

Content Packs, Connectors, SQL


72. A collection of data that you import or connect to _____


Dashboards

Datasets

Reports

All of the above



Tags:

2 Comments

  1. UnknownJuly 21, 2022 at 5:47 PM

    Very Informative and creative contents. This concept is a good way to enhance knowledge. Thanks for sharing. Continue to share your knowledge through articles like these.

    Data Engineering Services 

    Data Analytics Services

    Machine Learning Services

    Data Modernization Services

    ReplyDelete
Post a Comment
Previous Post Next Post