A Deterministic Query Is Run at 8am, Takes 5 Minutes

question 17

Multiple Choice

A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true? (Choose two.)

• A) The exact query will ALWAYS return the precomputed result set for the RESULT_CACHE_ACTIVE = time period
• B) The same exact query will return the precomputed results if the underlying data hasn't changed and the results were last accessed within previous 24 hour period
• C) The same exact query will return the precomputed results even if the underlying data has changed as long as the results were last accessed within the previous 24 hour period
• D) The "24 hour" timer on the precomputed results gets renewed every time the exact query is executed

---

Definitions:

Modified AGI

Modified Adjusted Gross Income, an income measure used for tax purposes, adjusting the AGI for specific deductions or exclusions.

Qualified Adoption Expenses

Allowable adoption-related expenses that may be eligible for tax credits, including court costs, attorney fees, and traveling expenses.

Guatemala

A country located in Central America, bordered by Mexico, Belize, Honduras, and El Salvador, known for its rich Mayan heritage and diverse ecosystems.

Lifetime Learning Credit

A tax credit available for qualified tuition and related expenses paid for eligible students enrolled in an eligible educational institution, aimed at promoting lifelong learning.