If a survey has 5 questions, how many total rows are created across the Survey and Response tables when the survey is submitted?

Unlock all questions

This demo includes only 20 questions. Upgrade to access hundreds of questions, flashcards, exam simulations, and disable ads.

Full question bankExam simulationsFlashcards
From $25.99Unlock all

Prepare for the Fabric Analytics Engineer Associate Test with comprehensive materials. Explore flashcards, multiple choice questions, and detailed explanations. Get ready for your success!

Multiple Choice

If a survey has 5 questions, how many total rows are created across the Survey and Response tables when the survey is submitted?

Explanation:
When data is modeled this way, the survey itself is represented by one row in the Survey table, while each answered question in a submission gets its own row in the Response (Answers) table, all linked to that survey. For a 5-question survey, there is one survey row plus five response rows, totaling six rows. So the total across both tables is 6.

When data is modeled this way, the survey itself is represented by one row in the Survey table, while each answered question in a submission gets its own row in the Response (Answers) table, all linked to that survey. For a 5-question survey, there is one survey row plus five response rows, totaling six rows. So the total across both tables is 6.

More Multiple Choice Questions
Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy