最新的Microsoft Administering Relational Databases on Microsoft Azure - DP-300免費考試真題
Your company has an Azure SQL database named pass4testdb. Below are the configuration settings set for the database for automatic tuning.
Your company has a SQL Server 2019 instance hosted on an Azure virtual machine. The machine runs Windows Server 2019. The virtual machine has 4 vCPUs and 28 GB of memory.
You now have to scale up the virtual machine to 16 vCPUs and 64 GB of memory.
You have to provide the lowest latency for the tempdb database.
You decide to create 2 data files for tempdb
Would this fulfill the requirement?
Your company has a SQL Server 2019 instance hosted on an Azure virtual machine. The machine runs Windows Server 2019. The virtual machine has 4 vCPUs and 28 GB of memory.
You now have to scale up the virtual machine to 16 vCPUs and 64 GB of memory.
You have to provide the lowest latency for the tempdb database.
You decide to create 2 data files for tempdb
Would this fulfill the requirement?
正確答案: A
說明：（僅 Fast2test 成員可見）
You are designing a date dimension table in an Azure Synapse Analytics dedicated SQL pool.
The date dimension table will be used by all the fact tables.
Which distribution type should you recommend to minimize data movement?
The date dimension table will be used by all the fact tables.
Which distribution type should you recommend to minimize data movement?
正確答案: A
Your company has an Azure SQL database named pass4testdb.
You have to implement disaster recovery for the database. Below are the key requirements:
- During normal operations, there should be at least two readable
copies of the database
- The pass4testdb database needs to be available even if a datacenter
fails
You decide to deploy an Azure SQL database that uses the Business-Critical service tier and availability zones.
Would this fulfil the requirement?
You have to implement disaster recovery for the database. Below are the key requirements:
- During normal operations, there should be at least two readable
copies of the database
- The pass4testdb database needs to be available even if a datacenter
fails
You decide to deploy an Azure SQL database that uses the Business-Critical service tier and availability zones.
Would this fulfil the requirement?
正確答案: B
說明：（僅 Fast2test 成員可見）
You have an Azure subscription that contains an Azure SQL database named db1.
You need to implement SQL insights for db1.
Which two resources should you create first? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You need to implement SQL insights for db1.
Which two resources should you create first? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
正確答案: D,E
說明：（僅 Fast2test 成員可見）
You have an Azure SQL database that contains a table named factSales. FactSales contains the columns shown in the following table.
FactSales has 6 billion rows and is loaded nightly by using a batch process.
Which type of compression provides the greatest space reduction for the database?
FactSales has 6 billion rows and is loaded nightly by using a batch process.
Which type of compression provides the greatest space reduction for the database?
正確答案: B
說明：（僅 Fast2test 成員可見）
SIMULATION
You need to enable change data capture (CDC) for db1.
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 enable change data capture (CDC) for db1.
To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.
正確答案:
You are developing an application that uses Azure Data Lake Storage Gen 2.
You need to recommend a solution to grant permissions to a specific application for a limited time period.
What should you include in the recommendation?
You need to recommend a solution to grant permissions to a specific application for a limited time period.
What should you include in the recommendation?
正確答案: A
說明：（僅 Fast2test 成員可見）
You have an on-premises, 20-TB Microsoft SQL Server database named DB1 that is used by a web app named App1.
You have an Azure subscription that contains a storage account named storage1.
You need to migrate DB1 to an Azure SQL database. The solution must minimize downtime for App1.
What should you use to perform the migration?
You have an Azure subscription that contains a storage account named storage1.
You need to migrate DB1 to an Azure SQL database. The solution must minimize downtime for App1.
What should you use to perform the migration?
正確答案: B
說明：（僅 Fast2test 成員可見）
You have an Azure subscription that contains a SQL Server on Azure Virtual Machines instance named SQLVM1. SQLVM1 has the following configurations:
- Automated patching is enabled.
- The SQL Server IaaS Agent extension is installed.
- The Microsoft SQL Server instance on SQLVM1 is managed by using the
Azure portal.
You need to automate the deployment of cumulative updates to SQLVM1 by using Azure Update Manager. The solution must ensure that the SQL Server instance on SQLVM1 can be managed by using the Azure portal.
What should you do first on SQLVM1?
- Automated patching is enabled.
- The SQL Server IaaS Agent extension is installed.
- The Microsoft SQL Server instance on SQLVM1 is managed by using the
Azure portal.
You need to automate the deployment of cumulative updates to SQLVM1 by using Azure Update Manager. The solution must ensure that the SQL Server instance on SQLVM1 can be managed by using the Azure portal.
What should you do first on SQLVM1?
正確答案: A
說明：（僅 Fast2test 成員可見）
You provision an Azure SQL Managed Instance database named MyDevData. The database will be used by in-house development for application development projects.
DevSupport custom database role members will use dynamic management views (DMVs) to retrieve performance and health information about MyDevData.
You need to ensure that DevSupport members can view information through DMVs.
Which statement should you use?
Each correct answer presents part of the solution.
DevSupport custom database role members will use dynamic management views (DMVs) to retrieve performance and health information about MyDevData.
You need to ensure that DevSupport members can view information through DMVs.
Which statement should you use?
Each correct answer presents part of the solution.
正確答案: B