Module quiz: Power BI in enterprise :Deploy and Maintain Power BI Assets and Capstone project (Microsoft Power BI Data Analyst Professional Certificate) Answers 2025

Question 1

What is Power BI Service primarily used for?

❌ Managing data sources in Power BI Desktop
❌ Perform data cleansing and transformation
✅ Sharing reports and dashboards between team members

Explanation:
Power BI Service ka main purpose reports aur dashboards ko cloud par publish, share, aur collaborate karna hai.

Question 2

Most current data ke saath kaam karne ke liye Adventure Works kya actions le sakta hai? (Select all)

❌ Refresh the dataset on Power BI Desktop
✅ Enable scheduled refresh in Power BI Service
❌ Select Import connectivity mode
✅ Upload the report in Power BI Service

Explanation:

• Scheduled refresh ensure karta hai latest data

• Report upload hona zaroori hai taaki Service refresh kar sake

• Import mode real-time guarantee nahi karta

Question 3

Blank rows remove karna kaunsa data process step hai?

✅ During the data cleansing stage
❌ During the data transformation stage
❌ During the data connection stage

Explanation:
Data cleansing ka kaam hota hai errors, blanks, duplicates remove karna.

Question 4

Foreign branch ke CRM software se data load karna kaunsa step hai?

✅ Connection to data sources
❌ Data cleansing
❌ Data transformation

Explanation:
External system (CRM) se data lana data connection ka part hota hai.

Question 5

Power BI Service ka kaunsa feature global collaboration ko support karta hai?

❌ Cloud Access
❌ Cloud Scalability
✅ Real-Time Collaboration

Explanation:
Teams different locations se same dashboards aur reports par kaam kar sakti hain.

Question 6

True or False: Data analysts fraud detection me help kar sakte hain.

✅ True
❌ False

Explanation:
Data analysts patterns, anomalies aur suspicious activity identify karte hain.

Question 7

True or False: SQL databases multiple users ko access allow nahi karte.

❌ True
✅ False

Explanation:
SQL databases multi-user aur multi-application access support karte hain.

Question 8

Import vs DirectQuery ke kaunse statements sahi hain? (Select all)

✅ Import mode may not reflect real-time updates
❌ DirectQuery mode loads data directly into Power BI for fast visualizations
✅ DirectQuery mode can potentially lead to slower performance
❌ Import mode connects Power BI directly to the source database

Explanation:

• Import = cached data

• DirectQuery = live source → performance dependent hoti hai

Question 9

Power BI me “parameters” ka matlab kya hai?

❌ Dynamic data sources
✅ Dynamic variables that influence the data displayed in the report
❌ Fixed values

Explanation:
Parameters user ko inputs change karke analysis customize karne dete hain.

Question 10

What-if parameters scenario analysis kaise improve karte hain?

✅ Users ko hypothetical scenarios explore karne dete hain bina complex calculations ke
❌ Multiple report versions create karte hain
❌ Advanced statistical calculations provide karte hain

Explanation:
What-if parameters se user slider ya input ke through impact dekh sakta hai.

🧾 Summary Table (Final & Correct)