An engineer is partitioning a table in Azure SQL Database. Which filegroup can be used for the partition scheme?

AAny user-defined filegroup

BOnly the PRIMARY filegroup

COnly a memory-optimized filegroup

DA dedicated history filegroup

More Design and develop database solutions Questions

76 questions

Full Microsoft Certified: SQL AI Developer Associate Practice Test

All topics covered

All Microsoft Certified: SQL AI Developer Associate Questions

Browse by topic

Related Questions

A developer creates a primary key on an existing table. Which rule is enforced automatically for the...

easy

A team wants multiple tables to draw numbers from the same ordered sequence. Which feature should th...

easy

A report must show row values as they existed at 2026-02-01 12:00 UTC from a system-versioned tempor...

easy

A JSON document contains a `city` property with the scalar value `London`. Which function is the bes...

easy

A database model uses SQL Graph. Which statement correctly describes node and edge tables?...

easy

View all Design and develop database solutions questions

Educational Content — CertQnA practice questions are written against official exam objectives, covering the same domains tested on the real exam. All content is original and independent — not actual exam questions, not affiliated with any certification vendor. Learn more about our content policy

Discussion

Be the first to share your understanding of this concept

⚠️ Discussion is for concept clarification only. Do not share or request actual exam questions or answers.