DA-100 무료 덤프문제 온라인 액세스

You have a large dataset that contains more than 1 million rows. The table has a datetime column named Date.
You need to reduce the size of the data model.
What should you do?

• A.Round the hour of the Date column to startOfHour.
• B.Split the Date column into two columns, one that contains only the time and another that contains only the date.
• C.Trim the Date column.
• D.Change the data type of the Date column to Text.

You have five sales regions. Each region is assigned a single salesperson.
You have an imported dataset that has a dynamic row-level security (RLS) role named Sales. The Sales role filters sales transaction data by salesperson.
Salespeople must see only the data from their region.
You publish the dataset to powerbi.com, set RLS role membership, and distribute the dataset and related reports to the salespeople.
A salesperson reports that she believes she should see more data.
You need to verify what data the salesperson currently sees.
What should you do?

• A.Use the Test as role option to view data as the salesperson's user account.
• B.Filter the data in the reports to match the intended logic in the filter on the sales transaction table.
• C.Use the Test as role option to view data as the Sales role.
• D.Instruct the salesperson to open the report in Microsoft Power Bl Desktop.

You are building a financial report by using Power BI.
You have a table named financials that contains a column named Date and a column named Sales.
You need to create a measure that calculates the relative change in sales as compared to the previous quarter.
How should you complete the measure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

정답:

Reference:
https://community.powerbi.com/t5/Desktop/Error-calculating-QOQ-using-quick-measure/m-p/547054

You need to design the data model to meet the report requirements.
What should you do in Power BI Desktop?

• A.From Power Bl Desktop, use the Auto date/time option when creating the reports.
• B.From Power Query, add columns to the Orders table to calculate the calendar quarter and the calendar month of the OrderDate column.
• C.From Power Query, use a DAX expression to add columns to the Orders table to calculate the calendar quarter of the OrderDate column, the calendar month of the OrderDate column, the calendar quarter of the ShippedDate column, and the calendar month of the ShippedDate column.
• D.From Power Query, add a date table. Create an active relationship to the OrderDate column in the Orders table and an inactive relationship to the ShippedDate column in the Orders table.

You have a Microsoft SharePoint Online site that contains several document libraries. One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.
You need to load only the manufacturing reports to a table for analysis.
What should you do in Microsoft Power Bl Desktop?

• A.Get data from a SharePoint Online list, enter the site URL, and then select Combine & Load.
• B.Get data from a SharePoint Online folder and enter the site URL. Edit the query and filter by the path to the manufacturing reports library.
• C.Get data from a SharePoint Online folder, enter the site URL, and then select Combine & Load.
• D.Get data from a SharePoint Online list and enter the site URL. Edit the query and filter by the path to the manufacturing reports library.