DA-100 exam

DRAG DROP You build a report about warehouse inventory data. The dataset has more than 10 million product records from 200 warehouses worldwide. You have a table named Products that contains the columns shown in the following table. Warehouse managers report that it is difficult to use the report because...

Topic 2, Contoso Ltd, Case Study Overview This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time...

You need to create relationships to meet the reporting requirements of the customer service department. What should you create?A . an additional date table named ShipDate, a one-to-many relationship from Sales[sales_date_id] to Date[date_id], and a one-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id]B . an additional date table named ShipDate, a many-to-many...

You need to address the data concerns before creating the data model. What should you do in Power Query Editor?A . Select Column distribution.B . Select the sales_amount column and apply a number filter.C . Select Column profile, and then select the sales_amount column.D . Transform the sales_amount column to...

You have a Microsoft Power BI data model that contains three tables named Orders, Date, and City. There is a one-to-many relationship between Date and Orders and between City and Orders. The model contains two row-level security (RLS) roles named Role1 and Role2. Role1 contains the following filter. City[State Province]...

HOTSPOT You have two tables named Customers and Invoice in a Power BI model. The Customers table contains the following fields: ✑ CustomerID ✑ Customer City ✑ Customer State ✑ Customer Name ✑ Customer Address 1 ✑ Customer Address 2 ✑ Customer Postal Code The Invoice table contains the following...

You are configuring a Microsoft Power Bl data model to enable users to ask natural language questions by using Q&A. You have a table named Customer that has the following measure. Customer Count = DISTINCTCOUNT(Customer[CustomerID]) Users frequently refer to customers as subscribers. You need to ensure that the users can...

DRAG DROP You have the line chart shown in the exhibit. (Click the Exhibit tab.) You need to modify the chart to meet the following requirements: ✑ Identify months that have order counts above the mean. ✑ Display the mean monthly order count. Which three actions should you perform in...

Topic 3, Misc. Questions 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...

You need to recommend a strategy to consistently define the business unit, department, and product category data and make the data usable across reports. What should you recommend?A . Create a shared dataset for each standardized entity.B . Create dataflows for the standardized data and make the dataflows available for...