Microsoft DP-900 Exam - Topic 11 Question 95 Discussion

Actual exam question for Microsoft's DP-900 exam

Question #: 95
Topic #: 11

[All DP-900 Questions]

You need to design and model a database by using a graphical tool that supports project-oriented offline

database development.

What should you use?

AMicrosoft SQL Server Data Tools (SSDT)

BMicrosoft SQL Server Management Studio (SSMS)

CAzure Databricks

DAzure Data Studio

Show Suggested Answer

Suggested Answer: B

by Tuyet at Sep 13, 2024, 06:12 AM

Limited Time Offer

25%

Off

Get Premium DP-900 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Karl

5 months ago

I thought Azure Data Studio was just for querying, not modeling.

upvoted 0 times

...

Gabriele

5 months ago

Totally agree, SSDT is the way to go!

upvoted 0 times

...

Alex

5 months ago

Wait, Azure Databricks? Isn’t that more for big data?

upvoted 0 times

...

Noah

5 months ago

I prefer SSMS for its simplicity.

upvoted 0 times

...

Rochell

6 months ago

SSDT is great for offline database development!

upvoted 0 times

...

Kerry

6 months ago

I feel like I’ve seen questions similar to this before, and SSDT was usually the answer for modeling databases.

upvoted 0 times

...

Blair

6 months ago

Azure Data Studio sounds familiar, but I can't recall if it supports offline development.

upvoted 0 times

...

Hayley

6 months ago

I remember practicing with SSMS, but I don’t think it’s project-oriented like the question asks.

upvoted 0 times

...

Eve

6 months ago

I think SSDT might be the right choice since it’s specifically designed for database development, but I’m not entirely sure.

upvoted 0 times

...

Milly

6 months ago

I'm a bit confused by the wording of the question. Does "project-oriented offline database development" mean I can't use an online tool? I'll have to double-check the details.

upvoted 0 times

...

Torie

6 months ago

SSDT is the way to go here. It's designed for project-oriented database development, which is exactly what the question is asking for.

upvoted 0 times

...

Krissy

6 months ago

Hmm, I'm not too familiar with the different database tools. I'll have to think this through carefully and compare the options.

upvoted 0 times

...

Junita

6 months ago

This one seems straightforward. I'll go with SSDT since it's specifically mentioned as a graphical tool for offline database development.

upvoted 0 times

...

Devorah

7 months ago

Okay, let's think this through. The question is asking for the three foundational elements, so I'll need to carefully consider each option and choose the three that best fit that criteria.

upvoted 0 times

...

Willetta

11 months ago

If you ask me, the correct answer is obviously a magic 8-ball. It knows all the database secrets, trust me.

upvoted 0 times

...

Brande

11 months ago

Azure Data Studio? Hmm, I'm not too familiar with that one. Sounds like it might be worth looking into, but SSDT is probably the safest bet here.

upvoted 0 times

Carla

10 months ago

I think SSDT is the way to go for designing and modeling a database.

upvoted 0 times

...

Eliseo

10 months ago

I've heard good things about Azure Data Studio, but SSDT is definitely a safe option.

upvoted 0 times

...

Vernell

11 months ago

I agree, SSDT is a reliable choice for database development.

upvoted 0 times

...

Robt

12 months ago

Wait, Azure Databricks? Isn't that for big data and analytics? I don't think that's what they're looking for in this question.

upvoted 0 times

Carol

10 months ago

B) Microsoft SQL Server Management Studio (SSMS)

upvoted 0 times

...

Pearline

10 months ago

I think we should go with Microsoft SQL Server Data Tools (SSDT) for this database design.

upvoted 0 times

...

Twanna

10 months ago

A) Microsoft SQL Server Data Tools (SSDT)

upvoted 0 times

...

Ellsworth

10 months ago

Yeah, you're right. Azure Databricks is more for big data and analytics.

upvoted 0 times

...

Marica

11 months ago

C) Azure Databricks

upvoted 0 times

...

Catina

11 months ago

B) Microsoft SQL Server Management Studio (SSMS)

upvoted 0 times

...

Ashleigh

11 months ago

A) Microsoft SQL Server Data Tools (SSDT)

upvoted 0 times

...

Angelo

1 year ago

SSMS is a solid choice, but it's more for management and administration tasks. For actual database design and modeling, SSDT seems like the better fit.

upvoted 0 times