DP-300 Exam Question 136
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?
Column1 contains JSON data.
You need to compress Column1. The solution must minimize the amount of storage used.
What should you use?
DP-300 Exam Question 137
Hotspot Question
You have a 50-TB Microsoft SQL Server database named DB1.
You need to reduce the time it takes to perform database consistency checks of DB1.
Which Transact-SQL command should you run? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You have a 50-TB Microsoft SQL Server database named DB1.
You need to reduce the time it takes to perform database consistency checks of DB1.
Which Transact-SQL command should you run? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
DP-300 Exam Question 138
SIMULATION
You need to ensure that any unused indexes of the databases on sql12345678 are removed automatically.
To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.
You need to ensure that any unused indexes of the databases on sql12345678 are removed automatically.
To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.
DP-300 Exam Question 139
Drag and Drop Question
You plan to create a table in an Azure Synapse Analytics dedicated SQL pool.
Data in the table will be retained for five years. Once a year, data that is older than five years will be deleted.
You need to ensure that the data is distributed evenly across partitions. The solutions must minimize the amount of time required to delete old data.
How should you complete the Transact-SQL statement? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all.
You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
You plan to create a table in an Azure Synapse Analytics dedicated SQL pool.
Data in the table will be retained for five years. Once a year, data that is older than five years will be deleted.
You need to ensure that the data is distributed evenly across partitions. The solutions must minimize the amount of time required to delete old data.
How should you complete the Transact-SQL statement? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all.
You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
DP-300 Exam Question 140
Your on-premises network contains a server that hosts a 60-TB database named DB 1. The network has a 10-Mbps internet connection.
You need to migrate DB 1 to Azure. The solution must minimize how long it takes to migrate the database.
What should you use?
You need to migrate DB 1 to Azure. The solution must minimize how long it takes to migrate the database.
What should you use?