New Year Sale 2026! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

CompTIA FC0-U71 Exam - Topic 4 Question 8 Discussion

Actual exam question for CompTIA's FC0-U71 exam
Question #: 8
Topic #: 4
[All FC0-U71 Questions]

A database administrator creates a new database and assigns the primary key. Which of the following database types has the administrator created?

Show Suggested Answer Hide Answer
Suggested Answer: C

A relational database uses primary keys to uniquely identify records and establish relationships between tables.

Other options:

Document and key/value databases are NoSQL types that do not require primary keys in the traditional sense,

Non-structured databases do not organize data into structured tables.


Contribute your Thoughts:

0/2000 characters
Chaya
2 months ago
Nope, it's not key/value either.
upvoted 0 times
...
Penney
2 months ago
I agree, it's all about those structured tables.
upvoted 0 times
...
Toi
3 months ago
Wait, can you really assign a primary key in a document database?
upvoted 0 times
...
Margot
3 months ago
Yeah, relational is the way to go for that!
upvoted 0 times
...
Janine
3 months ago
Definitely a relational database. Primary keys are a must!
upvoted 0 times
...
Donette
3 months ago
I recall that document databases don't typically have primary keys in the same way, so I'm leaning towards relational for this question.
upvoted 0 times
...
Novella
4 months ago
I'm a bit confused because I feel like key/value stores might also have some form of unique identifiers, but they don't really use primary keys like relational databases do.
upvoted 0 times
...
Katina
4 months ago
I remember practicing a question about database types, and I think relational databases were the ones that definitely use primary keys.
upvoted 0 times
...
Blondell
4 months ago
I think the primary key is a concept mostly associated with relational databases, but I'm not entirely sure.
upvoted 0 times
...
Raina
4 months ago
You know, I think the primary key clue is the most important here. Relational databases are the ones that use primary keys to uniquely identify records, so that's got to be the answer. I'm confident in that.
upvoted 0 times
...
Shawn
4 months ago
Wait, I'm a bit confused. Doesn't a key/value database also have a primary key? I'm not entirely sure how to differentiate that from a relational database in this case.
upvoted 0 times
...
Lorrine
5 months ago
Okay, the key detail here is that the administrator assigned a primary key. That immediately rules out document and non-structured databases, which don't typically use primary keys. I'm leaning towards relational database.
upvoted 0 times
...
Charisse
5 months ago
Hmm, this seems like a straightforward question about database types. I'll think it through carefully and try to eliminate the options that don't make sense.
upvoted 0 times
...
Moon
6 months ago
That's a good point, Latrice. Document databases also use primary keys, but I still think it's more likely to be a relational database.
upvoted 0 times
...
Latrice
6 months ago
I'm not sure, but I think it could also be a document database since primary keys are used in document databases as well.
upvoted 0 times
...
Solange
7 months ago
I agree with Moon, because in a relational database, primary keys are used to uniquely identify each record.
upvoted 0 times
...
Trinidad
7 months ago
This question is as clear as mud. But I'm gonna take a wild guess and say C. Relational. Primary keys are the secret sauce of any good database, am I right?
upvoted 0 times
...
Paola
7 months ago
Wait, is this a trick question? I'm going to go with D. Non-structured, just to keep the database administrator on their toes.
upvoted 0 times
...
Moon
7 months ago
I think the database administrator created a relational database.
upvoted 0 times
...
Elizabeth
7 months ago
Hmm, this is a tough one. But I'm gonna have to say C. Relational databases and primary keys go together like peanut butter and jelly.
upvoted 0 times
Edda
5 months ago
C: Definitely, without a primary key, it would be chaos.
upvoted 0 times
...
Jamal
6 months ago
B: Yeah, that's right. It helps maintain the integrity of the data.
upvoted 0 times
...
Iluminada
6 months ago
A: I agree, relational databases are all about primary keys.
upvoted 0 times
...
...
Elvera
8 months ago
I'm gonna have to go with B. Key/value databases are all about those sweet, sweet key-value pairs. Primary keys fit right in!
upvoted 0 times
Hassie
7 months ago
Yeah, key/value databases are perfect for storing data with unique keys like primary keys.
upvoted 0 times
...
Brynn
7 months ago
I think you're right, primary keys are essential in key/value databases.
upvoted 0 times
...
...
Youlanda
8 months ago
Definitely C. Relational databases are the way to go when you need to assign primary keys. That's like Database 101 stuff.
upvoted 0 times
Jame
7 months ago
Relational databases make it easy to establish relationships between different tables.
upvoted 0 times
...
Mattie
7 months ago
Yeah, they are great for organizing data and ensuring data integrity.
upvoted 0 times
...
Evangelina
7 months ago
I agree, relational databases are the most common type used in the industry.
upvoted 0 times
...
...

Save Cancel