GoConqr hat ein neues Design! Sag uns, wie es dir gefällt.

Kostenlos registrieren

Quiz

DP-3OO

Ana Rius 12 Fragen

Quiz starten

Dieses Quiz enthält Fragetypen, die sich im gewohnten Player öffnen.

Fragen in diesem Quiz (12)

  1. 1You have 2 Azure SQL Database server named Server1 and Server2. Each server contains an Azure SQL database named Database1.

    Server1 → database Database1
    Server2 → database Database1

    You need to restore Database1 from Server1 to Server2. The solution must replace the existing Database1 on Server2.

    From the Azure portal, you delete Database1 from Server2, and then you create a new database on Server2 by using the backup of Database1 from Server1
    Does this meet the goal?
    1. AYes
    2. BNo
  2. 2You have 2 Azure SQL Database server named Server1 and Server2. Each server contains an Azure SQL database named Database1.

    Server1 → database Database1
    Server2 → database Database1

    You need to restore Database1 from Server1 to Server2. The solution must replace the existing Database1 on Server2.

    You run the Remove-AzSqlDatabase PowerShell cmdlet for Database on Server2. You run the Restore-AzSqlDatabase PowerShell cmdlet for Database1 on Server2
    Does this meet the goal?
    1. AYes
    2. BNo
  3. 3You have 2 Azure SQL Database server named Server1 and Server2. Each server contains an Azure SQL database named Database1.

    Server1 → database Database1
    Server2 → database Database1

    You need to restore Database1 from Server1 to Server2. The solution must replace the existing Database1 on Server2.

    You restore Database1 from Server1 to the Server2 by using RESTORE Transact-SQL comand and the REPLACE option.
    Does this meet the goal?
    1. AYes
    2. BNo
  4. 4You have an Always On availability group deployed to Azure virtual machines. The availability group contains a database named DB1 and has two nodes named SQL1 and SQL2. SQL1 is the primary replica.
    You need to initiate a full backup of DB1 on SQL2.
    Which statement should you run?
    1. ABACKUP DATABASE DB1 TO URL='https://mystorageaccount.blob.core.windows.net/ mycontainer/DB1.bak' with (Differential, STATS=5, COMPRESSION);
    2. BBACKUP DATABASE DB1 TO URL='https://mystorageaccount.blob.core.windows.net/ mycontainer/DB1.bak' with (COPY_ONLY, STATS=5, COMPRESSION);
    3. CBACKUP DATABASE DB1 TO URL='https://mystorageaccount.blob.core.windows.net/ mycontainer/DB1.bak' with (File_Snapshot, STATS=5, COMPRESSION);
    4. DBACKUP DATABASE DB1 TO URL='https://mystorageaccount.blob.core.windows.net/ mycontainer/DB1.bak' with (NoInit, STATS=5, COMPRESSION);
  5. 5You have 10 you suspect are related to the connection nes that have SQL Server installed.
    You need to implement a backup strategy to ensure that you can restore specific databases to other SQL Server instances. The solution must provide centralized management of the backups.
    What should you include in the backup strategy?
    1. AAutomated Backup in the SQL virtual machine settings
    2. BAzure Backup
    3. CAzure Site Recovery
    4. DSQL Server Agent jobs
  6. 6You are building a database backup solution for a SQL Server database hosted on an Azure virtual machine.
    In the event of an Azure regional outage, you need to be able to restore the database backups. The solution must minimize costs.
    Which type of storage accounts should you use for the backups?
    1. Alocally-redundant storage (LRS)
    2. Bread-access geo-redundant storage (RA-GRS)
    3. Czone-redundant storage (ZRS)
    4. Dgeo-redundant storage
  7. 7You have a new Azure SQL database. The database contains a column that stores confidential information.
    You need to track each time values from the column are returned in a query. The tracking information must be stored for 365 days from the date the query was executed.
    Which three actions should you perform? Each correct answer presents part of the solution.
    NOTE: Each correct selection is worth one point.
    1. ATurn on auditing and write audit logs to an Azure Storage account.
    2. BAdd extended properties to the column
    3. CTurn on Advanced Data Security for the Azure SQL server
    4. DApply sensitivity labels named Highly Confidential to the column.
    5. ETurn on Azure Advanced Threat Protection (ATP).
  8. 8You have SQL Server on an Azure virtual machine that contains a database named DB1. DB1 contains a table named CustomerPII.
    You need to record whenever users query the CustomerPII table.
    Which two options should you enable? Each correct answer presents part of the solution.
    1. Aserver audit specification
    2. BSQL Server audit
    3. Cdatabase audit specification
    4. Da server principal
  9. 9You have a Microsoft Azure virtual machine named SQL1 that has Microsoft SQL Server 2016 installed.
    SQL1 has a critical database that contains online transaction data. The database is 700 GB.
    You regularly perform full database backups.
    On a separate Azure virtual machine, you run a test restore procedure of the database and discover that restoring the database takes longer than expected.
    You need to reduce the amount of time required to restore the database.
    What should you do?
    1. AModify the backup solution to use differential database backups.
    2. BPartition the tables in the database, and then modify the backup solution to use incremental backups.
    3. CCreate multiple filegroups in the database, and then modify the backup solution to use filegroup backups.
    4. DModify the backup solution to use transaction log backups.
  10. 10You have an on-premises Microsoft SQL Server 2016 server named Server1 that contains a database named DB1.
    You need to perform an online migration of DB1 to an Azure SQL Database managed instance by using Azure Database Migration Service.
    How should you configure the backup of DB1? To answer, select the appropriate options in the answer area.

    [blank_start]Backup type:[blank_end]

    [blank_start]Backup option:[blank_end]
    1. ABackup type: Full and log backups only
    2. BBackup type: Full backup only
    3. CBackup type: Log backup only
    4. DBackup option: WITH CHECKSUM
    5. EBackup option: WITH NOINIT
    6. FBackup option: WITH UNLOAD

Informationen

Beschreibung
Quiz am DP-3OO, erstellt von Ana Rius am 12/11/2025.
Sprache
Español
Aufrufe
0
Schlagwörter
curso interno de empresa
Bewertung
Noch keine Bewertungen
Bewerte dieses Quiz
Bewerte dieses Quiz

Feedback

Worum geht es?

Wie gefällt dir das neue Design?

Dein Eindruck