HOTSPOT (Drag and Drop is not supported)You have an Azure subscription.You plan to deploy an Azure SQL database by using an Azure Resource Manager template.How should you complete the template? To answer, select the appropriate options in the answer area.Note: Each correct selection is worth one point.Hot Area:
Answer(s): A
Box 1: "Microsoft.Sql/servers"Example:"resources": [{"type": "Microsoft.Sql/servers","apiVersion": "2021-08-01-preview","name": "[parameters('serverName')]","location": "[parameters('location')]","properties": {"administratorLogin": "[parameters('administratorLogin')]", "administratorLoginPassword": "[parameters('administratorLoginPassword')]" }},{"type": "Microsoft.Sql/servers/databases","apiVersion": "2021-08-01-preview","name": "[format('{0}/{1}', parameters('serverName'), parameters('sqlDBName'))]", "location": "[parameters('location')]","sku": {"name": "Standard","tier": "Standard"},"dependsOn": ["[resourceId('Microsoft.Sql/servers', parameters('serverName'))]" ]}Box 2: "dependsOn": [
https://docs.microsoft.com/en-us/azure/azure-sql/database/single-database-create-arm-template-quickstart
You have an on-premises Microsoft SQL Server 2019 server that hosts a database named DB1.You have an Azure subscription that contains an Azure SQL managed instance named SQLMI1 and a virtual network named VNET1. SQLMI1 resides on VNET1. The on-premises network connects to VNET1 by using an ExpressRoute connection.You plan to migrate DB1 to SQLMI1 by using Azure Database Migration Service.You need to configure VNET1 to support the migration.What should you do?
Answer(s): D
You have an on-premises Microsoft SQL server that uses the FileTables and Filestream features.You plan to migrate to Azure SQL.Which service should you use?
Answer(s): B
SQL Server VM alternative.Your business might have requirements that make SQL Server on Azure Virtual Machines a more suitable target than Azure SQL Database.If one of the following conditions applies to your business, consider moving to a SQL Server virtual machine (VM) instead:* You have strict dependency on features that are still not supported, such as FileStream/FileTable, PolyBase, and cross-instance transactions.* Etc.
https://docs.microsoft.com/en-us/azure/azure-sql/migration-guides/database/sql-server-to-sql-database- overview
You need to migrate an on-premises Microsoft SQL Server database to an Azure SQL Database. The solution must minimize downtime.What should you do?
Answer(s): C
Use Transactional Replication.When you can't afford to remove your SQL Server database from production while the migration is occurring, you can use SQL Server transactional replication as your migration solution.Note: There are two primary methods for migrating a SQL Server 2005 or later database to Azure SQL Database. The first method (database copy or BACPAC importation) is simpler but requires some, possibly substantial, downtime during the migration. The second method (transactional replication) is more complex, but substantially eliminates downtime during the migration.Incorrect:Not D: The import BACPAC method includes downtime during migration.
https://docs.microsoft.com/en-us/azure/azure-sql/database/migrate-to-database-from-sql-server#method-1- migration-with-downtime-during-the-migration
You have an Azure SQL database named DB1.You have a table name Table1 that has 20 columns of type CHAR(400). Row compression for Table1 is enabled.During a database audit, you discover that none of the fields contain more than 150 characters.You need to ensure that you can apply page compression to Table1.What should you do?
We reduce the max length of the column from 400 to 200.Incorrect:Not A: Sparse column is useful when there are many null columns.The SQL Server Database Engine uses the SPARSE keyword in a column definition to optimize the storage of values in that column. Therefore, when the column value is NULL for any row in the table, the values require no storage.Not B, Not C: SQL Server 2005 got around the limitation of 8KB storage size and provided a workaround with varchar(max). It is a non-Unicode large variable-length character data type and can store a maximum of 2^31- 1 bytes (2 GB) of non-Unicode characters.
https://www.sqlshack.com/sql-varchar-data-type-deep-dive/https://36chambers.wordpress.com/2020/06/18/nvarchar-everywhere-a-thought-experiment/
You have an on-premises Microsoft SQL Server named SQL1 that hosts five databases.You need to migrate the databases to an Azure SQL managed instance. The solution must minimize downtime and prevent data loss.What should you use?
You have an Azure subscription that contains an Azure SQL database. The database contains a table named table1 that uses partitioned columnstores.You need to configure table1 to meet the following requirements:Each partition must be compressed.The compression ratio must be maximized.You must be able to index the compressed data.What should you use?
SQL Server, Azure SQL Database, and Azure SQL Managed Instance support row and page compression for rowstore tables and indexes, and support columnstore and columnstore archival compression for columnstore tables and indexes.For columnstore tables and indexes, all columnstore tables and indexes always use columnstore compression and this is not user configurable.Compressing columnstore indexes with archival compression, causes the index to perform slower than columnstore indexes that do not have the archival compression. Use archival compression only when you can afford to use extra time and CPU resources to compress and retrieve the data.The benefit of archival compression, is reduced storage, which is useful for data that is not accessed frequently. For example, if you have a partition for each month of data, and most of your activity is for the most recent months, you could archive older months to reduce the storage requirements.
https://docs.microsoft.com/en-us/sql/relational-databases/data-compression/data-compression
You have an Azure subscription linked to a Microsoft Entra tenant. The subscription contains 10 virtual machines that run Windows Server 2019 and host Microsoft SQL Server 2019 instances.You need to ensure that you can manage the SQL Server instances by using a single user account.What should you do first?
Share your comments for Microsoft DP-300 exam with other users:
seems good..
took the test last week, i did have about 15 - 20 word for word from this site on the test. (only was able to cram 600 of the questions from this site so maybe more were there i didnt review) had 4 labs, bgp, lacp, vrf with tunnels and actually had to skip a lab due to time. lots of automation syntax questions.
no comments
nice questions bring out the best in you.
really helpful
question #50 and question #81 are exactly the same questions, azure site recovery provides________for virtual machines. the first says that it is fault tolerance is the answer and second says disater recovery. from my research, it says it should be disaster recovery. can anybody explain to me why? thank you
iam thankful for these exam dumps questions, i would not have passed without this exam dumps.
some of the answers seem to be inaccurate. q10 for example shouldnt it be an m custom column?
are the question real or fake?
thank you for providing such assistance.
nice questions
my 3rd purcahse from this site. these exam dumps are helpful. very helpful.
found it good
excellent material
very helpfull
well explained.
i need the pdf, please.
a good source for exam preparation
i need ielts general training audio guide questions
please make this content available
content is good
latest dumps please
aside from pdf the test engine software is helpful. the interface is user-friendly and intuitive, making it easy to navigate and find the questions.
questions and options are correct, but the answers are wrong sometimes. so please check twice or refer some other platform for the right answer
90% of questions was there but i failed the exam, i marked the answers as per the guide but looks like they are not accurate , if not i would have passed the exam given that i saw about 45 of 50 questions from dump
answer to this question "what administrative safeguards should be implemented to protect the collected data while in use by manasa and her product management team? " it should be (c) for the following reasons: this administrative safeguard involves controlling access to collected data by ensuring that only individuals who need the data for their job responsibilities have access to it. this helps minimize the risk of unauthorized access and potential misuse of sensitive information. while other options such as (a) documenting data flows and (b) conducting a privacy impact assessment (pia) are important steps in data protection, implementing a "need to know" access policy directly addresses the issue of protecting data while in use by limiting access to those who require it for legitimate purposes. (d) is not directly related to safeguarding data during use; it focuses on data transfers and location.
password lockout being the correct answer for question 37 does not make sense. it should be geofencing.
for question 4, the righr answer is :recover automatically from failures
question number 4s answer is 3, option c. i
very good questions
i am confused about the answers to the questions. are the answers correct?
very usefull
need certification.