Exam (elaborations)
DA 100 - Combined Data QUESTIONS & ANSWERS 100- CORRECT
- Course
- Institution
DA 100 - Combined Data QUESTIONS & ANSWERS 100- CORRECT
[Show more]
Seller
Follow
Content preview
DA 100 - Combined Data QUESTIONS &ANSWERS 100% CORRECT
What is a Workspace? - with answers:Workspace = Sandbox
Workspaces offer the following benefits:
○Focused collaboration efforts. You can use workspaces to house reports and dashboards for
use by multiple teams.
○Ability to share and present reports and dashboards in a single environment.
○Assurance that the highest level of security is maintained by controlling who can access
datasets, reports, and dashboards.
What can the Admin workspace role do? - with answers:Add/remove other users
Publish, update, and/or share an app in a workspace
Create, edit, delete, and publish reports and content in a workspace
View and interact with reports and dashboards in a workspace
Configure data refreshes
What can the Member workspace role do? - with answers:Can complete all tasks that are
associated with admins but can't add or remove users
Cannot delete the workspace
Cannot update the metadata about the workspace
What can the Contributor workspace role do? - with answers:Cannot add or remove users
Cannot publish, update, or edit an app in a workspace unless given this ability by
admins/members
Can create, update, and publish content and reports within a workspace
Can schedule data refreshes
What can the Viewer workspace role do? - with answers:Cannot add or remove users
,Can only view a report or dashboard in a workspace
Can read data that is stored in workspace dataflows
What is an App? - with answers:App = Content Distribution
○Workspace is for collaboration, App is for distribution
You can add additional content such as SharePoint sites, PowerPoint and Forms
Think of it as a reporting pack
Currently only 1 app per workspace but this will probably be updated soon
What are usage metrics for? - with answers:Shows various metrics on the usage of your report,
including no. of views and how those people viewed the report
New Usage Metrics Report view can show metrics for all reports
You used to have to do this manually be downloading the .pbix and editing the power query
code
What workspace is needed for a deployment pipeline? - with answers:Premium Workspace
Feature
What is the development stage in the deployment pipeline? - with answers:The location in which
dashboard developers or data modelers can build new content with other developers. This stage
is first in the deployment pipeline.
What is the Test stage in the deployment pipeline? - with answers:Where a small group of users
and user acceptance testers can see and review new reports, provide feedback, and test the
reports with larger datasets for bugs and data inconsistencies before it goes into production.
What is the Production stage in the deployment pipeline? - with answers:Where an expansive
user audience can use tested reports that are reliable and accurate. This stage is the final one of
the deployment pipeline.
What is the data lineage view? - with answers:Shows the different data sources data sets reports
and dashboards and how they are linked together
, Also gives info about when datasets are last refreshed
What are dynamic reports in Power BI? - with answers:Dynamic reports are reports in which the
data can be changed by a developer according to user specifications.
One Report can be used for multiple purposes.
When are "What If Parameters" used and what are they? - with answers:Use what-if parameters
to run scenarios and scenario-type analysis on your data.
In its simplest form, you can use it as a factor to multiply forecast data by to show potential
growth.
You need to be careful as your data has to be set up in a specific way to get value out of this
feature.
Why are On Premise Gateways used for? - with answers:Connect to on-prem databases
○e.g. legacy systems
This will most likely be set up by IT, not the PwC team, but you need to know that it's available
and to pass on to IT how to configure it.
What are Power BI scheduled refreshes? - with answers:Data refreshes while you're asleep!
Only works for data in the cloud or data connected using the gateway.
Can't schedule refreshed for local excel files.
○Well, you can but it's not ideal and there are better options
What is Incremental refresh in Power BI? and why is it useful? - with answers:Incremental
refresh only pulls in the latest data or data that has changed since the last reload.
○E.g. latest sales vs HR changes
Quicker, more reliable, reduced consumption
What are the 2 ways of promoting a dataset> - with answers:Promotion, Certification
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Denyss. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $13.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
84866 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now