nerdexam
SnowflakeSnowflake

DEA-C02 · Question #88

DEA-C02 Question #88: Real Exam Question with Answer & Explanation

Sign in or unlock DEA-C02 to reveal the answer and full explanation for question #88. The question stem and answer options stay visible for context.

Performance Optimization

Question

What action could a Data Engineer take to increase the query performance of an external table?

Options

  • AAdd a clustering key to the external table.
  • BEnable the search optimization service on the external table.
  • CCreate a materialized view on the external table.
  • DSet the USE_CACHED_RESULTS parameter to True for the external table.

Unlock DEA-C02 to see the answer

You've previewed enough free DEA-C02 questions. Unlock DEA-C02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#External Tables#Materialized Views#Query Performance#Performance Optimization
Full DEA-C02 PracticeBrowse All DEA-C02 Questions