DA-100 Exam Question 1

How should you distribute the reports to the board? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

DA-100 Exam Question 2

Your company has training videos that are published to Microsoft Stream.
You need to surface the videos directly in a Microsoft Power BI dashboard.
Which type of tile should you add?
  • DA-100 Exam Question 3

    You have a report that contains three pages. One of the pages contains a KPI visualization. You need to filter all the visualizations in the report except for the KPI visualization. Which two actions should you perform?
    Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
  • DA-100 Exam Question 4

    Case Study 1 - Litware, Inc.
    Overview
    Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports. The company plans to leverage data from Microsoft SQL Server databases, Microsoft Excel files, text files, and several other data sources.
    Litware uses Azure Active Directory (Azure AD) to authenticate users.
    Existing Environment
    Sales Data
    Litware has online sales data that has the SQL schema shown in the following table.

    In the Date table, the dateid column has a format of yyyymmdd and the month column has a format of yyyymm. The week column in the Date table and the weekid column in the Weekly_Returns table have a format of yyyyww. The regionid column can be managed by only one sales manager.
    Data Concerns
    You are concerned with the quality and completeness of the sales data. You plan to verify the sales data for negative sales amounts.
    Reporting Requirements
    Litware identifies the following technical requirements:
    - Executives require a visual that shows sales by region.
    - Regional managers require a visual to analyze weekly sales and
    returns.
    - Sales managers must be able to see the sales data of their respective region only.
    - The sales managers require a visual to analyze sales performance
    versus sales targets.
    - The sale department requires reports that contain the number of sales transactions.
    - Users must be able to see the month in reports as shown in the
    following example: Feb 2020.
    - The customer service department requires a visual that can be
    filtered by both sales month and ship month independently.
    Hotspot Question
    You need to create a visualization to meet the reporting requirements of the sales managers.
    How should you create the visualization? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

    DA-100 Exam Question 5

    Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
    After you answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
    You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars.
    You need to create a reference line to show which employees are above the median salary.
    Solution: You create an average line by using the Salary measure.
    Does this meet the goal?