CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Microsoft
  5. DP-300

Free DP-300 Exam Braindumps (page: 8)

Page 8 of 76
PDF with 352 Questions

HOTSPOT (Drag and Drop is not supported)
You have a SQL Server on Azure Virtual Machines instance named VM1 that hosts a database named DB1.
You run the following query.



For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Box 1: No
A copy-only log backup preserves the existing log archive point and, therefore, does not affect the sequencing of regular log backups.

Box 2: No

Box 3: Yes
If the database is online and you plan to perform a restore operation on the database, begin by backing up the tail of the log. To avoid an error for an online database, you must use the ... WITH NORECOVERY option of the BACKUP Transact-SQL statement.


Reference:

https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/tail-log-backups-sql-server https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/copy-only-backups-sql-server



HOTSPOT (Drag and Drop is not supported)
You configure backups for an Azure SQL database as shown in the following exhibit.



Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point.

  1. See Explanation section for answer.

Answer(s): A

Explanation:



You have an Azure subscription that contains an Azure SQL database named SQL1.
SQL1 is in an Azure region that does not support availability zones.
You need to ensure that you have a secondary replica of SQL1 in the same region.

What should you use?

  1. log shipping
  2. active geo-replication
  3. Microsoft SQL Server failover clusters
  4. auto-failover groups

Answer(s): B



You have an Azure SOI database named SQLDb1 that contains the resources shown in the following table.



Column1 contains JSON data.

You need to compress Column1. The solution must minimize the amount of storage used.

What should you use?

  1. the COMPRESS() function
  2. columnstore archive compression
  3. row compression
  4. columnstore compression

Answer(s): A



Page 8 of 76



Post your Comments and Discuss Microsoft DP-300 exam with other Community members:

laks commented on December 26, 2024
so far seems good
UNITED STATES
upvote

Jack commented on October 24, 2024
Muito bom as perguntas
Anonymous
upvote

TheUser commented on October 23, 2024
So far seems good
Anonymous
upvote

anonymus commented on October 23, 2024
master database differential backup is not supported in sql server
EUROPEAN UNION
upvote

Ntombi commented on October 17, 2024
i find the questions helpful for my exam preparation
Anonymous
upvote

Ntombi commented on October 17, 2024
The questions help me to see if I understood what I have learned
Anonymous
upvote

ntombi commented on October 17, 2024
writing exam at the end of the month
Anonymous
upvote

Raby commented on August 13, 2024
Wonderful work guys. The PDF version helped me pass. Thank you
EUROPEAN UNION
upvote