Online Access Free Microsoft.DA-100.v2022-09-20.q130 Practice Test (Page 14)

DA-100 Exam Question 61

You have a Microsoft Power Bl report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com.
The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00. The report is a single page that contains 15 custom visuals and 10 default visuals. Users say that the report is slow to load the visuals when they access and interact with the report.
You need to recommend a solution to improve the performance of the report.
What should you recommend?

A.Implement row-level security (RLS).

B.Replace the default visuals with custom visuals.

C.Increase the number of times that the dataset is refreshed.

D.Split the visuals onto multiple pages.

DA-100 Exam Question 62

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series.
You have a Microsoft SQL Server database that contains the following tables.

The following columns contain date information:
- Date[Month] in the mmyyyy format
- Date[Date_ID] in the ddmmyyyy format
- Date[Date_name] in the mm/dd/yyyy format
- Monthly_returns[Month_ID] in the mmyyyy format
The Order table contains more than one million rows.
The Store table has a relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables.
You plan to use Power BI Desktop to create an analytics solution for the data.
You are modifying the model to report on the number of orders.
You need to calculate the number of orders.
What should you do?

A.Create a calculated column that uses the SUM(Order_ID) DAX formula.

B.Create a calculated column that uses the COUNTA(Order_ID) DAX formula.

C.Create a calculated measure that uses the SUM(Order_ID) DAX formula.

D.Create a calculated measure that uses the COUNTA(Order_ID) DAX formula.

DA-100 Exam Question 63

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?

A.Create a new aggregation that summarizes by employee.

B.Create a new group on the state column and set the Group type to List.

C.Create a new group on the state column and set the Group type to Bin.

D.Create a new aggregation that summarizes by state.

DA-100 Exam Question 64

You have the visual shown in the exhibit. (Click the Exhibit tab.)

You need to show the relationship between Total Cost and Total Sales over time.
What should you do?

A.Add a play axis.

B.Add a slicer for the year.

C.From the Analytics pane, add an Average line.

D.Create a DAX measure that calculates year-over-year growth.

DA-100 Exam Question 65

You have a data model that contains many complex DAX expressions. The expressions contain frequent references to the RELATEDand RELATEDTABLEfunctions.
You need to recommend a solution to minimize the use of the RELATEDand RELATEDTABLEfunctions.
What should you recommend?

A.Split the model into multiple models.

B.Hide unused columns in the model.

C.Merge tables by using Power Query.

D.Transpose.

Correct Answer: C

Combining data means connecting to two or more data sources, shaping them as needed, then consolidating them into a useful query.
When you have one or more columns that you'd like to add to another query, you merge the queries.
Note: The RELATEDTABLEfunction is a shortcut for CALCULATETABLE function with no logical expression.
CALCULATETABLE evaluates a table expression in a modified filter context and returns A table of values.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data Model the Data Testlet 1 Case Study 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 to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other question on this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study
To display the first question on this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
Overview
Litware, Inc. is an online retailer that uses Microsoft Power BI 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 date_id column has a format of yyyymmdd and the month column has a format of yyyymm.
The week column in the Date table and the week_id column in the Weekly_Returns table have a format of yyyyww.
The region_id column can be managed by only one sales manager.
Sales Data
Litware, Inc. is an online retailer that uses Microsoft Power BI 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.
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.
* Region 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.

Premium Bundle

Newest DA-100 Exam PDF Dumps shared by Actual4test.com for Helping Passing DA-100 Exam! Actual4test.com now offer the updated DA-100 exam dumps, the Actual4test.com DA-100 exam questions have been updated and answers have been corrected get the latest Actual4test.com DA-100 pdf dumps with Exam Engine here:

Access DA-100 Premium Version

(150 Q&As Dumps, 30%OFF Special Discount: Freepdfdumps)

Other Version: 78Microsoft.Pdfbraindumps.DA-100.v2022-04-11.by.adam.139q.pdf; 2414Microsoft.DA-100.v2022-02-11.q139; 2589Microsoft.DA-100.v2021-10-27.q136; 79Microsoft.Exam-killer.DA-100.v2021-08-10.by.werner.131q.pdf

Latest Upload: 166ACSM.020-222.v2025-09-11.q48; 156VMware.5V0-31.23.v2025-09-10.q73; 130Oracle.1z0-915-1.v2025-09-10.q24; 159Citrix.1Y0-231.v2025-09-10.q87; 134SAP.C-THR85-2505.v2025-09-09.q29; 165Adobe.AD0-E727.v2025-09-09.q76; 129Oracle.1Z0-1123-25.v2025-09-09.q20; 134SAP.C_SIGPM_2403.v2025-09-08.q20; 253EXIN.ITIL.v2025-09-08.q161; 169BCS.PC-BA-FBA-20.v2025-09-08.q45