UncategorizedCI Automation on Terraform – Whizlabs Webinar
March 24, 2023
Create an imaginative backyard garden with unique decorations from BackyardGardenershop. Find statues, figurines, fountains & water gardens and more.
Hello, Data enthusiasts. Here are some questions for Microsoft Azure Database Administrator Associate Certification Exam DP-300. The bottom of the page contains correct answers and explanations. You can find the TestPrep reference link at end of this blog post.
Here’s the Quiz:
A Microsoft SQL Server 2019 instance is located in an on-premises database center. You have a Microsoft SQL Server 2019 instance that contains a 4-TB database called DB1. You plan to migrate DB1 from the on-premises datacenter to an Azure SQL Database managed instance. Distributed availability groupsb. Mirroring databasec. log shippingd. Database Migration Assistant
You have 20 Azure SQL database databases that you have provisioned using the vCore buying model. Now you want to create an Azure SQL Database elastic pools and add these 20 databases. Each correct answer reveals a part of the solution. Total size of all databasesb. Number of concurrently peaking database * Peak CPU utilization per databasec. Maximum number of concurrent sessions per databased. Total number of databases * Average CPU usage per databasee. geo-replication support.
You have created a new Azure SQL database. You have a new Azure SQL database. The column contains confidential information. You need to track every time values from this column are returned in a query. The query was executed on the database. You must keep the tracking information for 365 days. Each correct answer reveals a part of the solution. Add extended properties to the column. Add sensitive labels called Highly Confidential to this column. Turn on Azure Advanced Threat Protection. Turn on auditing, and log audit logs to an Azure Storage Account.e. Advanced-Data Security is enabled for the Azure SQL server.
SQL Server is installed on an Azure virtual machine. It contains a database called DB1. You have SQL Server running on an Azure virtual machine that contains a database named DB1. It contains a table called CustomerPII. You need to record when customers query this table. Each correct answer reveals a part of the solution.a SQL Server auditb. database audit specificationc. server audit specificationd. A server principal.
You have an Azure SQL Database named sqldb1. You want to minimize the chance of Query Store changing to a read-only status. Reduce by half the value Statistics Collection intervalb. Double the value Statistics Collection Intervalc. Diminish by half the Value of Data Flush Intervald. Double the Data Flush interval
SQL Server 2019 is installed on an Azure virtual machine running Windows Server 2019. You have SQL Server 2019 on an Azure virtual machine that runs Windows Server 2019. 2b. 4c. 6d. 8
An Azure virtual machine hosts SQL Server. It contains a database called DB1. An application queries DB1 to produce a sales report. You want to see the parameter values since the last query was executed. What are the two actions you should take? Each correct answer reveals a part of the solution.a Enable Lightweight_Query_Profiling in DB1b. Enable PARAMETER_SNIFFING within DB1c. Enable Last_Query_Plan_Stats in the master databased. Enable Last_Query_Plan_Stats in DB1e. Enable Lightweight_Query_Profiling in the master database
You will not be able to go back to this section after you have answered a question. These questions will not be displayed in the review screen. You have an Azure SQL Database named Sales. * Make sure that Sales is available in the event of a failure at a datacenter.