Study tips 1z0-117

Which two actions can you make to improve the performance of theses queries?

What must be done to ensure that an optimizer uses the latest statistics of the table?

Which two statements are true about the usage of the result cache?

How can you analyze an existing trace file to list the almost resource-intensive statements, aggregation of statistics, and to either exclude recursive call details?

Which statement is true about the usage of the STAR_TRANSFORMATION hint in a query?

Which two statements are correct regarding the execution plan?

Which two statements are true about the use of the DYNAMIC_SAMPLING hint in a query?

Which two are true about parallelism prioritization by a consumer group?

which is true?

Which three parameter settings could you change to avoid this error?