Describe Microsoft Dataverse PL-900 Practice Questions (Page 6)

Questions 26–30

1. 26application · medium

   A company stores customer data in a SQL Server database. They want to move this data to Microsoft Dataverse so that non-developers can build apps and automate workflows directly against the data. They also need to relate each customer to multiple support tickets. What is the most important advantage of using Dataverse over their current SQL Server database?

   • ADataverse automatically replicates data to multiple geographic regions for disaster recovery, while SQL Server does not provide any replication.
   • BDataverse can store unstructured data such as images and documents, while SQL Server can only store structured data.
   • CDataverse uses a non-relational model, making it easier to store hierarchical customer-ticket data than SQL Server.
   • DDataverse provides built-in security, business logic, and integration with Power Platform components, while SQL Server requires custom code for these features.
   Reveal Solution Discussion Select an answer first
2. 27expert · hard

   A business analyst wants to use AI to create a Dataverse table for tracking employee certifications. They describe the table in natural language, and the AI suggests columns and relationships. However, the analyst notices that the AI did not create a relationship to the existing 'Employee' table. What should the analyst do?

   • AIgnore the relationship because AI-generated tables do not support relationships.
   • BRe-run the AI generation with a more detailed description that explicitly mentions the relationship.
   • CManually add a lookup column to the Employee table after the AI creates the table.
   • DUse Power Automate to automatically create the relationship based on the data.
   Reveal Solution Discussion Select an answer first
4. 28foundation · easy

   What is the purpose of a relationship in Microsoft Dataverse?

   • ATo create a backup of the data in a table.
   • BTo store data in a single table without duplication.
   • CTo connect two tables so that data can be linked and referenced across records.
   • DTo define the visual layout of a form.
   Reveal Solution Discussion Select an answer first
5. 29application · medium

   A Dataverse solution has an Account table and a Contact table. Each contact can be associated with one primary account, but an account can have many contacts. Users need to see a list of all contacts for an account from the account form. What type of relationship should be configured?

   • AA many-to-many relationship with an intersect table.
   • BA one-to-one relationship between Account and Contact.
   • CA one-to-many relationship where Contact has a lookup column to Account.
   • DA hierarchical relationship on the Account table.
   Reveal Solution Discussion Select an answer first
6. 30expert · hard

   A company is evaluating whether to use Dataverse or a traditional database for a new Power Platform solution. The solution requires complex reporting with multiple joins and aggregations, but also needs built-in security and integration with Power Apps. What is the best recommendation?

   • AUse a traditional database for the app and Dataverse for reporting.
   • BUse Dataverse and rely on its built-in reporting features for all complex reports.
   • CUse Dataverse for the app data and use Power BI to connect to Dataverse for reporting, accepting that complex joins may need to be simplified.
   • DUse a traditional SQL database for everything and build custom connectors for Power Apps.
   Reveal Solution Discussion Select an answer first