Microsoft DA-100考试更新：Power BI数据分析停用与PL-300替代

版权申诉

5星 · 超过95%的资源 142 浏览量更新于2024-07-05 1 收藏 3.4MB PDF 举报

微软DA-100认证考试是针对Power BI数据分析的专业认证，旨在评估考生在利用Microsoft Power BI工具进行数据管理和分析方面的技能。由于该考试将在2022年3月31日停止使用，建议转而关注PL-300：Microsoft Power BI数据分析师考试。在DA-100考试中，关注的核心内容包括但不限于： 1. 数据模型设计：考生需要理解和应用如何设计和构建可扩展的数据模型，这涉及到对Power BI的深入理解，如如何优化数据结构以减少模型大小，如问题1所示。正确答案B建议移除不必要的字段（如Subject和Body）以减小模型复杂性，仅显示报告收件人感兴趣的信息。 2. 数据清洗与转换：数据分析师需要具备清理和转换海量数据的能力，确保数据质量。在处理大量记录，如每月3000万条记录的Impression表时，应熟练运用Power BI的数据处理工具和性能优化策略。 3. 高级分析与可视化：考生需要熟悉如何使用Power BI的各种功能，如创建报表、指标、计算字段和使用高级分析技术，以便于呈现有意义的业务见解。此外，问题2提到了广告分析系统的需求，这可能涉及实时或周期性的性能指标跟踪。 4. 安全性和权限管理：了解如何设置行级安全（RLS）来保护敏感数据，如只让报告接收者看到与其发送邮件相关的分析结果，体现了数据分析师在数据隐私和安全方面的责任。 5. 数据仓库和云存储：考试要求考生对本地和云环境下的数据存储有基本的理解，这意味着需要熟悉Azure Blob Storage或SQL Server Analysis Services等Microsoft云服务的使用。 DA-100认证考试重点考察的是数据分析师在Power BI平台上的实际操作能力、业务洞察力以及数据处理和安全策略。随着考试的停用，学习和准备PL-300考试将更加适合当前的市场需求。备考时，关注最新的Power BI功能更新、最佳实践和实际案例，以及相关课程和练习题，有助于提高考试通过率。

Reference:

https://docs.microsoft.com/en-us/powerquery-m/table-replacevalue

Question #16Topic 1

You have a Microsoft Power BI 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 AppSource 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. Increase the number of times that the dataset is refreshed.

• B. Split the visuals onto multiple pages.

• C. Change the imported dataset to DirectQuery.

• D. Implement row-level security (RLS).

Correct Answer: C

DirectQuery: No data is imported or copied into Power BI Desktop.

Import: The selected tables and columns are imported into Power BI Desktop. As you

create or interact with a visualization, Power BI Desktop uses the imported data.

Benefits of using DirectQuery -

There are a few benefits to using DirectQuery:

✑ DirectQuery lets you build visualizations over very large datasets, where it would

otherwise be unfeasible to first import all the data with pre-aggregation.

✑ Underlying data changes can require a refresh of data. For some reports, the need

to display current data can require large data transfers, making reimporting data

unfeasible. By contrast, DirectQuery reports always use current data.

The 1-GB dataset limitation doesn't apply to DirectQuery.

Note:

There are several versions of this question in the exam. The question can have other

incorrect answer options, include the following:

✑ Implement row-level security (RLS)

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

Reference:

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery

Question #17Topic 1

You create a dashboard by using the Microsoft Power BI Service. The dashboard

contains a card visual that shows total sales from the current year.

You grant users access to the dashboard by using the Viewer role on the workspace.

A user wants to receive daily notifications of the number shown on the card visual.

You need to automate the notifications.

What should you do?

• A. Create a data alert.

• B. Share the dashboard to the user.

• C. Create a subscription.

• D. Tag the user in a comment.

Correct Answer: C

You can subscribe yourself and your colleagues to the report pages, dashboards, and

paginated reports that matter most to you. Power BI e-mail subscriptions allow you to:

✑ Decide how often you want to receive the emails: daily, weekly, hourly, monthly, or

once a day after the initial data refresh.

✑ Choose the time you want to receive the email, if you choose daily, weekly, hourly,

or monthly.

Note: Email subscriptions don't support most custom visuals. The one exception is

those custom visuals that have been certified.

Email subscriptions don't support R-powered custom visuals at this time.

Incorrect Answers:

A: Set data alerts to notify you when data in your dashboards changes beyond limits

you set.

Reference:

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-report-subscribe

https://docs.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts

Question #18Topic 1

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 section, you will NOT be able to return to it. As a

result, these questions will not appear in the review screen.

You are modeling data by using Microsoft Power BI. Part of the data model is a large

Microsoft SQL Server table named Order that has more than 100 million records.

During the development process, you need to import a sample of the data from the

Order table.

Solution: From Power Query Editor, you import the table and then add a filter step to the

query.

Does this meet the goal?

• A. Yes

• B. No

Correct Answer: B

The filter is applied after the data is imported.

Instead add a WHERE clause to the SQL statement.

Reference:

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial

Question #19Topic 1

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 section, you will NOT be able to return to it. As a

result, these questions will not appear in the review screen.

You are modeling data by using Microsoft Power BI. Part of the data model is a large

Microsoft SQL Server table named Order that has more than 100 million records.

During the development process, you need to import a sample of the data from the

Order table.

Solution: You add a WHERE clause to the SQL statement.

Does this meet the goal?

• A. Yes

• B. No

Correct Answer: A

The WHERE clause has its effects before the data is imported.

Reference:

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial

Question #20Topic 1

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 section, you will NOT be able to return to it. As a

result, these questions will not appear in the review screen.

You create a parameter named DataSourceExcel that holds the file name and location

of a Microsoft Excel data source.

You need to update the query to reference the parameter instead of multiple hard-coded

copies of the location within each query definition.

Solution: In the Power Query M code, you replace references to the Excel file with

DataSourceExcel.

Does this meet the goal?

• A. Yes

• B. No

Correct Answer: B

Instead modify the source step of the queries to use DataSourceExcel as the file path.

Note: Parameterising a Data Source could be used in many different use cases. From

connecting to different data sources defined in Query Parameters to load different

combinations of columns.

Reference:

https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/

Question #21Topic 1

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 section, you will NOT be able to return to it. As a

result, these questions will not appear in the review screen.

You create a parameter named DataSourceExcel that holds the file name and location

of a Microsoft Excel data source.

You need to update the query to reference the parameter instead of multiple hard-coded

copies of the location within each query definition.

Solution: You modify the source step of the queries to use DataSourceExcel as the file

path.

Does this meet the goal?

• A. Yes

• B. No

Correct Answer: A

Parameterising a Data Source could be used in many different use cases. From

connecting to different data sources defined in Query Parameters to load different

combinations of columns.

Reference:

https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/

Question #22Topic 1

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 section, you will NOT be able to return to it. As a

result, these questions will not appear in the review screen.

You create a parameter named DataSourceExcel that holds the file name and location

of a Microsoft Excel data source.

You need to update the query to reference the parameter instead of multiple hard-coded

copies of the location within each query definition.

Solution: You create a new query that references DataSourceExcel.

Does this meet the goal?

• A. Yes

• B. No

Correct Answer: B

Instead modify the source step of the queries to use DataSourceExcel as the file path.

Note: Parameterising a Data Source could be used in many different use cases. From

connecting to different data sources defined in Query Parameters to load different

combinations of columns.

Reference:

https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/

Question #23Topic 1

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 section, you will NOT be able to return to it. As a

result, these questions will not appear in the review screen.

You are modeling data by using Microsoft Power BI. Part of the data model is a large

Microsoft SQL Server table named Order that has more than 100 million records.

During the development process, you need to import a sample of the data from the

Order table.

Solution: You add a report-level filter that filters based on the order date.

Does this meet the goal?

剩余158页未读，继续阅读

xueyunshengling

粉丝: 564
资源: 3018

Microsoft DA-100考试更新：Power BI数据分析停用与PL-300替代

DP-300认证T.docx

PL-200认证考试题库（英文原版）

PL-900必过考试真题.docx

DA-100最新认证考试题.docx

DA-100认证考试题库.docx

Exam-DA-100-ADWM-Power-BI:考试DA-100的路径

DA-100-Analyzing-Data-with-Power-BI

DA-100_130Q

MS-DA-MIL-CNN:MS-DA-MIL-CNN

da-c-gnome3:da-c-gnome3

最新资源