LinkedIn skill assessment answers and questions — Microsoft Power BI

“Data analysis is at the heart of informed decision-making in today’s business landscape. Microsoft Power BI is a powerful tool that empowers professionals to turn data into actionable insights. W tym poście na blogu, we’re thrilled to present a comprehensive set of umiejętność ocena pytania oraz odpowiedzi Najszybszy sposób instalacji za pomocą Virtualbox Microsoft Moc BI.

Whether you’re a data enthusiast, a business analyst, or a seasoned professional, this resource is designed to enhance your proficiency in Power BI and help you unleash the full potential of your data. Join us as we delve into the world of data visualization, analityka, and business intelligence, and take the first step towards mastering Microsoft Power BI.”

Q1. 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

Q2. 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

Q3. 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

Q4. You are creating a report in Power BI Desktop and want to restrict the data to records where Country=”Kanada”. Aby to osiągnąć, what do you need to create?

• a directive
• a custom column
• an indexed column
• parametr

UWAGA: The Power BI Documentation does not mention the word directive. The correct answer is B, NOT A!

Q5. 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.

Q6. 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

Q7. 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 (np., 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.

UWAGA: To enter a specific custom color (np., required color) you need to enter the required hex value. The correct answer is D.

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

• PRZEŁĄCZNIK
• Używaj wbudowanych funkcji SQL w PL/SQL i sekwencji w wyrażeniach PL/SQL
• IFX
• IFS

UWAGA: DAX does not have IFX or IFS functions. The correct answer is B.

Pytanie 9. Consider the Power BI extract, przekształcać, and load process (ETL). Podczas tego procesu, data is read and then

• stored in SQL Server
• written to an OLAP cube
• assigned a data type
• sorted by primary key

Odniesienie

Pytanie 10. 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

UWAGA: Documentation talks about blog posts, strony internetowe, emails or social media, but never mentions text messages. Correct answer is C

Pytanie 11. 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

proof link

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

• filter and group
• sort and filter
• sortować, filtr, and group
• sort and group

UWAGA: Power BI won’t group your text, but it does filter and sort it.

Pytanie 13. You just deleted a dashboard in the Power BI service and want to get it back. Co powinieneś zrobić??

• Press Ctrl+Z.
• Select Undo from the toolbar.
• You cannot undo the deletion of a dashboard.
• Recover it from the Recycle Bin.

UWAGA: You cannot undo the deletion of a dashboard in PowerBI Service. The links that were previously provided addressed PowerBI Desktop, not PowerBI Service.

Pytanie 14. 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; dane
• dane; lookup
• dane; wspierający

Pytanie 15. 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

Pytanie 16. 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.

Pytanie 17. One of your data columns includes the city, stan, 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

Pytanie 18. Formatting options within a visualization depend on what?

• the visualization you are formatting
• the editor you use
• the visualization group
• your permissions

proof link

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

• report editor
• Power Query Editor
• panel
• data modeler

UWAGA: Data gets processed and reduced in the Power query editor. Corect answer is B.

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

• Azure data
• file data
• relationships data
• database data

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

• Pliki Excel
• comma-separated value (CSV) akta
• Power BI Desktop files
• wszystkie te odpowiedzi

Pytanie 22. What does Power BI Premium provide?

• Power BI Report Server
• report sharing without a per-user licens
• wszystkie te odpowiedzi
• dedicated capacity for your company

Pytanie 23. 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?

• wyświetlenia
• filtry
• bookmarks
• slicers

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

• wszystkie te odpowiedzi
• Remove unnecessary field labels.
• Select the most appropriate visualization.
• Use borders.

Pytanie 25. 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
• żadna z tych odpowiedzi
• Shrink to Fit
• szablony

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

• Spotlight
• Highlight
• Magnify
• None of the answers

Pytanie 27. What does My Workspace on powerbi.com include?

• Visualizations and a fields list
• Toolbars and preferences
• Workbooks and visualizations
• Dashboards and reports

Pytanie 28. 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
• Upadek

Pytanie 29. 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

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

• online services
• Wiki data sources
• database data sources
• File data sources

Pytanie 31. 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

Pytanie 32. 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

Pytanie 33. 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

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

• Power KPI
• funnel chart
• waterfall chart
• ArcGIS map

Pytanie 35. 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

Pytanie 36. 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.

Pytanie 37. 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
• PRZEŁĄCZNIK

Pytanie 38. 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 _ funkcjonować.

• Orders; DISTINCTCOUNT
• Klienci; Utwórz jednostki z pliku CSV
• Orders; Utwórz jednostki z pliku CSV
• Klienci; DISTINCTCOUNT

Pytanie 39. Power BI works best with tables that are _,

• short and wide
• long and skinny
• short and skinny
• long and wide

Q40. 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?

• wykres słupkowy
• wykres bąbelkowy
• wykres liniowy
• wykres punktowy

Wyjaśnienie: As both of the columns have numeric data, we will use a scatter chart and apply them in X-axis and Y-axis

Pytanie 41. 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.

Pytanie 42. Ogólnie, what is the best way to shape your data for Power BI?

• User a star schema.
• Load all tables from the data source.
• wszystkie te odpowiedzi
• Include multiple objects in each data table.

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

• Utwórz jednostki z pliku CSV
• SUM
• PICARD
• COMPARE

Pytanie 44. Which feature is not in the Power BI Admin portal?

• usage metrics
• organization visuals
• Dashboard Manager
• audit logs

Pytanie 45. You want to count the number of products in the Products data table. Which DAX function works best?

• RECOUNT
• COUNTUNIQUE
• COUNTX
• Utwórz jednostki z pliku CSV

Pytanie 46. You have just pinned a visualization to a new dashboard. Before you can add another visualization, what must you do?

• Save it.
• Name it.
• Refresh it.
• Publish it.

Pytanie 47. You can create a live connection to _ .

• Dynamika 365
• Ponieważ analityk ds. operacji bezpieczeństwa zużywa wydajność operacyjną tych narzędzi,
• wszystkie te odpowiedzi
• SQL Server Analysis Services

Pytanie 48. What is the purpose of this code?

ProductCount = COUNT(Products[ProductID])

• It is part of the documentation
• It creates and formats a measure called ProductCount
• It creates a measure called ProductCount
• It calculates the value for an existing measure named ProductCount

Pytanie 49. Your computer rental dataset includes columns for StartTime, EndTime, and PerHourRate. What two DAX functions could you use to calculate the total earned for rentals?

• DATEDIFF and SUM
• DATEDIFF and SUMX
• TIMEDIFF and SUM
• TIMEDIFF and SUMX

Q50. Which Q&A feature helps you ask questions and refine your visualization?

• error dialogs
• autocomplete
• wszystkie te odpowiedzi
• tooltips

Pytanie51. What does Power BI Desktop do when it cannot create a standard map visualization with the available data?

• It sends the data to the Power BI service
• It returns an error
• It sends the data to Bing
• It substitutes a column chart

Pytanie52. Bookmarks capture the state of a page. What does this capture state include?

A. sorting
B. filtering
C. current selection
D. properties of visuals

• A, b
• A, b, C
• A, b, C, D
• A, b, D

Pytanie53. Your company’s national maintenance team is divided into 12 regiony, and the Issues report they use is filtered by the user’s region. What report modification would help technicians while using the mobile app on the road? (Select all that apply.)

A. Add a geographic filter to City.
B. Add a geographic filter to State.
C. Add a geographic filter to Street Address.
D. Add a geographic filter to Country.

• A, b, D
• A, b, C, D
• A, b, C
• A, b

Pytanie54. What does the usage metric “Most Consumed Dashboards by Users” Ostatecznym celem planu jest zapewnienie, że edukacja odgrywa kluczową i pozytywną rolę w krajowej agendzie rozwoju oraz we wspieraniu integracji międzynarodowych celów rozwoju w tej agendzie? (Select all that apply.)

A. the person who built the dashboard
B. other people who share the dashboard
C. users who consume the dashboard in a content pack
D. individual user downloads of the dashboard

• A, b, C, D
• A, b, C
• A, D
• b, C, D

Pytanie55. How can you allow users to filter an entire report to display information for the last week, last two weeks, or last month?

• Add a date field to the report filter area and set filtering to Relative date filtering.
• wszystkie te odpowiedzi
• Add a date field to the page filter area, set filtering to Relative date filtering and click Extend.
• Add a slicer for a date field to the report. Click the upper right corner and select Relative.

Pytanie56. A group admin for an app workspace cannot _ in their workspace.

• remove users from the group
• manage group membership
• add users to the group
• remove users from Power BI

Pytanie57. Ogólnie, you should not add DAX calculated columns to your data moder if you are able to do what?

• wszystkie te odpowiedzi
• Create the columns in Power Query during data load
• Create a measure instead
• Have it added to the data source

Pytanie58. In the Power BI service, accessing a dataset for an uploaded Power BI file allows you what capabilities?

• the ability to see all of the dataset only in Power BI cloud services, but not in Power BI Desktop
• front-end access to all data queries within this source without the ability to make back-end changes
• connections to all the data queries and the ability to make ETL modifications to existing data
• the option to select a single query from within the dataset and build new ETL processes form it

Pytanie59. What is the recommended level of security for data extensions?

• Prompt the user before load
• Allow any extension to load without warning
• Allow only certified extensions to load
• Load certified extensions and prompt the user for noncertified extensions

Q60. Your data model includes a Members data table and ten other tables, including these the lookup tables with unique IDs: Miasto, Państwo, and Country. How can you improve your data model for Power BI?

A. Combine City, State, and Country into one lookup table
B. Move City, State, and Country to the Member table
C. Combine City and State into one lookup table and remove the Country table
D. Leave the model as it is.

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

Q61. Before you can use a custom visualization from the Power BI Marketplace, you need to ____ w, następnie __ it to your Power BI account.

• Ściągnij; upload
• purchase; import
• purchase; upload
• upload; Ściągnij

Q62. You have two Excel spreadsheets with data from separate reporting units. Both spreadsheets have the same column names. What Power Query Editor feature can you use to create a unified dataset?

• Unify
• Append
• Merge
• Grupa

Q63. Power BI Q&A chooses the best visualization based on data type – na przykład, a ** chart for date data and a ** for state/province data.

• column; mapa
• linia; mapa
• oś czasu; mapa
• linia; column

Q64. In Power BI, what is the most important difference between tables related in a star schema and in a snowflake schema?

• A snowflake schema cannot be modeled in Power BI.
• A snowflake schema can be modeled only in Power BI service.
• A snowflake schema is much less efficient for Power BI.
• A snowflake schema has more levels of lookup tables.

Q65. What are benefits of modifying your Excel data source in the Power Query Editor rather than in Excel?

A. You can track the changes you make.
B. It is less error prone than manual editing.
C. It will not affect other users of the spreadsheet.
D. It "locks down" the spreadsheet columns in Excel.

• A, b, C
• A, b, C, D
• A, C, D
• b, D

Q66. Your report is based on imported data from Excel. What is a valid reason to use a slicer rather than a report-lever filter?

A. A slicer makes it easier for users to filter
B. Users should be able to see both filtered and nonfiltered values.
C. ????????

• A i B
• B and C
• A and C
• There is no reason to use a slicer rather than a report-level filter.

Q67. Within Power BI, how can a report be created?

• directly from a dataset
• starting with an existing report and editing it
• using an existing report
• wszystkie te odpowiedzi

Q68. In the Power BI service, filters are applied in what view?

• Filtr
• Editing
• Czytanie
• Query

Q69. What are the first steps you take to connect to an Access database data source in Power BI?

• You cannot to an Access database from Power BI.
• Kliknij Raporty > Baza danych > Łączyć in Power BI Desktop
• Kliknij Get Data > Baza danych > Dostęp do bazy danych > Łączyć in Power BI Service
• Kliknij Get Data > Baza danych > Dostęp do bazy danych > Łączyć in Power BI Desktop

Q70. What can you use Power BI for?

• wszystkie te odpowiedzi
• to create visualizations
• to model data
• to generate reports

Q71. What is the primary purpose of the Relationship view in Power BI Desktop?

• to transform data
• to add members to your team or group
• to grant permission to view a specific table
• to relate tables

Q72. What do you call a visualization that has the single purpose of filtering other visuals in the view?

• wodospad
• żadna z tych odpowiedzi
• ArcGIS visual
• slicer

Q73. To share a dashboard and your comments from a mobile device, _ the dashboard.

• comment and share
• annotate and share
• publikować
• team share

Q74. In the Power Query Editor, you have selected multiple columns. How do you set them all to the Whole Number data type?

• Kliknij Data Type Any i wybierz Whole Number.
• Wybierz Group By i wybierz Whole Number.
• Right-click the primary key and select Whole Number.
• Right-click any column and select Format Data

Q75. When will links to a web-published report stop working?

• approximately one hour after the report is deleted
• approximately one month after the report is deleted
• co niestety może się zdarzyć w wyniku urazu fizycznego, a także niektórych pasożytów i chorób
• approximately one week after the report is deleted

Q76. What are the first steps to connect to a data table on Wikipedia from Power BI Desktop?

• Get Data > OData feed > Web URL
• Get Data > Sieć > Enter Web URL
• Get Data > Web Table > Enter Web URL
• Get Data > Data Source > Enter Web URL

Q77. In the Power Query Editor, what command do you use to remove a symbol - na przykład, a # that appears in every data now of the selected column?

• Transform > Replace Values
• Transform > Remove Text
• Transform > Remove Values
• Transform > Replace Errors

Q78. Which type of visualization is best when you want to compare proportions in a large volume of data with multiple categories and subcategories?

• donut chart
• gauge chart
• treemap
• wodospad

Q79. Of the Power BI tools, only Power BI Desktop allows you to do what?

• wszystkie te odpowiedzi.
• Work offline.
• Create data models.
• Add DAX calculations.

Q80. What does the Power BI Advanced Editor allow you to do? (Select all that apply.)

A. Access the advanced editing commands.
B. View the M code created by the Power Query Editor.
C. Enter M code to shape your data.
D. Edit the M code created by the Power Query Editor.

• A, b
• A,b,C,D
• b,C,D
• A,b,C

Q81. Why might you use the DAX DIVIDE function rather than a forward slash (/) when creating a measure? (Select all that apply.)

A. DIVIDE does not raise an error when the denominator is zero.
B. DIVIDE is faster.
C. A forward slash does not work with text columns.
D. DIVIDE stores the numerator and denominator locally.

• A,b,C,D
• A,b
• b,C
• A

Q82. when creating a new relationship between the Continents and Countries tables, this error is returned: “One of the columns must have unique values.” How can you fix this? (Select all that apply.)

A. Add another table with unique keys
B. Remove duplicate rows so the Countries table has a column with unique IDs
C. Remove duplicate rows so the Continents table has a column with unique IDs.
D. Correct the cardinality of the relationship

• A, C, D
• b, C
• A, b
• b, C, D

Proof link

P83. Your report is based on imported data from Excel. What is a valid reason to use a slicer rather than a report-level filter?

A. A slicer makes it easier for users to filter.
B. Users should be able to see both filtered and unfiltered values.
C. Query speed is critical.

• B and C
• A i B
• There is no reason to use a slicer rather than a report-level filter.
• A and C

Q84. You have pinned a bar chart visualization to a dashboard. If you then modify the bar chart in the underlying report, what will the dashboard display?

• It will display nothing. You will need to re-pin the bar chart to the dashboard.
• It will display the bar chart as it appears in the report now.
• It will display an error message where the bar chart had been pinned.
• It will display the bar chart as it appeared when it was pinned.

Q85. In the Power Query Editor, how do you add an index column to an existing dataset?

• On the Transform tab, click Add Column > Indeks.
• On the Add Column tab, click Add Index Column.
• żadna z tych odpowiedzi
• Na karcie Strona główna, click Add Index Column.

Q86. Power BI desktop has a _ narzędzie, found under the View tab, which can be used to record the time taken for each of the processes required to render a report to complete.

• Simulation
• Performance Analyzer
• Reporting Analytics
• DAX Studio

P87. When you are looking for outliers, Z-scores above _ are a good starting point.

• 30
• 3
• 10
• 100

P88. In DAX, a semi-additive measure can accumulate values over some dimension, but typically not _.

• obliczenia
• czas
• magnitude
• wskaźnik

P89. In Power BI’s Power Query Editor, a field data type shown as _ means the money data type.

• a pile of coins icon
• Jak działa pulsoksymetr
• $
• a stack of bills icon

Q90. Which of the following choices is not a viewing option in the view selector of Power BI Desktop?

• report view
• model view
• query view
• data view

Q91. Which value for the type parameter in the DAX function PATHITEM indicates integer?

• 0
• “Liczba całkowita”
• PRAWDA
• 1

Q92. Which type of chart in Power BI is beneficial for helping you visualize data over time?

• pie charts
• stacked column charts
• tree maps
• line charts

Q93. To combine multiple tables into a single table in Power BI, Użyj _ tool in the query editor.

• Append
• Combine
• Query
• Raport

Q94. Which time intelligence function in DAX can be used for seeing month-on-month data?

• ParallelPeriod
• TotalYTD
• SamePeriodLastYear
• MonthOnMonth

Q95. Which part of Microsoft’s data gateway’s configuration allows you to switch between TCP and HTTPS modes?

• Diagnostics
• Service settings
• Connectors
• Network

Q96. You pinned an Excel pivot table to a dashboard. What will other users be allowed to do with this visualization?

• View the pivot table.
• wszystkie te odpowiedzi
• Rearrange pivot table fields.
• Drill down in the pivot table.

Q97. You pinned an Excel pivot table to a dashboard. What will other users be allowed to do with this visualization?

• drill down in the pivot table.
• Rearrange pivot table fields.
• view the pivot table
• wszystkie te odpowiedzi

Q98. Using Power BI service, you want to share a set of visualizations with your team so that they can, z kolei, share the content with others. „Ich negatywne postawy i opinie są jadowite i zaraźliwe”. A Angel uważa, że ​​powinieneś zrobić wszystko, co w twojej mocy, aby zostawić tego typu ludzi w tyle, aby odjąć zło i dodać dobro, what should you share?

• a report
• a tile
• a dashboard
• wszystkie te odpowiedzi

Q99. What is true about paginated reports? (Wybierz wszystkie pasujące)

A. They are formatted to fit well on a page.
B. They shrink the report data to fit on a page.
C. They truncate the report data to fit on a single page.
D. They are both printable and shareable.

• A, D
• B or C, both on user choice
• A. b, D
• A, C, D

odniesienie

Q100. What is the primary function of the Power Query Editor in Power BI?

• Modelowanie danych
• Data transformation and preparation
• Wizualizacja danych
• Data sharing and collaboration

Q101. What is the purpose of DAX (Data Analysis Expressions) in Power BI?

• To create visualizations
• To design data models
• To perform advanced data calculations and aggregations
• To connect to external data sources

Q102. In Power BI, what is a “calculated column” used for?

• It’s a calculated measure used in visuals.
• It’s a calculated field that aggregates data.
• It’s a column that you add to a table with a formula.
• It’s a column that displays hierarchical data.

Pytanie 103. Which type of Power BI visual is most suitable for comparing values across categories using bars of varying lengths?

• Line chart
• Scatter plot
• Pie chart
• Bar chart