Home » Microsoft » MB2-708 » What should you use?
You are writing a custom report in Dynamics CRM 2015.
You need to ensure that the report only displays data to which a user has permission.
What should you use?
A. Filtered views
B. FetchXML queries
C. A Microsoft SQL Server stored procedure
D. Condition statements in SQL queries
Correct Answer: B
Explanation/Reference:
* To execute a FetchXML query in Microsoft Dynamics CRM 2015 and Microsoft Dynamics CRM Online, you must first build the XML query string. After you create the query string, use the IOrganizationService.RetrieveMultiple method to execute the query string. The privileges of the logged on user affects the set of records returned. Only records for which the logged on user has read access will be returned.
Incorrect:
Not A:
SQL-based reports in Microsoft Dynamics CRM use the filtered views provided for each entity to retrieve data for the reports. Filtered views are fully compliant with the Microsoft Dynamics CRM security model. When you run a report that obtains data from filtered views, the Microsoft Dynamics CRM security role determines what data you can view in the report. Data in filtered views is restricted at these levels: the organization, the business unit, the owner, and at the field level.