nerdexam
MicrosoftMicrosoft

AI-102 · Question #127

AI-102 Question #127: Real Exam Question with Answer & Explanation

Sign in or unlock AI-102 to reveal the answer and full explanation for question #127. The question stem and answer options stay visible for context.

Submitted by yaw92· Mar 30, 2026

Question

You have a SQL query that combines customer data and order data. The query includes calculated columns. You need to create a database object that would allow other users to rerun the same SOL query. What should you create?

Options

  • Aan Index
  • Ba view
  • Ca scalar function
  • Da table

Unlock AI-102 to see the answer

You've previewed enough free AI-102 questions. Unlock AI-102 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

#SQL views#Database objects#SQL queries
Full AI-102 PracticeBrowse All AI-102 Questions