Microsoft DA-100 Exam Practice Questions (P. 4)
- Full Access (94 questions)
- Six months of Premium Access
- Access to one million comments
- Seamless ChatGPT Integration
- Ability to download PDF files
- Anki Flashcard files for revision
- No Captcha & No AdSense
- Advanced Exam Configuration
Question #16
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?
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?
- AIncrease the number of times that the dataset is refreshed.
- BSplit the visuals onto multiple pages.Most Voted
- CChange the imported dataset to DirectQuery.
- DImplement 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
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
send
light_mode
delete
Question #17
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?
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?
- ACreate a data alert.
- BShare the dashboard to the user.
- CCreate a subscription.Most Voted
- DTag 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
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
send
light_mode
delete
Question #18
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?
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?
- AYes
- BNoMost Voted
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
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
send
light_mode
delete
Question #19
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?
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?
- AYesMost Voted
- BNo
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
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
send
light_mode
delete
Question #20
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?
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?
- AYes
- BNo
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/
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/
send
light_mode
delete
All Pages