Practice Free DP-300 Exam Online Questions
HOTSPOT
From a website analytics system, you receive data extracts about user interactions such as downloads, link clicks, form submissions, and video plays.
The data contains the following columns:
You need to design a star schema to support analytical queries of the data. The star schema will contain four tables including a date dimension.
To which table should you add each column? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
You need to recommend a solution that will enable remote developers to access DB1 and DB2. The solution must support the planned changes and meet the secunty requirements.
What should you include in the recommendation?
- A . a public endpoint via a database-level firewall rule
- B . a private endpoint
- C . a public endpoint via a server-level firewall rule
- D . a Point-to-Site (P2S) VPN
You have an Azure virtual machine named VM1 on a virtual network named VNet1. Outbound traffic from VM1 to the internet is blocked.
You have an Azure SQL database named SqlDb1 on a logical server named SqlSrv1.
You need to implement connectivity between VM1 and SqlDb1 to meet the following requirements:
✑ Ensure that VM1 cannot connect to any Azure SQL Server other than SqlSrv1.
✑ Restrict network connectivity to SqlSrv1.
What should you create on VNet1?
- A . a VPN gateway
- B . a service endpoint
- C . a private link
- D . an ExpressRoute gateway
DRAG DROP
You have a resource group named App1Dev that contains an Azure SQL Database server named DevServer1. DevServer1 contains an Azure SQL database named DB1. The schema and permissions for DB1 are saved in a Microsoft SQL Server Data Tools (SSDT) database project.
You need to populate a new resource group named App1Test with the DB1 database and an Azure SQL Server named TestServer1. The resources in App1Test must have the same configurations as the resources in App1Dev.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
DRAG DROP
You have an Azure key vault named Vault1 and a SQL Server on Azure Virtual Machines instance named SQL1 SQL 1 hosts a database named DB1.
You need to configure Transparent Data Encryption (TDE) on D61 to use a key in Vault1
Which four actions should you perform in sequence’ To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
You have an on-premises Microsoft SQL Server 2019 database named SQL1 that uses merge replication. You need to migrate SQL1 to Azure.
Which service should you use?
- A . Azure SQL Edge
- B . Azure SQL Database
- C . SQL Server on Azure Virtual Machines
- D . Azure SQL Managed instance
You have an Azure virtual machine named VM1 on a virtual network named VNet1. Outbound traffic from VM1 to the internet is blocked.
You have an Azure SQL database named SqlDb1 on a logical server named SqlSrv1.
You need to implement connectivity between VM1 and SqlDb1 to meet the following requirements:
✑ Ensure that all traffic to the public endpoint of SqlSrv1 is blocked.
✑ Minimize the possibility of VM1 exfiltrating data stored in SqlDb1.
What should you create on VNet1?
- A . a VPN gateway
- B . a service endpoint
- C . a private link
- D . an ExpressRoute gateway
HOTSPOT
You have an Azure subscription that contains a storage account named database backups.
You have an Azure SQL managed instance named DB1.
You need to back up DB1 to database backups.
How should you complete the commands? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
You have an Azure SQL database named sqldb1.
You need to minimize the amount of space by the data and log files of sqldb1.
What should you run?
- A . DBCC SHRINKDATABASE
- B . sp_clean_db_free_space
- C . sp_clean_db_file_free_space
- D . DBCC SHRINKFILE
You have an Azure SQL managed instance.
You need to gather the last execution of a query plan and its runtime statistics. The solution must minimize the impact on currently running queries.
What should you do?
- A . Generate an estimated execution plan.
- B . Generate an actual execution plan.
- C . Run sys.dm_exec_query_plan_stats.
- D . Generate Live Query Statistics.