FREE Microsoft DA-100 Questions and Answers
A Microsoft Excel data source's file name and location are stored in a parameter you construct called DataSourceExcel. Instead of using numerous copies of the location that are hard-coded into each query definition, you must edit the query to reference the parameter. Solution: Replace all references to the Excel file in the Power Query M code with references to DataSourceExcel. Is the objective being met?
Explanation:
Instead, change the queries' source step such that DataSourceExcel is used as the file path.
It should be noted that parameterizing a data source has numerous potential applications. from connecting to several data sources listed in the
Query Parameters to load various column combinations.
You have a Power BI dataset. The dataset must be made discoverable. Which of these two arrangements will enable the dataset to be designated as discoverable? Each accurate response offers an entire resolution. Select all applicable answers.
Please select 2 correct answers
Explanation:
Users without access can request access to a certified dataset by configuring it to be discoverable. A promoted dataset can be set up such that users who do not have access can nevertheless find it and seek access. A dataset need not have RLS in order to be discoverable. A dataset need not be premium (capacity or shared) to be discoverable.
You have a report from Microsoft Power BI. The PBIX file is 550 MB in size. By using an App workspace in a shared capacity on powerbi.com, one can see the report. One fact table from an imported dataset is used in the report. There are 12 million rows in the fact table. At 8:00 and 17:00, the dataset will refresh twice daily. The report is one page long and has 10 default visuals in addition to 15 AppSource visuals. When users access and engage with the report, they complain that the visuals take a long time to load. You must offer a suggestion for enhancing the report's functionality. What ought to you suggest?
Explanation:
DirectQuery: Power BI Desktop does not import or copy any data.
Import: Power BI Desktop imports the chosen tables and columns. The imported data is utilized by Power BI Desktop while you design or interact
with a visualization.
Features of DirectQuery -
Using DirectQuery has the following advantages:
- Whereas it would be impossible to import all the data using pre-aggregation, DirectQuery enables you to create visualizations over very big
datasets.
- Data can need to be refreshed when the underlying data changes. Reimporting data may not be possible for some reports because the requirement
to display current data may necessitate huge data transfers. In contrast, DirectQuery reports constantly employ up-to-date information.
For DirectQuery, the 1-GB dataset restriction is not an issue.
Note: This exam question comes in a variety of forms. Other inappropriate response choices for the question include the following:
Row-level security (RLS) implementation
- Increase the frequency with which the dataset is updated.
You have shared control over a Power BI workspace. The workspace includes the DS1 dataset. You intend to schedule DS1's refresh. What is the daily maximum for data refreshes?
Explanation:
For a Power BI workspace with a shared capacity, the daily maximum for refreshes is 8.
Using Microsoft Power BI, you are modeling data that includes a sizable Microsoft SQL Server table called Order with more than 100 million records. You must import a portion of the Order table's data during the development process. Solution: You modify the SQL statement by include a WHERE clause. Is the objective being met?
Explanation:
Before the data is imported, the WHERE clause takes effect.
You use Power Query Editor to generate the next step. Table.ReplaceValue(SalesLT_Address,""1318"",""1319"",Replacer.ReplaceText, ""AddressLine1"" 21318 Lasalle Street is the value for a row in the AddressLine1 column. What will the value be after applying the step?
Explanation:
For example, change the text ""ur"" to ""or"" in the table.
A SharePoint server for your business is housed in a Montreal datacenter. You intend to use Microsoft Excel files kept on the SharePoint server in a report you'll make using the Power BI service. You must suggest a way to guarantee that the dataset for the report can be updated automatically each day. What should the recommendation contain?
Explanation:
Since an on-premises SharePoint server is an on-premises data source, a Power BI gateway must be used. Connectivity to an Azure virtual network would be available via VPN-based solutions, but not the Power BI service. This situation does not apply to Azure Data Box, a solution for moving data to Azure.
Using Microsoft Power BI, you are modeling data that includes a sizable Microsoft SQL Server table called Order with more than 100 million records. You must import a portion of the Order table's data during the development process. Solution: Import the table from Power Query Editor, then add a filter step to the query. Is the objective being met?
Explanation:
After the data is imported, the filter is used.
Instead, amend the SQL query to include a WHERE clause.
You have shared control over a Power BI workspace. The workspace includes a report that makes use of the DS1 dataset. A DS1 incremental refresh must be implemented. What ought to you start with?
Explanation:
You must first design an incremental refresh policy, which calls for specifying filter parameters, before you can implement an incremental refresh of the dataset. A Premium SKU upgrade is not required for an incremental refresh policy. The last step in configuring an incremental refresh is publishing the dataset to the Power BI service, which is necessary for the incremental refresh policy to take effect.
You are working with a sizable dataset that has more than a million rows. The table contains a Date datetime field. Without sacrificing data access, the data model needs to be shrunk. What ought you to do?
Explanation:
We must separate the time and date tables. Additionally, since the time is repeated each day, we don't need to enter it in the date table.
To connect the date to the date table and the time to the time table, separate the DateTime column into distinct date and time columns in your fact
table. To ensure that every time in your data correlates to a row in your table, the time needs to be adjusted to the nearest round minute or second.
The creation of a Power BI dashboard is required. What instrument should you use?
Explanation:
Power BI dashboard creation is supported by the Power BI service. Dashboards can be seen but not made on the Power BI mobile app. Power BI dashboard creation is not supported by Power BI Desktop. The Microsoft Excel utility Power Query is used for data importation but not for dashboard creation.
You intend to certify a Power BI dataset. You must determine at what organizational level the authority to verify a dataset is delegated. Which level should you choose?
Explanation:
The Dataset Certification tenant admin setting defines the admin users who can certify a dataset.
A Power BI dashboard must be made from a published report. Which report choice should you choose?
Explanation:
You can add the visual to an existing dashboard or make a new one using the Pin visual option. You can copy a visual to the Clipboard as a picture by choosing the Copy visual as image option. You cannot construct a dashboard using the Export data option, however you may export data in the xlsx or csv formats. You cannot construct a dashboard using the Spotlight option, but you can highlight a graphic on the report page.
You use the Microsoft Power BI Service to generate a dashboard. A card visual on the dashboard displays the overall sales for the current year. Using the Viewer role on the workspace, you may provide users access to the dashboard. The user requests daily alerts for the number displayed on the card visual. Notifications must be automated. What ought you to do?
Explanation:
The dashboards, paginated reports, and report pages that are most important to you can be subscribed to by you, your coworkers, and yourself.
You can: With Power BI email subscribers, you can:
- Select the frequency of your email delivery: daily, weekly, hourly, monthly, or once per day following the initial data refresh.
- Select the frequency of the email delivery: daily, weekly, hourly, or monthly.
The majority of bespoke visuals are not supported by email subscriptions. Those bespoke images that have received certification are the lone
exception.
R-powered custom visuals are not supported at this moment in email subscribers.
You want to make a report with numerous visualizations using Power BI Desktop. You must produce a picture to illustrate the following: Users can search for values by which to filter the other visuals by using filters for other visuals on the same report page. Which type of visualization should you use?
Explanation:
The other visualizations on the page can be filtered using the slicer visualization. Users can look for values to filter using a search box that can be enabled in a slicer. A funnel visualization is a diagram with connected stages that are ordered sequentially and show the sequential movement of things from one stage to the next. On the same report page as other graphics, a matrix visualization highlights data in two or more dimensions. A chart featuring one set of numerical values along the horizontal axis and another set along the vertical axis is known as a scatter chart visualization. There is no search box available for the matrix, scatter chart, or funnel.
You are in charge of a Power BI workspace with a dataset containing sales information for your business. You design a report that shows sales information broken down by department. Row-level security must be used to guarantee that, after the report is released, only the sales data for each department's personnel will be seen. What should you do first?
Explanation:
You must first construct a role and a corresponding DAX expression before you can utilize row-level security to guarantee that after the report is published, employees in each department can only see the sales data for that department. Row-level security is not the only usage for filter parameters; the incremental refresh policy is another. The row-level security is enabled once the relevant roles are created because it needs to be deployed to the Power BI service for it to work. Row-level security can be enabled without switching to the Premium SKU.