LinkedIn Microsoft Power BI Skill Assessment Answers 2021 (💯Correct)

Hello Students, Today we are going to share all week evaluation and quiz answers of LinkedIn Microsoft Power BI Skill Assessment Answers 2021 started by Coursera completely free of cost. This is a certification course for every aspiring students.

If you did not get this course for free, you can apply for financial advertisements to get this course completely free.

Coursera, India’s largest learning platform, launched millions of free courses for students every day. These courses are from various recognized university, where industry experts and professors teach in a very good manner and in a more understandable manner.

Here, you will get the LinkedIn Microsoft Power BI Skill Assessment Answers 2021 in bold color which are given below.

These are the answers to LinkedIn Microsoft Power BI Skill Assessment Answers 2021 certification course. These answers have been updated recently and are 100% correct. The final exam is on Monday, April. All answers are 100%.

LinkedIn Microsoft Power BI Assessment Answers

Q1. How do you create a chart visual in the 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

Q2. What daily sales number does this DAX measure formula calculate?
CALCULATE(SUM([Sales]) ,DATESHTD([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

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

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

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

Q7. A dataset that includes _ can be used to create a map visualization. (Select all that apply.)A. house numbers, street namesB. geospatial dataC. city names, country namesD. longitude, latitude

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

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

Q9. Power BI’s Publish to Web option allows you to embed visualizations within _____. (Select all that apply.)
A. blog postsB. email messagesC. web sitesD. text messages

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

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

  •  SWITCH
  •  IF
  •  IFX
  •  IFS

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

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

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

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

Q15. When you are creating a formula in the Power Query Editor, what does IntelliSense provide a list of? (Select all that apply.)A. columnsB. tablesC. functionsD. data sources

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

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

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

Q18. Formatting options within a visualization depend on what?

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

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

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

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

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

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

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

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

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

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

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

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

Q27. Facebook, Twilio, GitHub, and MailChimp are all examples of Power BI _____.

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

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

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

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

Q31 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

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

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

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

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

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

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

Q37. Power BI works best with tables that are _____,

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

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

Linkedin Microsoft Power BI Training, Quiz and Exam Answers Latest 2021 

Q1 :Which of these methods can be used to create a new report that can be saved in Power BI?

  • A;.Copying and editing an existing report
  • B.  Downloading a Power BI report from SharePoint and re-uploading
  • C.  Using fields from a dataset to create visualizations
  • D.  Creating a visualization in Paint or Paint 3D and uploading to Power BI

Q2 : You;ve loaded a sample dataset that includes reports and dashboards. If you later delete the sample dataset, Power BI will also _____.
Answer:
 delete the reports and dashboards

Q3: Apps for the Power Platform are available from where?

Answer: AppSource

Q4: How can a user view their uploaded data immediately in Power BI?
Answer:
 by clicking “View Dataset”

Q5 : What is an additional step a user must take in order to bring in data directly from a file that was not created in Excel, a CSV file, or Power BI desktop?
Answer:
 Get the data into Excel, a CSV or Power BI desktop model.

Q6: How can a user create a refreshable data source?
Answer:
 by storing their file in the cloud

Q7 : Which statement about formatting visualizations is true?
Answer:
 Different visualizations will have different formatting options available.

Q8 : The data you selected for visualization includes geospatial data, so Power BI created a map. You wish to present your data in columns and rows. What should you do?
Answer: Select the visualization then click on the Table visualization

Q9: How can a user change the criteria by which values are sorted within a column (highest value -> lowest vs. lowest value -> highest)?
Answer: 
Click at the top of the column.

Q10 : How does a user create a dashboard?
Answer: 
Take visualizations from reports and pin them as tiles

Q11 : What do geospatial visualizations require?
Answer: 
geospatial data (latitude, longitude)

Linkedin Microsoft Power BI Training, Quiz and Exam Answers Latest 2021 

Q1 : You;ve loaded a sample dataset that includes reports and dashboards. If you later delete the sample dataset, Power BI will also _____.
Answer:
 delete the reports and dashboards

Q2: How can a user change the criteria by which values are sorted within a column (highest value -> lowest vs. lowest value -> highest)?
Answer: 
Click at the top of the column.

Q3: How can a user create a refreshable data source?
Answer:
 by storing their file in the cloud

Q4: How can a user view their uploaded data immediately in Power BI?
Answer:
 by clicking “View Dataset”

Q5 : What is an additional step a user must take in order to bring in data directly from a file that was not created in Excel, a CSV file, or Power BI desktop?
Answer:
 Get the data into Excel, a CSV or Power BI desktop model.

Q6 : What do geospatial visualizations require?
Answer: 
geospatial data (latitude, longitude)1.Question: Apps for the Power Platform are available from where?

Answer: AppSource

Q7 : The data you selected for visualization includes geospatial data, so Power BI created a map. You wish to present your data in columns and rows. What should you do?
Answer: Select the visualization then click on the Table visualization

Q8 : Which statement about formatting visualizations is true?
Answer:
 Different visualizations will have different formatting options available.

Q9 :Which of these methods can be used to create a new report that can be saved in Power BI?

  • A;.Copying and editing an existing report
  • B.  Downloading a Power BI report from SharePoint and re-uploading
  • C.  Using fields from a dataset to create visualizations
  • D.  Creating a visualization in Paint or Paint 3D and uploading to Power BI

Q10 : How does a user create a dashboard?
Answer: 
Take visualizations from reports and pin them as tiles.

Q11 : What must be included when publishing an app? (choose one or more)
A.Dataset
B.Dashboard(s)
C.Report(s)
D.Owner’s profile photo

Q12: Use _____ to display your Power BI report in presentation mode with live filtering.
Answer:
 Power BI app for Windows 10

Q13 : What is generated when you click “Publish”?
Answer:
 a link that can be sent in email, and an HTML link that can be pasted into a blog or website

Q14: Which is true regarding publishing to the web?
Answer: 
Some items, like Arc GIS visualizations, cannot be published

Q15 : How can a user find out who has access to a report or dashboard?
Answer:
 Go to their workspace, click the Share button and choose Access.

Q16: What can you NOT do from the Power BI mobile app?
Answer: 
Remove a tile from a dashboard.

Q17: Why might a user wish to start their reports in Power BI Desktop vs Power BI Service?
Answer:
 Reports started in Power BI Desktop are “portable” and can be worked on in Power BI Service.

Q18 :If a user wishes to work with multiple data sources and connect them through relationships, which tool is best suited?
Answer: 
Power BI Desktop

Q19: Which workspaces does a user have access to in the Power BI mobile app?
Answer:
 all workspaces

Q20 : Power BI Mobile can be downloaded onto _____.
Answer:
 mobile devices, smartphones, tablets

Q21: Reducing data with the Power Query Editor would not include which of these actions?
Answer: 
Hide rows with null values.

Q22 : As a general rule of thumb, data used in Power BI should be what? (choose more than one)

A.Longer rather than wider
B.Wider rather than longer
C.More columns than rows
D.More rows than columns

Q23 : What does the mobile app’s Quick Access tab display?
Answer:
 Reports and dashboards

Q24 : If a user wishes to create a dashboard, where tool must they use?
A.Power BI Desktop
B.Power BI Service
C.Power BI Mobile

Q25 : What does “Data View” show?
Answer:
 all of the data in a dataset.

Microsoft Power BI Essential Training LinkedIn Learning Final Quiz Exam Answers 

Q1:Which role would you assign to users in a workspace so they can copy reports, as well as view and interact with items such as dashboards and reports?
Answer: 
Contributors

Q2:What is true regarding visualizations and printing?
Answer: 
Not all visualization styles (including many custom visualizations) can be successfully printed/exported.

Q3: What differentiates a CSV file from an Excel workbook?
Answer:
 CSV files are strictly data, Excel workbooks can contain multiple worksheets and additional items like titles.

Q4: How can a user resize a visualization?
Answer: 
Grab the visualization handle then drag until the desired size is reached.

Q5:When pinning a tile from dashboard B onto dashboard A, which theme is the default?
Answer: 
the theme from dashboard A

Q6:How much RAM is required by Microsoft to run Power BI?
Answer:
 1 GB

Q7:What do all visualizations that are used to create reports with Power BI have in common?
Answer: 
They are based on the same data set. 

Q8: If you unpivot data that is in a pivot table within the Power BI Desktop, what is shown?
Answer: 
the underlying rows of data

Q9: Your company is using Power BI to present information about service calls. At this point managers receive three service call reports created by different people using different datasets. You’ve been asked to create a consolidated overview. Which approach makes the most sense?

Answer: Create a dashboard using appropriate visualizations from all of the reports.

Q10: How is a dashboard different from a report?
Answer: 
A dashboard is a single page and supports natural language queries; a report can be many pages and does not support natural language queries.

Q 11: When users reset a report to its default, what happens to the report in Power BI?
Answer:
 It will return to the report level filter or page level filters that the creator or owner applied when creating the report.

Q12: Courtney wants to sign up for Power BI, but does not have an organizational email address. How should Courtney proceed with accessing Power BI?
Answer: 
Obtain and use a trial version of Office 365, which will have Microsoft.com as its extension, and then proceed to sign up for Power BI.

Q 13: The dataset you’re using for a report comes from Excel. Which of these actions in Excel will improve the performance of Power BI Q& for users? 
A.Appropriate table names

B.User-friendly column names
C.Format dates as short dates
D.Sort and filter the data by key columns

Q 14: What is true regarding data and Power BI Desktop vs. Power BI Service?
Answer:
 A user can connect to more types of data using Power BI Desktop.

Q 15: If you no longer wish to have your embed codes available to the public and proceed to delete them, when will they be deleted?
Answer:
 on the next scheduled update

Q16: Converting a table visualization to a slicer has what benefit?
Answer: 
It makes it easier to filter the report visualizations.

Q 17: The insights that Power BI gleans from a selected data set and presents to the user come in the form of _____.
Answer:
 Tiles

Q 18: How can a user delete a visual from the gallery?

Answer: Select which visual they’d like to remove under the “Delete a Visual” dropdown.

Q19: How can a user remove a favorite item from their favorites list?
Answer:
 Unmark it on the Favorites list.

Q20: How can you scan a QR code using the scanner on your Power BI Mobile app?
Answer:
 Align the code within the frame of the scanner display.

Q21 When you select a data source for your data, what will Power BI create?
Answer: 
a data set

Q22: A free subscription to Power BI Pro lasts for how many days?
Answer: 
60

Q23: QR code stands for what?
Answer: 
Quick Response Code

Q 24: Reports in Power BI _____.
Answer: 
can include funnel charts, treemaps, geospatial maps, and a variety of different visualizations

Conclusion

Quizzes can be used to generate more interest among the students who want to learn in a competitive situation. Two such quizzes that work well with students in the middle school year level include “The Hollow Square Quiz” and “The Hollow Circle Quiz.” The second quiz is called “The Student Created Quiz”, which can be used as part of the revision program. From our website the student of each group will be get quiz answers on that topic.

Leave a Comment