Huawei Exam H13-629 Topic 1 Question 52 Discussion

Actual exam question for Huawei's H13-629 exam

Question #: 52
Topic #: 1

SQL Server database administrator found that SQL Server is running out of space, you want to delete unnecessary databases to get more space.

Which of the following databases will be deleted once the database engine is abnormal or the upper business interruption?

Apubs

Bmaster

Cmsdb

Dtempdb

Show Suggested Answer

Suggested Answer: D

by Mable at Jul 16, 2024, 09:23 AM

Limited Time Offer

25%

Off

Get Premium H13-629 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Mitsue

24 days ago

I heard they're adding a new database type called 'trashdb' for administrators to safely delete unwanted data. Someone should pitch that to Microsoft.

upvoted 0 times

...

Ronald

28 days ago

msdb? That's the SQL Server Agent database. Deleting that would be like shooting yourself in the foot. Not a good idea.

upvoted 0 times

Billy

4 days ago

C) msdb

upvoted 0 times

...

Gilma

9 days ago

B) master

upvoted 0 times

...

Magda

22 days ago

A) pubs

upvoted 0 times

...

Casandra

2 months ago

pubs? That's just a sample database. Seems like a safe choice to delete. Let's go with that!

upvoted 0 times

Jacquelyne

17 days ago

Are you sure about that? What about master or msdb?

upvoted 0 times

...

Maricela

21 days ago

Let's delete pubs, it's just a sample database.

upvoted 0 times

...

France

2 months ago

tempdb is a temporary database, so I guess that could work. But I'd rather not risk bringing down the whole system.

upvoted 0 times

Patrick

11 days ago

I agree, it's a temporary database so it should be safe to delete.

upvoted 0 times

...

Kimbery

13 days ago

I think tempdb is the best option to delete in this situation.

upvoted 0 times

...

Jettie

15 days ago

D) tempdb

upvoted 0 times

...

Elly

23 days ago

C) msdb

upvoted 0 times

...

Nada

25 days ago

B) master

upvoted 0 times

...

Marnie

28 days ago

A) pubs

upvoted 0 times

...

Marleen

2 months ago

But what about master? Isn't that important for the overall functioning of the database?

upvoted 0 times

...

German

2 months ago

I agree with Terrilyn, tempdb can be recreated easily if needed.

upvoted 0 times

...

Terrilyn

2 months ago

I think we should delete tempdb, it's only used for temporary storage.

upvoted 0 times

...

Rhea

2 months ago

Deleting the master database? Are you serious? That's like nuking the entire server! I'll pass on that one.

upvoted 0 times

Shaquana

13 days ago

We need to find another solution, deleting master is too dangerous.

upvoted 0 times

...

Georgene

25 days ago

Let's not even consider deleting the master database.

upvoted 0 times

...

Derrick

1 months ago

Yeah, that's way too risky. We should look at other options.

upvoted 0 times

...

Claudia

1 months ago

I agree, deleting the master database is a big no-no.

upvoted 0 times

...