QUESTION: 71 Exam Topic: Mix Questions

You have a 2-GB Power BI dataset.

You need to ensure that you can redeploy the dataset by using Tabular Editor. The solution must minimize how long it will take to apply changes to the dataset from powerbi.com.

Which two actions should you perform in powerbi.com? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Enable service principal authentication for read-only admin APIs.
Connect the target workspace to an Azure Data Lake Storage Gen2 account.
Turn on Large dataset storage format.
Enable XMLA read-write.

Answer(s): C,D

Explanation:

C: Optimize datasets for write operations by enabling large models
When using the XMLA endpoint for dataset management with write operations, it's recommended you enable the dataset for large models. This reduces the overhead of write operations, which can make them considerably faster. For datasets over 1 GB in size (after compression), the difference can be significant.

D: Tabular Editor supports Azure Analysis Services and Power BI Premium Datasets through XMLA read/write.

Note: Tabular Editor - An open-source tool for creating, maintaining, and managing tabular models using an intuitive, lightweight editor. A hierarchical view shows all objects in your tabular model. Objects are organized by display folders with support for multi-select property editing and DAX syntax highlighting. XMLA read-only is required for query operations. Read-write is required for metadata operations.

Reference:

https://docs.microsoft.com/en-us/power-bi/enterprise/service-premium-connect-tools
https://tabulareditor.github.io/

Reveal Solution Next Question

QUESTION: 72 Exam Topic: Mix Questions

You have new security and governance protocols for Power BI reports and datasets. The new protocols must meet the following requirements:

New reports can be embedded only in locations that require authentication.
Live connections are permitted only for workspaces that use Premium capacity datasets.

Which three actions should you recommend performing in the Power BI Admin portal? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

From Embed Codes, delete all the codes.
From Tenant settings, disable Allow XMLA endpoints and Analyze in Excel with on-premises datasets.
From Capacity settings, set XMLA Endpoint to Read Write.
From the Premium per user settings, set XMLA Endpoint to Off.
From Tenant settings, set Publish to web to Disable.

Answer(s): B,C,E

Explanation:

B: In addition to the XMLA Endpoint property being enabled read-write by the capacity admin, the tenant-level setting Allow XMLA endpoints and Analyze in Excel with on-premises datasets must be enabled in the admin portal. If you need to generate Analyze in Excel (AIXL) files that connect to the XMLA endpoint, the tenant-level setting Allow live connections should also be enabled. These settings are both enabled by default.

Allow XMLA endpoints and Analyze in Excel with on-premises datasets is an integration setting.

C: By default, Premium capacity or Premium Per User dataset workloads have the XMLA endpoint property setting enabled for read-only. This means applications can only query a dataset. For applications to perform write operations, the XMLA Endpoint property must be enabled for read-write.

E: Disable publish to web.
You can control whether users can use the publish to the web feature. We [Microsoft] saw the excitement over our new Publish to Web feature, but we also heard the concern about potential security risk for your data. If this feature is not right for your organization, you can now switch it off in your tenant.

When you disable this option, existing publish to web embed codes will stop working, and users will not be able to create any new embed codes.

Reference:

https://docs.microsoft.com/en-us/power-bi/enterprise/service-premium-connect-tools
https://powerbi.microsoft.com/en-us/blog/power-bi-february-service-update

Reveal Solution Next Question

QUESTION: 73 Exam Topic: Mix Questions

You need to provide users with a reproducible method to connect to a data source and transform the data by using an AI function. The solution must meet the following requirement:

-Minimize development effort.
-Avoid including data in the file.

Which type of file should you create?

PBIT
PBIDS
PBIX

Answer(s): A

Explanation:

A PBIT file is a template created by Power BI Desktop, a Microsoft application used to create reports and visualizations. It contains queries, visualization settings, data models, reports, and other data added by the user.
A PBIT file acts as a Power BI template. It doesn’t include any data from your source systems.

Incorrect:
Not B: Using PBIDS files to get data
PBIDS files are Power BI Desktop files that have a specific structure, and they have a .PBIDS extension to identify it is a Power BI data source file.

You can create a PBIDS file to streamline the Get Data experience for new or beginner report creators in your organization. If you create the PBIDS file from existing reports, it's easier for beginning report authors to build new reports from the same data.

When an author opens a PBIDS file, Power BI Desktop opens and prompts the user for credentials to authenticate and connect to the data source that's specified in the file. The Navigation dialog box appears, and the user must select the tables from that data source to load into the model. Users may also need to select the database(s) and connection mode if none was specified in the PBIDS file.

From that point forward, the user can begin building visualizations or select Recent Sources to load a new set of tables into the model.

Currently, PBIDS files only support a single data source in one file. Specifying more than one data source results in an error.

Not C: A PBIX file is a document created by Power BI Desktop, a Microsoft application used to create reports and visualizations. It contains queries, data models, visualizations, settings, and reports added by the user. The PBIX file is the primary file type created by Power BI Desktop along with the . PBIT template.
When you save your Power BI files in PBIX format, if your Power BI model is in Data Import mode, then not only do you store the report structure, but also you store all the data imported from different data sources into Power BI.

Reference:

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

Reveal Solution Next Question

QUESTION: 74 Exam Topic: Mix Questions

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 question, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have the Power BI data model shown in the exhibit. (Click the Exhibit tab.)

Users indicate that when they build reports from the data model, the reports take a long time to load.

You need to recommend a solution to reduce the load times of the reports.

Solution: You recommend moving all the measures to a calculation group.

Does this meet the goal?

Answer(s): B

Explanation:

Instead denormalize For Performance.
Even though it might mean storing a bit of redundant data, schema denormalization can sometimes provide better query performance. The only question then becomes is the extra space used worth the performance benefit.

Reference:

https://www.mssqltips.com/sqlservertutorial/3211/denormalize-for-performance/

Reveal Solution Next Question

Free DP-500 Exam Braindumps (page: 25)

QUESTION: 71 Exam Topic: Mix Questions

Explanation:

Reference:

QUESTION: 72 Exam Topic: Mix Questions

Explanation:

Reference:

QUESTION: 73 Exam Topic: Mix Questions

Explanation:

Reference:

QUESTION: 74 Exam Topic: Mix Questions

Explanation:

Reference: