Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25

- Free Preparation Discussions

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

6 months ago

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

upvoted 0 times

...

Gabriele

6 months ago

Totally agree, SSDT is the way to go!

upvoted 0 times

...

Alex

7 months ago

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

upvoted 0 times

...

Noah

7 months ago

I prefer SSMS for its simplicity.

upvoted 0 times

...

Rochell

7 months ago

SSDT is great for offline database development!

upvoted 0 times

...

Kerry

7 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

8 months ago

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

upvoted 0 times

...

Hayley

8 months ago

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

upvoted 0 times

...

Eve

8 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

8 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

8 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

8 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

8 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

8 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

1 year 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

1 year 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

12 months ago

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

upvoted 0 times

...

Eliseo

12 months ago

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

upvoted 0 times

...

Vernell

1 year ago

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

upvoted 0 times

...

...

Robt

1 year 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

12 months ago

B) Microsoft SQL Server Management Studio (SSMS)

upvoted 0 times

...

Pearline

12 months ago

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

upvoted 0 times

...

Twanna

12 months ago

A) Microsoft SQL Server Data Tools (SSDT)

upvoted 0 times

...

Ellsworth

12 months ago

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

upvoted 0 times

...

Marica

1 year ago

C) Azure Databricks

upvoted 0 times

...

Catina

1 year ago

B) Microsoft SQL Server Management Studio (SSMS)

upvoted 0 times

...

Ashleigh

1 year 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

Robt

1 year ago

B) Microsoft SQL Server Management Studio (SSMS)

upvoted 0 times

...

Alesia

1 year ago

A) Microsoft SQL Server Data Tools (SSDT)

upvoted 0 times

...

...

Donte

1 year ago

I prefer Azure Data Studio because it offers a lot of features for database modeling.

upvoted 0 times

...

Hyman

1 year ago

I agree with Virgina, SSDT is great for project-oriented offline database development.

upvoted 0 times

...

Lettie

1 year ago

I think SSDT is the way to go for offline database development. It has great visualization tools and supports project-based workflows.

upvoted 0 times

Salome

1 year ago

I think SSMS is more for managing existing databases, not for designing and modeling new ones.

upvoted 0 times

...

Truman

1 year ago

B) Microsoft SQL Server Management Studio (SSMS)

upvoted 0 times

...

Ellsworth

1 year ago

I agree, SSDT is perfect for project-oriented offline database development.

upvoted 0 times

...

Lisandra

1 year ago

A) Microsoft SQL Server Data Tools (SSDT)

upvoted 0 times

...

...

Virgina

1 year ago

I think we should use Microsoft SQL Server Data Tools (SSDT) for database development.

upvoted 0 times

...