linkedin assessment answers

LinkedIn Microsoft Power BI Skill Assessment Answers

Certification Courses

Hello Learners, Today we are going to share LinkedIn Microsoft Power BI Skill Assessment Answers. So, if you are a LinkedIn user, then you must give Skill Assessment Test.

Any LinkedIn User-

  • Wants to increase chances for getting hire,
  • Wants to Earn LinkedIn Skill Badge🥇🥇,
  • Wants to rank their LinkedIn Profile,
  • Wants to improve their Programming Skills,
  • Anyone interested in improving their whiteboard coding skill,
  • Anyone who wants to become a Software Engineer, SDE, Data Scientist, Machine Learning Engineer etc.,
  • Any students who want to start a career in Data Science,
  • Students who have at least high school knowledge in math and who want to start learning data structures,
  • Any self-taught programmer who missed out on a computer science degree.

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

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

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

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

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

  •  SWITCH
  •  IF
  •  IFX
  •  IFS

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

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

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

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

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

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

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 tool can you use in Power BI Desktop to reduce data?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Leave a Reply