HOTSPOT - A music school rents out musical instruments to their students. Rental contracts specify that a student must choose an instrument for an entire school term. Students can choose other instruments in future terms. You create the following tables: ✑ A custom table for instruments. ✑ A custom table for rental contracts. Student data is stored in the Contract table. You need to model the instrument rental process for the school staff. How should you model each of the following data elements? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area: Suggested Answer: Box 1: Choices - The Choices function returns a table of the possible values for a lookup column. Use the Choices function to provide a list of choices for your user to select from. This function is commonly used with the Combo box control in edit forms. For a lookup, the table that Choices returns matches the foreign table that's associated with the lookup. By using Choices, you eliminate the need to add the foreign table as an additional data source. Choices returns all columns of the foreign table. Box 2: One-to-many from instrument to rental contract. An instrument can be in many rental contracts. Note: Rental contracts specify that a student must choose an instrument for an entire school term. Students can choose other instruments in future terms. Box 3: Lookup on the instrument table. Reference: https://docs.microsoft.com/en-us/power-platform/power-fx/reference/function-choices This question is in PL-100 Microsoft Power Platform App Maker Exam For getting Microsoft Certified: Power Platform App Maker Associate Certificate Disclaimers: The website is not related to, affiliated with, endorsed or authorized by Microsoft. The website does not contain actual questions and answers from Microsoft's Certification Exams. Trademarks, certification & product names are used for reference only and belong to Microsoft.
Please login or Register to submit your answer