Course quiz: Deploy and maintain Power BI assets :Deploy and Maintain Power BI Assets and Capstone project (Microsoft Power BI Data Analyst Professional Certificate) Answers 2025
Question 1
Importance of data-driven decision-making kya hai?
❌ It is a regulatory requirement
✅ It involves using insights from data to guide strategic decisions.
❌ It is mainly focused on customer satisfaction
Explanation:
Data-driven decision-making ka matlab hai data insights ke basis par strategy banana, na ki assumptions par.
Question 2
SQL ka primary function kya hai?
❌ To index unstructured data
✅ To facilitate managing and querying structured data in tables.
❌ To create visualizations
Explanation:
SQL ka use structured tables me data ko query aur manage karne ke liye hota hai.
Question 3
Power BI me parameters ka role kya hai?
✅ They enable customization of reports based on user inputs.
❌ They standardize reports
❌ They automate reports without users
Explanation:
Parameters reports ko dynamic aur flexible banate hain.
Question 4
Personal workspace ka primary purpose kya hai?
❌ Individual visualization customization
✅ To work on projects privately and maintain control.
❌ Testing before sharing
Explanation:
Personal workspace individual user ke liye private space hota hai.
Question 5
Microsoft 365 group + SharePoint library ko Power BI workspace se connect kaise karte hain?
❌ System storage
✅ Workspace OneDrive
❌ Azure connection
Explanation:
Workspace OneDrive se M365 group aur SharePoint integrate hota hai.
Question 6
Power BI license upgrade kis tab se hota hai?
❌ System storage tab
❌ About tab
✅ Premium tab
Explanation:
License aur capacity settings Premium tab me hoti hain.
Question 7
Power BI App kyu useful hai?
❌ Increase processing speed
✅ Streamline sharing and distribution of content.
❌ Improve graphic design
Explanation:
Apps ka use hota hai controlled aur easy distribution ke liye.
Question 8
User multiple audiences me ho to kya hota hai?
❌ Summary view of all audiences
❌ Prompt to select audience
✅ A new navigation layer is added.
Explanation:
Power BI multiple navigation options show karta hai.
Question 9
Workspace Metrics Preview ka main benefit?
❌ User interaction deep analysis
❌ Enhanced security
✅ Broad insights into workspace and report usage.
Explanation:
Ye feature overall usage analytics deta hai.
Question 10
Power BI dataflows ke functions (Select all):
✅ Collect data from various sources
✅ Transform and clean data
✅ Load processed data into datasets
❌ Visualization tool
Explanation:
Dataflows = ETL (Extract, Transform, Load) layer.
Question 11
On-premises data gateway ka main function?
❌ Security analytics
❌ Cost minimization
✅ Allow data refresh & sharing between on-prem and Power BI service
Explanation:
Gateway on-prem data ko Power BI Service se connect karta hai.
Question 12
Content promotion ka main goal?
❌ Collaboration
❌ Certification prep
✅ Highlight valuable content for organization
Explanation:
Promoted content = trusted & recommended content.
Question 13
Deployment Pipelines lifecycle ke benefits (Select all):
✅ Data Integrity
❌ Data Safety
❌ Increased Deployment Speed
✅ Efficiency and Control
Explanation:
Lifecycle se controlled, reliable deployments hote hain.
Question 14
Deployment history monitor karne ke benefits (Select all):
✅ Identify who deployed & outcome
✅ Ensure data integrity
❌ Auto rollback
✅ Track changes during deployment
Question 15
Lineage View ka main benefit?
✅ Visual depiction of relationships between data elements
❌ Data quality analysis
❌ Real-time streaming
Question 16
Query caching kis mode me hoti hai?
❌ Import
❌ Live Connection
✅ DirectQuery mode
Question 17
Sensitive data access ensure kaun karta hai?
❌ Authentication only
✅ Row-level security (RLS)
❌ Data masking
Question 18
Monthly internal newsletters ke liye sahi label?
❌ Public
✅ General
❌ Highly Confidential
Question 19
Read permission user ko kya allow karta hai?
✅ View datasets without changing content
❌ Share datasets
❌ Build reports
Question 20
Sharing links ke benefits (Select all):
❌ Auto build/edit access
✅ Expiration dates
✅ Authentication for external users
✅ Limit access to specific users
Question 21
Dynamic RLS ka drawback?
❌ Storage increase
✅ Performance impact due to real-time filtering
❌ Visualization limits
Question 22
Dynamic RLS kab better hai?
❌ Fixed roles
❌ Manual updates
✅ Frequent role & access changes
Question 23
User apni region ke bahar ka data access kare to?
✅ They see blank visuals
❌ Logged out
❌ Access upgraded
Question 24
USERPRINCIPALNAME function ka purpose?
❌ Manage roles
❌ Define roles
✅ Retrieve user email for filtering data
Question 25
Subscriptions se kaunsi efficiency improve hoti hai? (Select all)
✅ Reduce time searching for reports
✅ Create routine data consumption
❌ Real-time editing
❌ Report generation automation
Question 26
Data alerts proactive decision-making me kaise help karte hain?
✅ Quick intervention
✅ Early warnings
❌ Suggest solutions
❌ Cost saving identification
Question 27
Publish content but no user management → kaunsa role?
❌ Admin
❌ Viewer
✅ Contributor
Question 28
Total report views ke liye kaunsa usage page?
❌ Report performance
❌ FAQ
✅ Report usage page
Question 29
Build permission se foundational data modify hota hai?
❌ True
✅ False
Question 30
General sensitivity label external sensitive data ke liye hota hai?
❌ True
✅ False
🧾 Final Summary Table
| Q | Answer |
|---|---|
| 1 | B |
| 2 | B |
| 3 | A |
| 4 | B |
| 5 | B |
| 6 | B |
| 7 | B |
| 8 | B |
| 9 | C |
| 10 | A, B, C |
| 11 | C |
| 12 | B |
| 13 | A, D |
| 14 | A, B, D |
| 15 | A |
| 16 | C |
| 17 | B |
| 18 | B |
| 19 | A |
| 20 | B, C, D |
| 21 | B |
| 22 | C |
| 23 | A |
| 24 | C |
| 25 | A, B |
| 26 | A, B |
| 27 | C |
| 28 | C |
| 29 | B |
| 30 | B |