DP600 Flashcards by Ante Bustruc

You need to modify your Fabric capacity. Which of the following would allow you to do this?
A) Azure Portal
B) Fabric Admin portal
C) Microsoft 365 portal
D) None of these
E) All of these

A) Azure Portal

How well did you know this?

Not at all

Perfectly

Which of the following is the most accurate definition of a Microsoft Fabric capacity?
A) A set of dedicated compute and storage resources reserved for exclusive use?
B) A set of dedicated compute resources for shared use with other tenants
C) A set of dedicated compute resources reserved for exclusive use by single tenant
D) A set of dedicated compute and storage resources for share use with other tenants

C) A set of dedicated compute resources reserved for exclusive use by single tenant

How well did you know this?

Not at all

Perfectly

You have been asked to create a new PowerBI report theme. What file format options do you have for creating this theme?
A) CSV
B) JSON
C) Parquet
D) PowerBI Theme proprietary file format
E) CSV or JSON

B) JSON

How well did you know this?

Not at all

Perfectly

You are attempting to use a Gateway to read on-prem data in a Dataflows Gen2 process. The table refresh shows as succeeding but the write to destination step is failing. What is the likely cause of this? 2 are correct
A) A protocol of HTTPS is being used
B) A protocol of TSP is being used
C) SQL Server port 1434 is being used
D) SQL Server port 1433 is being used

A) A protocol of HTTPS is being used
C) SQL Server port 1434 is being used

How well did you know this?

Not at all

Perfectly

When someone commits a new change to a connected Git branch, how are other users notified?
A) Via email to everyone having Member permission or higher in the workspace
B) Via a notification in the workspace
C) Via an email to the workspace administrator
D) Via an email to the person appointed as the Git representative in the workspace

B) Via a notification in the workspace

How well did you know this?

Not at all

Perfectly

You create a security group named C-staff. You create another security group named Finance that is nested under C-staff. You Assign the C-Staff group to the Member role of a workspace. Will everyone in C-Staff and Finance be a member in the workspace?

Yes. The nesting structure is respected when assigned a security group to a workspace Plan, Implement and Manage a Solution.

How well did you know this?

Not at all

Perfectly

You are working on a project to standardize report design for your company’s sales team. Your colleague suggests using Power BI template files (.PBIT) to streamline the process. Which of the following statements accurately describes a key feature of .PBIT files?
A) .PBIT files can store actual data, enabling users to create reports without connecting to external data sources.
B) .PBIT files can contain multiple report pages, visualizations and themes, but they cannot include underlying data models.
C) .PBIT files can be directly published to the PowerBI service, making them accessible to all users within the organization.
D) .PBIT files can be used to create new reports from scratch, even without an existing PowerBI Desktop file.
E) .PBIT files can only be shared with users who have the same veriosn of Power BI Desktop installed

B) .PBIT files can contain multiple report pages, visualizations and themes, but they cannot include underlying data models.

How well did you know this?

Not at all

Perfectly

Which Fabric capacity is equivalent to a Power BI Premium P1 capacity?
A) F 32
B) F 64
C) F 128
D) F 256

B) F 64

How well did you know this?

Not at all

Perfectly

There are only 2 activities that a person in the Admin workspace role can perform that no one else can. What are those activities?
A) Update and delete the workspace
B) Add or remove other people
C) Modify gateway connection settings
D) Publish an application for the first time

A) Update and delete the workspace
B) Add or remove other people

How well did you know this?

Not at all

Perfectly

Which of the following are not item level permission when sharing an item?
A) Read
B) Edit
C) Share
D) Contributor
E) Delete

D) Contributor
E) Delete

How well did you know this?

Not at all

Perfectly

You want to allow users to use Excel to view and interact with on-prem Power BI datasets. However, some users are saying that they are not able to do so. Which of the following could be reasons why?
A) The user must be in a Contributor role.
B) The user must be in an Admin role
C) XMLA endpoints are disabled for read-only operations.
D) Allow XMLA endpoints and Analyze in Excel with on-prem datasets is disabled at the workspace level
E)Allow XMLA endpoints and Analyze in Excel with on-prem datasets is disabled at the tenant level

E)Allow XMLA endpoints and Analyze in Excel with on-prem datasets is disabled at the tenant level

How well did you know this?

Not at all

Perfectly

Which of the following is/are true regarding XMLA endpoints?
A) By default, read-only connectivity is enabled
B) By default, read-only and read-write connectivity is enabled
C) Read-only connectivity is enabled at the tenant level by default but must be enabled at each workspace level
D) Read-Write connectivity can be enabled but isn’t by default

A) By default, read-only connectivity is enabled
D) Read-Write connectivity can be enabled but isn’t by default

How well did you know this?

Not at all

Perfectly

You share a Lakehouse with another user. Which of the following is true about the permission the user will receive?
A) ReadData permission on the SQL endpoint associated with the Lakehouse
B) ReadAll permission on all associated Apache Spark data
C) Delete permission on the Lakehouse
D) Build permission on the default semantic model
E) Access to the workspace containing the Lakehouse

A) ReadData permission on the SQL endpoint associated with the
B) ReadAll permission on all associated Apache Spark data
D) Build permission on the default semantic model

How well did you know this?

Not at all

Perfectly

You are Fabric administrator and you want to purchase a Fabric capacity that allows you to execute light Fabric workloads and also allow up to 20 users to view PowerBI reports in the most cost effective way. You decide to purchase an F64 capacity. Does this meet the goal of minimizing the cost?

No. It would be cheaper to buy F2 and 20 PowerBI Pro licenses.

How well did you know this?

Not at all

Perfectly

Where can sensitivity labels be applied?
A) Power BI Desktop
B) Power BI Service
C) Microsoft Purview
D) Microsoft 365 Portal

A) Power BI Desktop
B) Power BI Service

How well did you know this?

Not at all

Perfectly

With reserved capacity pricing you will never pay more than the agreed upon price?
A) True
B) False

A) True - When you attempt to exceed capacity limits, you are throttled.

How well did you know this?

Not at all

Perfectly

In a large organization, a Power BI developer uses the Lineage View to assess the impact of proposed changes in a data source that feeds multiple reports and dashboards. What key aspect would the Lineage View primary help to identify in this scenario?
A) The exact change in data patterns due to source modification.
B) The specific reports and dashboards that will be affected by the change in the data source.
C) The increase or decrease in data processing time due to source changes.
D) The potential security risks associated with the change in the data source.
E) The direct financial impact on the company due to changes in data source

B) The specific reports and dashboards that will be affected by the change in the data source.

How well did you know this?

Not at all

Perfectly

When using XMLA endpoints for semantic model write operations, it is recommended to enable Large Model support for model over this size:
A) 250 MB
B) 500 MB
C) 1 GB
D) 5 GB
E) 10 GB

C) 1 GB

How well did you know this?

Not at all

Perfectly

Which of the following is primary reason for applying a sensitivity label to an item in Power BI?
A) To let users know the item may contain sensitive data
B) To ensure only authorized people can access the data
C) To prevent reports and queries from accessing the data
D) To track user accounts and groups used in Microsoft Fabric permission settings

A) To let users know the item may contain sensitive data

How well did you know this?

Not at all

Perfectly

Which of the following is true:
A) Shared recipients only have access to the data warehouse shared with them and not any other items within the same workspace as the warehouse.
B) Read all data using SQL permissions gives the user granular access to items in a data warehouse
C) Shared recipients of a data warehouse are also able to re-share the data warehouse
D) If a report is built on top of a data warehouse and is shared with another recipient, the shared recipient will always be able to access the report

A) Shared recipients only have access to the data warehouse shared with them and not any other items within the same workspace as the warehouse.

How well did you know this?

Not at all

Perfectly

You have purchased a P1/F64 capacity on a reserved basis. The capacity needs to run at least 18 hours per day. You want to protect yourself (avoid being throttled) in the event of over utilizing capacity. Which of the following options would be the most cost effective and practical?
A) Scale up to a P2/F128
B) Convert your capacity to pay-as-you-go to take advantage of bursting and smoothing and pausing the capacity?
C) Utilize auto-scaling with a preset cost limit
D) Rewrite your reports that use Import mode to use DirectQuery so that few capacity units are consumed refreshing datasets

Study These Flashcards

C) Utilize auto-scaling with a preset cost limit

While examining a workspace, you notice the workspace has a state of ‘Orphaned’. What does this mean?
A) The workspace has been deleted, but not physically removed yet.
B) The workspace has been deleted and physically removed, but it remains visible for 7 days
C) The workspace is not available
D) The workspace has no admin user

Study These Flashcards

D) The workspace has no admin user

You want to see a downstream item for a particular object in a workspace, whether or not the downstream object is in the same workspace or not. Which of the following will allow you to see this?
A) Impact analysis view
B) Lineage view
C) Downstream analysis view
D) All of these

Study These Flashcards

A) Impact analysis view

When using a Gateway, which protocol must be used?
A) TCPIP
B) UDP
C) TCP
D) TDS

Study These Flashcards

C) TCP

Which of the following statements about managing users in Fabric is correct? A) Managing users is done directly in Microsoft Fabric Admin portal B) Managing users is done directly in Microsoft 365 portal C) Both A and B D) Niether A nor B

B) Managing users is done directly in Microsoft 365 portal

You want to grant a user read-only access to a workspace. Which workspace role would be best for this purpose? A) Admin B) Contributor C) Viewer D) Member E) Read-only

C) Viewer

Your organization has a central dataset that needs to be accessed and analyzed by multiple teams. You've created a robust semantic model in Power BI Desktop that accurately reflects the data structure and relationship. Which of the following methods would be most appropriate for sharing this semantic model with other users, ensuring they can create their own reports and dashboards while maintaining a single source of truth? A) Distribute copies of the Power BI Desktop file (.PBIX) to each user. B) Publish the model to the Power BI Service as a shared dataset. C) Export the model as a template file (PBIT) and share it with other users. D) Create live connections to the underlying data source in separate Power Bi Desktop files E) Embed the model directly into a SharePoint site for collaborative access

B) Publish the model to the Power BI Service as a shared dataset.

You have users telling you they are unable to export report data to Excel. What factor(s) might cause this? A) Power BI Desktop does not allow exporting to Excel B) This feature is turned off at the Tenant level C) When the report was created the export to Excel feature was turned off D) Users are attempting to export to Excel from a Matrix visual which does not support this operation

B) This feature is turned off at the Tenant level

Which of the following roles would allow you to perform the duties of a Fabric Administrator? A) Global Administrator B) Power Platform Administrator C) License Administrator D) Fabric Administrator E) User Administrator

A) Global Administrator B) Power Platform D) Fabric Administrator

Microsoft recommends enabling large model support for semantic models when enabling XMLA read-write capability. Why is this? A) Large model support will not function correctly without XMLA read-write capability B) Models over 50GB will generally operate faster C) Models over 1GB will generally operate much faster D) When using Fabric capacity XMLA read-write capabilities is required. But it is not required for a Power BI capacity

C) Models over 1GB will generally operate much faster

Which of the following types of queries does Query insights track? A) User queries B) Internal queries C) Any query executed that includes the WITH_QUERY-INSIGHTS operator included in the query statement D) None unless Query Insights is turned on in the Admin portal

A) User queries

Dataflows that use a Gateway and use a data destination feature are limited to how much time before a timeout occurs? A) 30 min B) 60 min C) 90 min D) 120 min

B) 60 min

Which of the following is not a valid place to apply sensitivity labels in Power BI? A) Datasets B) Reports C) Dashboards D) Dataflows E) Excel files exported from Power BI

E) Excel files exported from Power BI

What period of time does Query Insights allow you to view queries against a SQL endpoint? A) The last 60 days B) The last 90 days C) The last 30 days D) Unlimited

C) The last 30 days

You are tasked with configuring a new Microsoft Fabric workspace for a team of analysts. Which of the following settings would you prioritize to ensure secure and efficient collaboration? A) Enabling Azure AD integration for authentication and authorization B) Establishing workspace permissions to control access to content and resources C) Setting up deployment pipelines to automate the delivery of content to production environments D) Configuring usage quotas to manage resource consumption and cost E) Integrating with external data sources to provide access to relevant datasets

A) Enabling Azure AD integration for authentication and authorization B) Establishing workspace permissions to control access to content and resources

You want to give a co-worker permission to create, update and delete a workspace. So you put your co-worked in an Admin role. Will this accomplish your goal?

No, it will not, because the ability to create a workspace is not dependent upon workspace role. The person must be in a security group that is assigned to the Create Workspace activity in Tenant Settings, in the Admin portal.

You want to connect (or disconnect) a workspace tied to a capacity to an Azure repository for source control. Which of the following roles are able to do this? A) Capacity admin B) Power BI admin C) Workspace admin D) Any user with Contributor permissions

B) Power BI admin C) Workspace admin

When a Sensitivity label is applied to data in Power BI, when does actual encryption of data occur? A) When the data is viewed in Power BI report in the Power BI service B) When the data is viewed in Power BI Desktop C) When data is queried via a DAX expression D) When the data leaves the service such as when exporting to Excel

D) When the data leaves the service such as when exporting to Excel

Your company is migrating Power BI reporting to Fabric and needs to ensure access controls for individual users. Which of the following approaches best accomplishes this? A) Utilize Azure AD groups and map them to Fabric workspace roles B) Develop a custom Power BI extension for managing user access within Fabric C) Migrate user accounts directly from the existing platform to Fabric, including access settings D) Manually recreate user permissions for each report within Fabric workspaces

A) Utilize Azure AD groups and map them to Fabric workspace roles

Which of the following are false about a Power BI project (PBIP) file A) They can be created from the Power BI Desktop B) They can be created from the Power BI service C) Any text editor can modify the contents of a PBIP file D) Sensitivity labels are supported in PBIP files E) A PBIX file can be saved as a PBIP and PBIP file can be saved as a PBIX

B) They can be created from the Power BI service D) Sensitivity labels are supported in PBIP files

Which of the following are valid deployment pipelines permission? A) Tenant admin B) Pipeline admin C) Workspace viewer D) Workspace contributor E) Workspace admin

B) Pipeline admin C) Workspace viewer D) Workspace contributor E) Workspace admin

Which of the following are valid ways of applying a report theme in Power BI? A) Select from the available list of themes in Power BI Desktop B) Use the theme gallery in Power BI Desktop C) Customize a theme using the Customize theme dialog D) Import a custom JSON file

A, B, C, D

Which of the following is not included in Power BI Template (.PBIT) file? A) Report pages, visuals and other elements B) Data model definition C) Queries and query parameters D) All report data E) Sampling of data

B) Data model definition C) Queries and query parameters D) All report data E) Sampling of data

True or false, sensitivity label are always copied from one pipeline stage to another when a deployment is done.

False. Certain conditions must be met

You want to set up a data gateway to allow a single user to access data behind a firewall that is needed for a Power App application. You set up an On-Premises data (personal mode) gateway. Will this satisfy the requirement?

No - Only Power BI is supported with personal mode

How can a single point of failure be avoided when using a data gateway? A) Implement a data gateway cluster B) Increase the gateway's processing power C) Use a virtual private network D) Schedule regular backups

A) Implement a data gateway cluster

Which of the following roles can access a workspace's lineage view? A) Administrator B) Contributor C) Member D) Viewer E) 1, 2 and 3 only

A) Administrator B) Contributor C) Member D) Viewer

Which of the following semantic model properties are copied from one pipeline stage to another when a deployment is done? A) Role assignments B) Refresh schedules C) Credentials D) Endorsements E) None of these F) All of these

E) None of these

When a workspace is deleted, it can be restored up to a certain number of days. This is known as the retention period. Where can this be changed? A) Microsoft 365 portal B) Microsoft Fabric Admin Portal C) Workspace Setting Panel D) PowerShell only

B) Microsoft Fabric Admin Portal

You want to allow an analyst to see a workspace's lineage view along with all the data sources. You assign the analyst a Viewer role in the workspace. Will this accomplish your goal?

No. The viewer role is unable to see data sources.

DP600 Flashcards

DP600 (50 cards)