Microsoft Certified Data Analyst Associate Microsoft Power Platform Fundamentals 2 — Questions and Answers
Question 1: Which Power Platform component allows you to create automated workflows that connect different apps and services without writing code?
- Power Apps
- Power Automate (Correct answer)
- Power BI
- Power Virtual Agents
Correct answer: Power Automate
Power Automate is designed to automate workflows and business processes across apps and services using a visual, no-code interface.
Question 2: In Power BI, what is the purpose of a 'gateway'?
- To publish reports to the web
- To enable scheduled refresh of on-premises data sources (Correct answer)
- To share dashboards with external users
- To connect Power BI to Azure Active Directory
Correct answer: To enable scheduled refresh of on-premises data sources
A Power BI gateway acts as a bridge that enables secure data transfer between on-premises data sources and the Power BI service for scheduled refreshes.
Question 3: Which Power Apps type is best suited for creating apps that work offline and sync data when connectivity is restored?
- Model-driven apps
- Canvas apps (Correct answer)
- Portal apps
- AI Builder apps
Correct answer: Canvas apps
Canvas apps support offline capability, allowing users to continue working without internet access and syncing changes when reconnected.
Question 4: What does the 'Common Data Model' (CDM) provide in the context of the Power Platform?
- A shared schema of standard entities and relationships used across applications (Correct answer)
- A built-in AI model for data predictions
- A relational database engine unique to Power Apps
- A visualization template library for Power BI
Correct answer: A shared schema of standard entities and relationships used across applications
The Common Data Model provides a standardized, extensible set of data schemas that enables consistent data sharing across Microsoft applications and services.
Question 5: In Power Automate, which trigger type starts a flow when a specific time or schedule is reached?
- Instant trigger
- Automated trigger
- Scheduled trigger (Correct answer)
- UI flow trigger
Correct answer: Scheduled trigger
Scheduled triggers in Power Automate fire flows at defined intervals or specific times, such as daily at midnight.
Question 6: Which Power BI feature allows users to ask questions about their data using natural language?
- Quick Insights
- Q&A (Correct answer)
- Decomposition Tree
- Key Influencers
Correct answer: Q&A
Power BI's Q&A feature enables users to type natural language questions and receive visualizations as answers directly within a report or dashboard.
Question 7: What is the primary role of Dataverse in the Power Platform?
- To host Power BI reports in the cloud
- To provide a secure, scalable data storage and management service for apps (Correct answer)
- To manage user authentication for Power Apps portals
- To deploy chatbots created in Power Virtual Agents
Correct answer: To provide a secure, scalable data storage and management service for apps
Dataverse provides a low-code data platform with built-in security, business logic, and storage that underpins model-driven apps and many Power Platform solutions.
Microsoft Certified Data Analyst Associate Microsoft Power Platform Fundamentals 2
Which Power Platform component allows you to create automated workflows that connect different apps and services without writing code?