Q: 9
Which cache type is used to cache data output from SQL queries?
Options
Discussion
B. The key is "data output from SQL queries" which only fits the result cache, not metadata or file cache.
Feels like B here, since the result cache is specifically for storing the actual data output from SQL queries. Metadata cache just keeps schema and object info, not query results. Pretty sure that's right but let me know if you see it differently.
Its B, result cache is for actual query outputs. A just covers metadata, easy to mix up.
B tbh. Result cache stores the actual output from SQL queries so you get faster subsequent responses if the same query runs again. The other options are for metadata or local storage. Think this is pretty clear but open to correction.
A or maybe B, seen both picked in practice sets and the official guide has a diagram on these cache types.
B (seen similar on exam reports, it's always result cache for query output)
Honestly, under strict compliance settings local file cache can actually store query results depending on the setup. D
Maybe B, result cache. Metadata cache trips people up but it’s not for actual SQL output. If I’m off let me know.
B pretty sure, result cache is the one that stores query outputs. Someone confirm if that's right?
I saw a similar question on a practice test and picked A. Metadata cache made sense to me for stored query results.
Be respectful. No spam.
