NEW PassLeader Microsoft Data and AI DP-300 Exam Dumps/Braindumps/Practice Tests [VCE & PDF Files]
Part of new Microsoft Data and AI DP-300 exam questions from PassLeader:
NEW QUESTION 1
You have a Microsoft SQL Server 2019 instance in an on-premises datacenter. The instance contains a 4-TB database named DB1. You plan to migrate DB1 to an Azure SQL Database managed instance. What should you use to minimize downtime and data loss during the migration?
A.Distributed Availability Groups
D.Database Migration Assistant
The Data Migration Assistant (DMA) helps you upgrade to a modern data platform by detecting compatibility issues that can impact database functionality in your new version of SQL Server or Azure SQL Database. DMA recommends performance and reliability improvements for your target environment and allows you to move your schema, data, and uncontained objects from your source server to your target server.
NEW QUESTION 2
You have a new Azure SQL database. The database contains a column that stores confidential information. You need to track each time values from the column are returned in a query. The tracking information must be stored for 365 days from the date the query was executed. Which three actions should you perform? (Each correct answer presents part of the solution. Choose three.)
A.Turn on auditing and write audit logs to an Azure Storage account.
B.Add extended properties to the column.
C.Turn on Advanced Data Security for the Azure SQL server.
D.Apply sensitivity labels named Highly Confidential to the column.
E.Turn on Azure Advanced Threat Protection (ATP).
A: An important aspect of the information-protection paradigm is the ability to monitor access to sensitive data. Azure SQL Auditing has been enhanced to include a new field in the audit log called data_sensitivity_information. This field logs the sensitivity classifications (labels) of the data that was returned by a query.
C: Advanced Data Security (ADS) is a unified package for advanced SQL security capabilities. ADS is available for Azure SQL Database, Azure SQL Managed Instance, and Azure Synapse Analytics. It includes functionality for discovering and classifying sensitive data.
D: You can apply sensitivity-classification labels persistently to columns by using new metadata attributes that have been added to the SQL Server database engine. This metadata can then be used for advanced, sensitivity-based auditing and protection scenarios.
NEW QUESTION 3
You have SQL Server on an Azure virtual machine that contains a database named DB1. DB1 contains a table named CustomerPII. You need to record whenever users query the CustomerPII table. Which two options should you enable? (Each correct answer presents part of the solution. Choose two.)
A.server audit specification
B.SQL Server audit
C.database audit specification
D.a server principal
NEW QUESTION 4
You receive numerous alerts from Azure Monitor for an Azure SQL database. You need to reduce the number of alerts. You must only receive alerts if there is a significant change in usage patterns for an extended period. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
A.Set Threshold Sensitivity to High.
B.Set the Alert logic threshold to Dynamic.
C.Set the Alert logic threshold to Static.
D.Set Threshold Sensitivity to Low.
E.Set Force Plan to On.
B: Dynamic Thresholds continuously learns the data of the metric series and tries to model it using a set of algorithms and methods. It detects patterns in the data such as seasonality (Hourly/Daily/Weekly), and is able to handle noisy metrics (such as machine CPU or memory) as well as metrics with low dispersion (such as availability and error rate).
D: Alert threshold sensitivity is a high-level concept that controls the amount of deviation from metric behavior required to trigger an alert.
Not A: High - The thresholds will be tight and close to the metric series pattern. An alert rule will be triggered on the smallest deviation, resulting in more alerts.
Not C: Low - The thresholds will be loose with more distance from metric series pattern. An alert rule will only trigger on large deviations, resulting in fewer alerts.
NEW QUESTION 5
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?
DBCC SHRINKDATABASE shrinks the size of the data and log files in the specified database.
Not D: To shrink one data or log file at a time for a specific database, execute the DBCC SHRINKFILE command.
NEW QUESTION 6
You have SQL Server 2019 on an Azure virtual machine that runs Windows Server 2019. The virtual machine has 4 vCPUs and 28 GB of memory. You scale up the virtual machine to 16 vCPUs and 64 GB of memory. You need to provide the lowest latency for tempdb. What is the total number of data files that tempdb should contain?
The number of files depends on the number of (logical) processors on the machine. As a general rule, if the number of logical processors is less than or equal to eight, use the same number of data files as logical processors. If the number of logical processors is greater than eight, use eight data files and then if contention continues, increase the number of data files by multiples of 4 until the contention is reduced to acceptable levels or make changes to the workload/code.
NEW QUESTION 7
You have an Azure SQL database. You identify a long running query. You need to identify which operation in the query is causing the performance issue. What should you use to display the query execution plan in Microsoft SQL Server Management Studio (SSMS)?
A.Live Query Statistics
B.an estimated execution plan
C.an actual execution plan
NEW QUESTION 8
You have a version-8.0 Azure Database for MySQL database. You need to identify which database queries consume the most resources. Which tool should you use?
C.Query Performance Insight
The Query Store feature in Azure Database for MySQL provides a way to track query performance over time. Query Store simplifies performance troubleshooting by helping you quickly find the longest running and most resource-intensive queries. Query Store automatically captures a history of queries and runtime statistics, and it retains them for your review. It separates data by time windows so that you can see database usage patterns. Data for all users, databases, and queries is stored in the mysql schema database in the Azure Database for MySQL instance.
NEW QUESTION 9
You deploy a database to an Azure SQL Database managed instance. You need to prevent read queries from blocking queries that are trying to write to the database. Which database option should set?
A.PARAMETERIZATION to FORCED
B.PARAMETERIZATION to SIMPLE
C.Delayed Durability to Forced
D.READ_COMMITTED_SNAPSHOT to ON
NEW QUESTION 10
You have an Azure SQL database named Sales. You need to implement disaster recovery for Sales to meet the following requirements:
- During normal operations, provide at least two readable copies of Sales.
- Ensure that Sales remains available if a datacenter fails.
Solution: You deploy an Azure SQL database that uses the Business Critical service tier and Availability Zones.
Does this meet the goal?
Premium and Business Critical service tiers leverage the Premium availability model, which integrates compute resources (sqlservr.exe process) and storage (locally attached SSD) on a single node. High availability is achieved by replicating both compute and storage to additional nodes creating a three to four-node cluster. By default, the cluster of nodes for the premium availability model is created in the same datacenter. With the introduction of Azure Availability Zones, SQL Database can place different replicas of the Business Critical database to different availability zones in the same region. To eliminate a single point of failure, the control ring is also duplicated across multiple zones as three gateway rings (GW).
NEW QUESTION 11
You have two Azure SQL Database servers named Server1 and Server2. Each server contains an Azure SQL database named Database1. You need to restore Database1 from Server1 to Server2. The solution must replace the existing Database1 on Server2.
Solution: From the Azure portal, you delete Database1 from Server2, and then you create a new database on Server2 by using the backup of Database1 from Server1.
Does this meet the goal?
Instead restore Database1 from Server1 to the Server2 by using the RESTORE Transact-SQL command and the REPLACE option.
NEW QUESTION 12
You plan to move two 100-GB databases to Azure. You need to dynamically scale resources consumption based on workloads. The solution must minimize downtime during scaling operations. What should you use?
A.An Azure SQL Database elastic pool.
B.SQL Server on Azure virtual machines.
C.An Azure SQL Database managed instance.
D.Azure SQL databases.
Azure SQL Database elastic pools are a simple, cost-effective solution for managing and scaling multiple databases that have varying and unpredictable usage demands. The databases in an elastic pool are on a single server and share a set number of resources at a set price.
NEW QUESTION 13
NEW QUESTION 41
You have an Azure SQL Database managed instance named sqldbmi1 that contains a database name Sales. You need to initiate a backup of Sales. How should you complete the Transact-SQL statement? (To answer, select the appropriate options in the answer area.)
NEW QUESTION 42
Drag and Drop
You have SQL Server on an Azure virtual machine that contains a database named DB1. DB1 is 30 TB and has a 1-GB daily rate of change. You back up the database by using a Microsoft SQL Server Agent job that runs Transact-SQL commands. You perform a weekly full backup on Sunday, daily differential backups at 01:00, and transaction log backups every five minutes. The database fails on Wednesday at 10:00. Which three backups should you restore in sequence? (To answer, move the appropriate backups from the list of backups to the answer area and arrange them in the correct order.)
NEW QUESTION 43
Case Study - Litware, Inc.
NEW QUESTION 55
You need to identify the cause of the performance issues on SalesSQLDb1. Which two dynamic management views should you use? (Each correct answer presents part of the solution. Choose two.)
NEW QUESTION 56
You need to implement authentication for ResearchDB1. The solution must meet the security and compliance requirements. What should you run as part of the implementation?
A.CREATE LOGIN and the FROM WINDOWS clause
B.CREATE USER and the FROM CERTIFICATE clause
C.CREATE USER and the FROM LOGIN clause
D.CREATE USER and the ASYMMETRIC KEY clause
E.CREATE USER and the FROM EXTERNAL PROVIDER clause
NEW QUESTION 57
Get the newest Microsoft Data and AI DP-300 exam dumps with VCE and PDF from PassLeader:
1. Get More PassLeader NEW Microsoft Data and AI DP-300 Dumps PDF from Google Drive:
2. Get More PassLeader NEW Microsoft Data and AI DP-300 Exam Questions and VCE from: