DP600 Flashcards
DP600
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
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
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
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
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
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.
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.
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
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
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
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
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
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
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.
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
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.
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.
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
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
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.
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
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
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
A) Impact analysis view
When using a Gateway, which protocol must be used?
A) TCPIP
B) UDP
C) TCP
D) TDS
C) TCP
