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

3 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

Fatima

1 months ago

C) msdb

upvoted 0 times

...

Bette

2 months ago

B) master

upvoted 0 times

...

Sylvia

2 months ago

A) pubs

upvoted 0 times

...

Ronald

3 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

Alberta

2 months ago

Agreed, let's get rid of pubs to free up some space.

upvoted 0 times

...

Ronald

2 months ago

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

upvoted 0 times

...

Ardella

2 months ago

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

upvoted 0 times

...

Chuck

2 months ago

D) tempdb

upvoted 0 times

...

Billy

2 months ago

C) msdb

upvoted 0 times

...

Gilma

3 months ago

B) master

upvoted 0 times

...

Magda

3 months ago

A) pubs

upvoted 0 times

...

Casandra

4 months ago

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

upvoted 0 times

Allene

2 months ago

Let's be careful, we don't want to cause any business interruption.

upvoted 0 times

...

Evelynn

2 months ago

I think we should delete tempdb instead.

upvoted 0 times

...

Jacquelyne

3 months ago

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

upvoted 0 times

...

Maricela

3 months ago

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

upvoted 0 times

...

France

4 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

3 months ago

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

upvoted 0 times

...

Kimbery

3 months ago

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

upvoted 0 times

...

Jettie

3 months ago

D) tempdb

upvoted 0 times

...

Elly

3 months ago

C) msdb

upvoted 0 times

...

Nada

3 months ago

B) master

upvoted 0 times

...

Marnie

3 months ago

A) pubs

upvoted 0 times

...

Marleen

4 months ago

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

upvoted 0 times

...

German

4 months ago

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

upvoted 0 times

...

Terrilyn

4 months ago

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

upvoted 0 times

...

Rhea

4 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

3 months ago

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

upvoted 0 times

...

Georgene

3 months ago

Let's not even consider deleting the master database.

upvoted 0 times

...

Derrick

3 months ago

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

upvoted 0 times

...

Claudia

4 months ago

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

upvoted 0 times

...