What is this exam about?

Data analysis with Microsoft Power BI.

You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned. You build a report analyzing the internal networks of employees based on whom they send emails to. You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size. What should you do?

Correct Answer: Remove the Subject and Body columns during the import.

You use an R visual to produce a map of 500,000 customers. You include the values of CustomerID, Latitude, and Longitude in the fields sent to the visual. Each customer ID is unique. In powerbi.com, when users load the visual, they only see some of the customers. What is the cause of the issue?

Correct Answer: Too many records were sent to the visual.

You use an R visual to produce a map of 500,000 customers. You include the values of CustomerID, Latitude, and Longitude in the fields sent to the visual. Each customer ID is unique. In powerbi.com, when users load the visual, they only see some of the customers. What is the cause of the issue?

Correct Answer: Too many records were sent to the visual.

You need to create a calculated column to display the month based on the reporting requirements. Which DAX expression should you use?

Correct Answer: FORMAT('Date'[date], "MMM YYYY")

What is the minimum number of Power BI datasets needed to support the reports?

Correct Answer: two imported datasets

You need to provide a solution to provide the sales managers with the required access. What should you include in the solution?

Correct Answer: Create a security role that has a table filter on the Sales_Manager table where username = UserName().

Which DAX expression should you use to get the ending balances in the balance sheet reports?

Correct Answer: CALCULATE ( SUM( BalanceSheet [BalanceAmount] ), LASTDATE( 'Date'[Date] ) )

You have four sales regions. Each region has multiple sales managers. You implement row-level security (RLS) in a data model. You assign the relevant distribution lists to each role. You have sales reports that enable analysis by region. The sales managers can view the sales records of their region. The sales managers are prevented from viewing records from other regions. A sales manager changes to a different region. You need to ensure that the sales manager can see the correct sales data. What should you do?

Correct Answer: Manage the permissions of the underlying dataset.

You have a line chart that shows the number of employees in a department over time. You need to see the total salary costs of the employees when you hover over a data point. What are two possible ways to achieve this goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Correct Answer: Add a salary to the tooltips.

You have a line chart that shows the number of employees in a department over time. You need to see the total salary costs of the employees when you hover over a data point. What are two possible ways to achieve this goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Correct Answer: Add a salary to the tooltips.

You have multiple dashboards. You need to ensure that when users browse the available dashboards from powerbi.com, they can see which dashboards contain Personally Identifiable Information (PII). The solution must minimize configuration effort and impact on the dashboard design. What should you use?

Correct Answer: Microsoft Information Protection sensitivity labels

You need to review the data for which there are concerns before creating the data model. What should you do in Power Query Editor?

Correct Answer: Select Column profile, and then select the sales_amount column.

You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers. What should you do?

Correct Answer: Add the Weekly_Returns data to the Sales table by using RELATED DAX functions.

You have a Power BI tenant. You have reports that use financial datasets and are exported as PDF files. You need to ensure that the reports are encrypted. What should you implement?

Correct Answer: sensitivity labels

You need to create relationships to meet the reporting requirements of the customer service department. What should you create?

Correct Answer: an additional date table named ShipDate, a one-to-many relationship from Date[date_id] to Sales[Sales_date_id], and a one-to-many relationship from ShipDate[date_id] to Sales[sales_ship_date_id]

You have sales data in a star schema that contains four tables named Sales, Customer, Date, and Product. The Sales table contains purchase and ship dates. Most often, you will use the purchase date to analyze the data, but you will analyze the data by both dates independently and together. You need to design an imported dataset to support the analysis. The solution must minimize the model size and the number of queries against the data source. Which data modeling design should you use?

Correct Answer: Create an active relationship between Sales and Date for the purchase date and an inactive relationship for the ship date.

You have a dashboard that contains tiles pinned from a single report as shown in the Original Dashboard exhibit. (Click the Original Dashboard tab.) You need to modify the dashboard to appear as shown in the Modified Dashboard exhibit. (Click the Modified Dashboard tab.) What should you do?

Correct Answer: Change the dashboard theme.

Your company has employees in 10 states. The company recently decided to associate each state to one of the following three regions: East, West, and North. You have a data model that contains employee information by state. The model does NOT include region information. You have a report that shows the employees by state. You need to view the employees by region as quickly as possible. What should you do?

Correct Answer: Create a new group on the state column and set the Group type to List.

Your company plans to completely separate development and production assets such as datasets, reports, and dashboards in Microsoft Power BI. You need to recommend an application lifecycle strategy. The solution must minimize access to production assets and prevent end users from viewing the development assets. What should you recommend?

Correct Answer: Create a workspace for development and a workspace for production. From the production workspace, publish an app.

You build a report to analyze customer transactions from a database that contains the tables shown in the following table. You import the tables. Which relationship should you use to link the tables?

Correct Answer: one-to-many from Customer to Transaction

You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions that each has an HR manager. You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports. How should you provision access to the reports for the HR managers?

Correct Answer: Publish the reports in an app and grant the HR managers access permission.

You build a report to help the sales team understand its performance and the drivers of sales. The team needs to have a single visualization to identify which factors affect success. Which type of visualization should you use?

Correct Answer: Key influencers

You create a report by using Microsoft Power BI Desktop. The report uses data from a Microsoft SQL Server Analysis Services (SSAS) cube located on your company's internal network. You plan to publish the report to the Power BI Service. What should you implement ta ensure that users who consume the report from the Power BI Service have the most up-to-date data from the cube?

Correct Answer: an On-premises data gateway

What is this exam about?

Data analysis with Microsoft Power BI.

Welcome to awslagi.com – Sharing AWS, Google Cloud, Microsoft Azure IT Exams. It's free for all!

Analyzing Data with Microsoft Power BI

Analyze data with Power BI to deliver actionable insights.

4.8★★★★★(367 ratings)

13,439 studentsIntermediate

Learn to prepare, model, visualize, and analyze data using Microsoft Power BI. The exam focuses on turning business data into meaningful dashboards and reports that support decisions. This certification is valuable for analysts who want to strengthen their business intelligence skills. It helps you communicate insights clearly and support better organizational performance.

What you'll learn

Prepare data in Power BI- Build data models- Create dashboards and reports- Analyze trends- Share insights with stakeholders

DA-100

Lectures1

Quizzes0

Duration30 week

Students13,439

$20.00

📢 Unlock Full Access to Success!

"The content displayed here is a promotional preview and contains only 50% of the actual exam database. To access the complete set of updated questions, please upgrade to the Full Version."

👉 Click the button and follow the instructions to secure your full access immediately!