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

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

Sylvia

3 days ago

A) pubs

upvoted 0 times

...

Ronald

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

Ronald

2 days ago

Let's delete pubs, it's not critical for the database engine.

upvoted 0 times

...

Ardella

3 days ago

Definitely not msdb, that's important for SQL Server Agent.

upvoted 0 times

...

Chuck

4 days ago

D) tempdb

upvoted 0 times

...

Billy

12 days ago

C) msdb

upvoted 0 times

...

Gilma

17 days ago

B) master

upvoted 0 times

...

Magda

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

Evelynn

8 days ago

I think we should delete tempdb instead.

upvoted 0 times

...

Jacquelyne

25 days ago

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

upvoted 0 times

...

Maricela

29 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

19 days ago

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

upvoted 0 times

...

Kimbery

22 days ago

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

upvoted 0 times

...

Jettie

23 days ago

D) tempdb

upvoted 0 times

...

Elly

1 months ago

C) msdb

upvoted 0 times

...

Nada

1 months ago

B) master

upvoted 0 times

...

Marnie

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

22 days ago

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

upvoted 0 times

...

Georgene

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

2 months ago

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

upvoted 0 times

...