A company needs to store and query large volumes of IoT sensor data (billions of rows) in Dataverse. The data is write-heavy, and queries are simple lookups by device ID and timestamp. The solution must minimize storage costs and provide low-latency queries. Which table type should you choose?

Virtual table that queries an external Azure Data Lake.

Elastic table with a partition key on device ID and a timestamp field.

Standard table with a clustered index on device ID and timestamp.

Standard table with a non-clustered index on device ID.

A company has a Power Apps portal for external partners. Partners authenticate via Azure AD B2C. The portal displays project documents stored in SharePoint. The company requires that partners only see documents for projects they are assigned to. The document library has thousands of documents. What is the most scalable and secure approach?

Use a Power Automate flow to copy documents to a partner-specific SharePoint library.

Use Dataverse to store project assignments and use a custom connector to fetch documents from SharePoint, filtering by the partner's project membership.

Store documents in Dataverse as attachments and use row sharing to grant access.

Create a SharePoint permission group for each project and add partners to the group.

A company uses Power Apps and Power Automate. The security team wants to prevent users from posting data from the corporate Dataverse environment to external social media sites. They also want to allow connections to SharePoint for document storage. What should you configure?

Create a data loss prevention (DLP) policy that blocks the social media connectors and allows SharePoint.

Use Azure AD conditional access to block social media sites.

Create a security role that denies access to the social media connectors.

Configure a business unit to restrict social media access.

A manufacturing company needs to ingest high-volume IoT sensor readings (millions per day) into Dataverse for real-time analytics. The data is non-relational and does not require complex queries or joins. Which table type should you use?

External table in Azure SQL Database

In a Power Platform solution that uses Microsoft Dataverse, which authentication mechanism is typically used for users signing in to a model-driven app?

Azure Active Directory (Azure AD)

Basic authentication with username and password stored in the app

Microsoft Certified:Power Platform Developer Associate

Domain 1Objective 1

Design Technical Architecture PL-400 Practice Questions (Page 2)

Part of the Create a technical design domain, which accounts for 10–15% of the PL-400 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~4–10 in this domain), expect 2–5 from this objective — we provide 29 practice questions to prepare you well beyond it. (estimate)

29questions here

6free pages

6concepts

10–15%of the exam

Questions 6–10

6expert · medium
A company needs to store and query large volumes of IoT sensor data (billions of rows) in Dataverse. The data is write-heavy, and queries are simple lookups by device ID and timestamp. The solution must minimize storage costs and provide low-latency queries. Which table type should you choose?
Select an answer first
7expert · hard
A company has a Power Apps portal for external partners. Partners authenticate via Azure AD B2C. The portal displays project documents stored in SharePoint. The company requires that partners only see documents for projects they are assigned to. The document library has thousands of documents. What is the most scalable and secure approach?
Select an answer first
8application · medium
A company uses Power Apps and Power Automate. The security team wants to prevent users from posting data from the corporate Dataverse environment to external social media sites. They also want to allow connections to SharePoint for document storage. What should you configure?
Select an answer first
9application · medium
A manufacturing company needs to ingest high-volume IoT sensor readings (millions per day) into Dataverse for real-time analytics. The data is non-relational and does not require complex queries or joins. Which table type should you use?
Select an answer first
10foundation · easy
In a Power Platform solution that uses Microsoft Dataverse, which authentication mechanism is typically used for users signing in to a model-driven app?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to PL-400

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “PL-400” is a trademark of its owner, used for identification only.