Question: what are some advantages of using dynamic query mode (dqm)?
Answer: With the dynamic query mode, business users get the right information quickly without compromising security. In-memory caching stores both the query plan and the query results while maintaining the security permissions for each user.