microsoft.passguide.dp-300.pdf.2024-feb-04.by.quinn.211q.vce

Welcome to download the Newest 2passeasy DP-300 dumps https://www.2passeasy.com/dumps/DP-300/ (224 New Questions) Exam Questions DP-300 Administering Relational Databases on Microsoft Azure (beta) https://www.2passeasy.com/dumps/DP-300/ Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

Welcome to download the Newest 2passeasy DP-300 dumps https://www.2passeasy.com/dumps/DP-300/ (224 New Questions) NEW QUESTION 1 - (Exam Topic 5) 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. NOTE: Each correct selection is worth one point. A. Mastered B. Not Mastered Answer: A Explanation: Box 1: TO URL = 'https://storage1.blob.core.windows.net/blob1/Sales.bak' Native database backup in Azure SQL Managed Instance. You can backup any database using standard BACKUP T-SQL command: BACKUP DATABASE tpcc2501 TO URL = 'https://myacc.blob.core.windows.net/testcontainer/tpcc2501.bak' WITH COPY_ONLY Box 2: WITH COPY_ONLY Reference: https://techcommunity.microsoft.com/t5/azure-sql-database/native-database-backup-in-azure-sql-managed-insta NEW QUESTION 2 - (Exam Topic 5) You have an Azure SQL database named DB 1 in the General Purpose service tier. You need to monitor DB 1 by using SQL Insights. What should you include in the solution? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. A. Mastered B. Not Mastered Answer: A Explanation: Box 1 = Azure Monitor Agent Box 2 = An Azure SQL database https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview?view=azuresql NEW QUESTION 3 - (Exam Topic 5) You have an Azure SQL database. You discover that the plan cache is full of compiled plans that were used only once. You run the select * from sys.database_scoped_configurations Transact-SQL command and receive the results shown in the following table. Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

Welcome to download the Newest 2passeasy DP-300 dumps https://www.2passeasy.com/dumps/DP-300/ (224 New Questions) A. Mastered B. Not Mastered Answer: A Explanation: Text Description automatically generated NEW QUESTION 7 - (Exam Topic 5) You have an Azure subscription that is linked to an Azure AD tenant named contoso.com. The subscription contains an Azure SQL database named SQL 1 and an Azure web named app1. App1 has the managed identity feature enabled. You need to create a new database user for app1. How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. A. Mastered B. Not Mastered Answer: A Explanation: https://learn.microsoft.com/en-us/azure/app-service/tutorial-connect-msi-sql-database?tabs=windowsclient%2Ce NEW QUESTION 8 - (Exam Topic 5) You have the following Transact-SQL query. Which column returned by the query represents the free space in each file? A. ColumnA B. ColumnB C. ColumnC D. ColumnD Answer: C Explanation: Example: Free space for the file in the below query result set will be returned by the FreeSpaceMB column. SELECT DB_NAME() AS DbName, name AS FileName, type_desc, size/128.0 AS CurrentSizeMB, Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

Welcome to download the Newest 2passeasy DP-300 dumps https://www.2passeasy.com/dumps/DP-300/ (224 New Questions) size/128.0 - CAST(FILEPROPERTY(name, 'SpaceUsed') AS INT)/128.0 AS FreeSpaceMB FROM sys.database_files WHERE type IN (0,1); Reference: https://www.sqlshack.com/how-to-determine-free-space-and-file-size-for-sql-server-databases/ NEW QUESTION 9 - (Exam Topic 5) You are building an Azure virtual machine. You allocate two 1-TiB, P30 premium storage disks to the virtual machine. Each disk provides 5,000 IOPS. You plan to migrate an on-premises instance of Microsoft SQL Server to the virtual machine. The instance has a database that contains a 1.2-TiB data file. The database requires 10,000 IOPS. You need to configure storage for the virtual machine to support the database. Which three objects should you create in sequence? To answer, move the appropriate objects from the list of objects to the answer area and arrange them in the correct order. A. Mastered B. Not Mastered Answer: A Explanation: Follow these same steps to create striped virtual disk: Create Log Storage Pool. Create Virtual Disk Create Volume Box 1: a storage pool Box 2: a virtual disk that uses stripe layout Disk Striping: Use multiple disks and stripe them together to get a combined higher IOPS and Throughput limit. The combined limit per VM should be higher than the combined limits of attached premium disks. Box 3: a volume Reference: https://hanu.com/hanu-how-to-striping-of-disks-for-azure-sql-server/ NEW QUESTION 10 - (Exam Topic 5) You have two on-premises Microsoft SQL Server 2019 instances named SQL1 and SQL2. You need to migrate the databases hosted on SQL 1 to Azure. The solution must meet the following requirements: The service that hosts the migrated databases must be able to communicate with SQL2 by using linked server connections. Administrative effort must be minimized. What should you use to host the databases? A. a single Azure SQL database B. an Azure SQL Database elastic pool C. SQL Server on Azure Virtual Machines D. Azure SQL Managed Instance Answer: D NEW QUESTION 10 - (Exam Topic 5) You have SQL Server on Azure virtual machines in an availability group. You have a database named DB1 that is NOT in the availability group. You create a full database backup of DB1. You need to add DB1 to the availability group. Which restore option should you use on the secondary replica? A. Restore with Recovery B. Restore with Norecovery C. Restore with Standby Answer: B Explanation: Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

Welcome to download the Newest 2passeasy DP-300 dumps https://www.2passeasy.com/dumps/DP-300/ (224 New Questions) NEW QUESTION 24 - (Exam Topic 5) 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. A. Mastered B. Not Mastered Answer: A Explanation: Text Description automatically generated Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/single-database-create-arm-template-quickstart NEW QUESTION 27 - (Exam Topic 5) You have an Azure SQL database named sqldb1. You need to minimize the possibility of Query Store transitioning to a read-only state. What should you do? A. Double the value of Data Flush interval B. Decrease by half the value of Data Flush Interval C. Double the value of Statistics Collection Interval D. Decrease by half the value of Statistics Collection interval Answer: B Explanation: The Max Size (MB) limit isn't strictly enforced. Storage size is checked only when Query Store writes data to disk. This interval is set by the Data Flush Interval (Minutes) option. If Query Store has breached the maximum size limit between storage size checks, it transitions to read-only mode. Reference: https://docs.microsoft.com/en-us/sql/relational-databases/performance/best-practice-with-the-query-store NEW QUESTION 30 - (Exam Topic 5) You have four Azure subscriptions. Each subscription contains multiple Azure SQL databases. You need to update the column and index statistics for the databases. What should you use? A. an Azure Automation runbook B. a SQL Agent job C. Azure SQL Analytics D. automatic tuning in Azure SQL Database Answer: A Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

Welcome to download the Newest 2passeasy DP-300 dumps https://www.2passeasy.com/dumps/DP-300/ (224 New Questions) Explanation: Reference: https://www.sqlshack.com/automate-azure-sql-database-indexes-and-statistics-maintenance/ NEW QUESTION 32 - (Exam Topic 5) A data engineer creates a table to store employee information for a new application. All employee names are in the US English alphabet. All addresses are locations in the United States. The data engineer uses the following statement to create the table. You need to recommend changes to the data types to reduce storage and improve performance. Which two actions should you recommend? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. A. Change Salary to the money data type. B. Change PhoneNumber to the float data type. C. Change LastHireDate to the datetime2(7) data type. D. Change PhoneNumber to the bigint data type. E. Change LastHireDate to the date data type. Answer: AE NEW QUESTION 35 - (Exam Topic 5) Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have an Azure Data Lake Storage account that contains a staging zone. You need to design a daily process to ingest incremental data from the staging zone, transform the data by executing an R script, and then insert the transformed data into a data warehouse in Azure Synapse Analytics. Solution: You use an Azure Data Factory schedule trigger to execute a pipeline that executes mapping data flow, and then inserts the data into the data warehouse. Does this meet the goal? A. Yes B. No Answer: B Explanation: If you need to transform data in a way that is not supported by Data Factory, you can create a custom activity, not a mapping flow,5 with your own data processing logic and use the activity in the pipeline. You can create a custom activity to run R scripts on your HDInsight cluster with R installed. Reference: https://docs.microsoft.com/en-US/azure/data-factory/transform-data NEW QUESTION 40 - (Exam Topic 5) You have an Azure SQL database named db1 on a server named server1. You need to modify the MAXDOP settings for db1. What should you do? A. Connect to db1 and run the sp_configure command. B. Connect to the master database of server1 and run the sp_configure command. C. Configure the extended properties of db1. D. Modify the database scoped configuration of db1. Answer: D Explanation: Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/configure-max-degree-of-parallelism NEW QUESTION 42 - (Exam Topic 5) Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

Welcome to download the Newest 2passeasy DP-300 dumps https://www.2passeasy.com/dumps/DP-300/ (224 New Questions) A. Mastered B. Not Mastered Answer: A Explanation: Table Description automatically generated Reference: https://www.sqlshack.com/an-overview-of-the-column-level-sql-server-encryption/ NEW QUESTION 47 - (Exam Topic 5) You have a SQL pool in Azure Synapse that contains a table named dbo.Customers. The table contains a column name Email. You need to prevent nonadministrative users from seeing the full email addresses in the Email column. The users must see values in a format of aXXX@XXXX.com instead. What should you do? A. From the Azure portal, set a mask on the Email column. B. From the Azure portal, set a sensitivity classification of Confidential for the Email column. C. From Microsoft SQL Server Management Studio, set an email mask on the Email column. D. From Microsoft SQL Server Management Studio, grant the SELECT permission to the users for all the columns in the dbo.Customers table except Email. Answer: B Explanation: The Email masking method, which exposes the first letter and replaces the domain with XXX.com using a constant string prefix in the form of an email address. Example: aXX@XXXX.com NEW QUESTION 49 - (Exam Topic 5) You have SQL Server 2019 on an Azure virtual machine that contains an SSISDB database. A recent failure causes the master database to be lost. You discover that all Microsoft SQL Server integration Services (SSIS) packages fail to run on the virtual machine. Which four actions should you perform in sequence to resolve the issue? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct. Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

Welcome to download the Newest 2passeasy DP-300 dumps https://www.2passeasy.com/dumps/DP-300/ (224 New Questions) A. Mastered B. Not Mastered Answer: A Explanation: Step 1: Attach the SSISDB database Step 2: Turn on the TRUSTWORTHY property and the CLR property If you are restoring the SSISDB database to an SQL Server instance where the SSISDB catalog was never created, enable common language runtime (clr) Step 3: Open the master key for the SSISDB database Restore the master key by this method if you have the original password that was used to create SSISDB. open master key decryption by password = 'LS1Setup!' --'Password used when creating SSISDB' Alter Master Key Add encryption by Service Master Key Step 4: Encrypt a copy of the mater key by using the service master key Reference: https://docs.microsoft.com/en-us/sql/integration-services/backup-restore-and-move-the-ssis-catalog NEW QUESTION 53 - (Exam Topic 5) Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have an Azure Synapse Analytics dedicated SQL pool that contains a table named Table1. You have files that are ingested and loaded into an Azure Data Lake Storage Gen2 container named container1. You plan to insert data from the files into Table1 and transform the data. Each row of data in the files will produce one row in the serving layer of Table1. You need to ensure that when the source data files are loaded to container1, the DateTime is stored as an additional column in Table1. Solution: You use an Azure Synapse Analytics serverless SQL pool to create an external table that has an additional DateTime column. Does this meet the goal? A. Yes B. No Answer: A Explanation: In dedicated SQL pools you can only use Parquet native external tables. Native external tables are generally available in serverless SQL pools. Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/create-use-external-tables NEW QUESTION 55 - (Exam Topic 5) You need to trigger an Azure Data Factory pipeline when a file arrives in an Azure Data Lake Storage Gen2 container. Which resource provider should you enable? A. Microsoft.EventHub B. Microsoft.EventGrid C. Microsoft.Sql D. Microsoft.Automation Answer: B Explanation: Event-driven architecture (EDA) is a common data integration pattern that involves production, detection, consumption, and reaction to events. Data integration scenarios often require Data Factory customers to trigger pipelines based on events happening in storage account, such as the arrival or deletion of a file in Azure Blob Storage account. Data Factory natively integrates with Azure Event Grid, which lets you trigger pipelines on such events. Reference: https://docs.microsoft.com/en-us/azure/data-factory/how-to-create-event-trigger NEW QUESTION 56 - (Exam Topic 5) You have an on-premises Microsoft SQL Server 2016 server named Server1 that contains a database named DB1. You need to perform an online migration of DB1 to an Azure SQL Database managed instance by using Azure Database Migration Service. How should you configure the backup of DB1? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

Welcome to download the Newest 2passeasy DP-300 dumps https://www.2passeasy.com/dumps/DP-300/ (224 New Questions) Explanation: Graphical user interface, text, chat or text message Description automatically generated P1: Set the Partition option to Dynamic Range. The SQL Server connector in copy activity provides built-in data partitioning to copy data in parallel. P2: Set the Copy method to PolyBase Polybase is the most efficient way to move data into Azure Synapse Analytics. Use the staging blob feature to achieve high load speeds from all types of data stores, including Azure Blob storage and Data Lake Store. (Polybase supports Azure Blob storage and Azure Data Lake Store by default.) Reference: https://docs.microsoft.com/en-us/azure/data-factory/connector-azure-sql-data-warehouse https://docs.microsoft.com/en-us/azure/data-factory/load-azure-sql-data- warehouse NEW QUESTION 61 - (Exam Topic 5) You are designing an enterprise data warehouse in Azure Synapse Analytics that will store website traffic analytics in a star schema. You plan to have a fact table for website visits. The table will be approximately 5 GB. You need to recommend which distribution type and index type to use for the table. The solution must provide the fastest query performance. What should you recommend? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. A. Mastered B. Not Mastered Answer: A Explanation: Graphical user interface, text, application, table, chat or text message Description automatically generated Box 1: Hash Consider using a hash-distributed table when: The table size on disk is more than 2 GB. The table has frequent insert, update, and delete operations. Box 2: Clustered columnstore Clustered columnstore tables offer both the highest level of data compression and the best overall query performance. Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-distribu https://docs.microsoft.com/en-us/azure/synapse- analytics/sql-data-warehouse/sql-data-warehouse-tables-index NEW QUESTION 64 - (Exam Topic 5) You plan to develop a dataset named Purchases by using Azure Databricks. Purchases will contain the following columns: ProductID ItemPrice LineTotal Quantity StoreID Minute Month Hour Year Day You need to store the data to support hourly incremental load pipelines that will vary for each StoreID. The solution must minimize storage costs. How should you complete the code? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

Welcome to download the Newest 2passeasy DP-300 dumps https://www.2passeasy.com/dumps/DP-300/ (224 New Questions) A. Mastered B. Not Mastered Answer: A Explanation: Graphical user interface, text, application Description automatically generated Box 1: .partitionBy Example: df.write.partitionBy("y","m","d") mode(SaveMode.Append) parquet("/data/hive/warehouse/db_name.db/" + tableName) Box 2: ("Year","Month","Day","Hour","StoreID") Box 3: .parquet("/Purchases") Reference: https://intellipaat.com/community/11744/how-to-partition-and-write-dataframe-in-spark-without-deleting-partiti NEW QUESTION 69 - (Exam Topic 5) You are designing an enterprise data warehouse in Azure Synapse Analytics that will contain a table named Customers. Customers will contain credit card information. You need to recommend a solution to provide salespeople with the ability to view all the entries in Customers. The solution must prevent all the salespeople from viewing or inferring the credit card information. What should you include in the recommendation? A. row-level security B. data masking C. Always Encrypted D. column-level security Answer: B Explanation: Azure SQL Database, Azure SQL Managed Instance, and Azure Synapse Analytics support dynamic data masking. Dynamic data masking limits sensitive data exposure by masking it to non-privileged users. The Credit card masking method exposes the last four digits of the designated fields and adds a constant string as a prefix in the form of a credit card. Example: XXXX-XXXX-XXXX-1234 NEW QUESTION 73 - (Exam Topic 5) You have SQL Server on an Azure virtual machine. You need to use Policy-Based Management in Microsoft SQL Server to identify stored procedures that do not comply with your naming conventions. Which three 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. Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

Welcome to download the Newest 2passeasy DP-300 dumps https://www.2passeasy.com/dumps/DP-300/ (224 New Questions) NEW QUESTION 81 - (Exam Topic 5) You have an Azure SQL database. You are reviewing a slow performing query as shown in the following exhibit. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point. A. Mastered B. Not Mastered Answer: A Explanation: Graphical user interface, text, application, email Description automatically generated Reference: https://docs.microsoft.com/en-us/sql/relational-databases/performance/live-query-statistics?view=sql-server-ver NEW QUESTION 82 - (Exam Topic 5) You are designing a streaming data solution that will ingest variable volumes of data. You need to ensure that you can change the partition count after creation. Which service should you use to ingest the data? Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

Welcome to download the Newest 2passeasy DP-300 dumps https://www.2passeasy.com/dumps/DP-300/ (224 New Questions) A. Azure Event Hubs Standard B. Azure Stream Analytics C. Azure Data Factory D. Azure Event Hubs Dedicated Answer: D Explanation: The partition count for an event hub in a dedicated Event Hubs cluster can be increased after the event hub has been created. Reference: https://docs.microsoft.com/en-us/azure/event-hubs/event-hubs-features#partitions NEW QUESTION 87 - (Exam Topic 5) You are planning disaster recovery for the failover group of an Azure SQL Database managed instance. Your company’s SLA requires that the database in the failover group become available as quickly as possible if a major outage occurs. You set the Read/Write failover policy to Automatic. What are two results of the configuration? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. A. In the event of a datacenter or Azure regional outage, the databases will fail over automatically. B. In the event of an outage, the databases in the primary instance will fail over immediately. C. In the event of an outage, you can selectively fail over individual databases. D. In the event of an outage, you can set a different grace period to fail over each database. E. In the event of an outage, the minimum delay for the databases to fail over in the primary instance will be one hour. Answer: AE Explanation: A: Auto-failover groups allow you to manage replication and failover of a group of databases on a server or all databases in a managed instance to another region. E: Because verification of the scale of the outage and how quickly it can be mitigated involves human actions by the operations team, the grace period cannot be set below one hour. This limitation applies to all databases in the failover group regardless of their data synchronization state. Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/auto-failover-group-overview NEW QUESTION 90 - (Exam Topic 5) Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. 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: You run the Remove-AzSqlDatabase PowerShell cmdlet for Database1 on Server2. You run the Restore-AzSqlDatabase PowerShell cmdlet for Database1 on Server2. Does this meet the goal? A. Yes B. No Answer: B Explanation: Instead restore Database1 from Server1 to the Server2 by using the RESTORE Transact-SQL command and the REPLACE option. Note: REPLACE should be used rarely and only after careful consideration. Restore normally prevents accidentally overwriting a database with a different database. If the database specified in a RESTORE statement already exists on the current server and the specified database family GUID differs from the database family GUID recorded in the backup set, the database is not restored. This is an important safeguard. Reference: https://docs.microsoft.com/en-us/sql/t-sql/statements/restore-statements-transact-sql NEW QUESTION 92 - (Exam Topic 5) You have an Azure SQL database. Users report that the executions of a stored procedure are slower than usual. You suspect that a regressed query is causing the performance issue. You need to view the query execution plan to verify whether a regressed query is causing the issue. The solution must minimize effort. What should you use? A. Performance Recommendations in the Azure portal B. Extended Events in Microsoft SQL Server Management Studio (SSMS) C. Query Store in Microsoft SQL Server Management Studio (SSMS) D. Query Performance Insight in the Azure portal Answer: C Explanation: Use the Query Store Page in SQL Server Management Studio. Query performance regressions caused by execution plan changes can be non-trivial and time consuming to resolve. Since the Query Store retains multiple execution plans per query, it can enforce policies to direct the Query Processor to use a specific execution plan for a query. This is referred to as plan forcing. Plan forcing in Query Store is provided by using a mechanism similar to the USE PLAN query hint, but it does not require any change in user applications. Plan forcing can resolve a query performance regression caused by a plan change in a very short period of time. Reference: Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

Welcome to download the Newest 2passeasy DP-300 dumps https://www.2passeasy.com/dumps/DP-300/ (224 New Questions) Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. A. Mastered B. Not Mastered Answer: A Explanation: Graphical user interface, table Description automatically generated Box 1: CSV files that have file named beginning with "tripdata_2020" Box 2: a header FIRSTROW = 'first_row' Specifies the number of the first row to load. The default is 1 and indicates the first row in the specified data file. The row numbers are determined by counting the row terminators. FIRSTROW is 1-based. Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-openrowset NEW QUESTION 105 - (Exam Topic 5) You have an Azure Data Factory that contains 10 pipelines. You need to label each pipeline with its main purpose of either ingest, transform, or load. The labels must be available for grouping and filtering when using the monitoring experience in Data Factory. What should you add to each pipeline? A. an annotation B. a resource tag C. a run group ID D. a user property E. a correlation ID Answer: A Explanation: Azure Data Factory annotations help you easily filter different Azure Data Factory objects based on a tag. You can define tags so you can see their performance or find errors faster. Reference: https://www.techtalkcorner.com/monitor-azure-data-factory-annotations/ NEW QUESTION 110 - (Exam Topic 5) 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? A. Query Store B. Metrics C. Query Performance Insight Passing Certification Exams Made Easy visit - https://www.2PassEasy.com

Welcome to download the Newest 2passeasy DP-300 dumps https://www.2passeasy.com/dumps/DP-300/ (224 New Questions) D. Alerts Answer: A Explanation: 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. Reference: https://docs.microsoft.com/en-us/azure/mysql/concepts-query-store NEW QUESTION 114 - (Exam Topic 5) You have the following Azure Data Factory pipelines: Ingest Data from System1 Ingest Data from System2 Populate Dimensions Populate Facts Ingest Data from System1 and Ingest Data from System2 have no dependencies. Populate Dimensions must execute after Ingest Data from System1 and Ingest Data from System2. Populate Facts must execute after the Populate Dimensions pipeline. All the pipelines must execute every eight hours. What should you do to schedule the pipelines for execution? A. Add a schedule trigger to all four pipelines. B. Add an event trigger to all four pipelines. C. Create a parent pipeline that contains the four pipelines and use an event trigger. D. Create a parent pipeline that contains the four pipelines and use a schedule trigger. Answer: D Explanation: Reference: https://www.mssqltips.com/sqlservertip/6137/azure-data-factory-control-flow-activities-overview/ NEW QUESTION 116 - (Exam Topic 5) You have an Azure subscription that contains an Azure SQL database named SQL1. SQL1 is in an Azure region that does not support availability zones. You need to ensure that you have a secondary replica of SQLI in the same region. What should you use? A. log shipping B. auto-failover groups C. active geo-replication D. Microsoft SQL Server failover clusters Answer: C NEW QUESTION 120 - (Exam Topic 5) You have SQL Server on an Azure virtual machine named SQL1. SQL1 has an agent job to back up all databases. You add a user named dbadmin1 as a SQL Server Agent operator. You need to ensure that dbadmin1 receives an email alert if a job fails. Which three 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. A. Mastered B. Not Mastered Answer: A Explanation: Step 1: Enable the email settings for the SQL Server Agent. Passing Certification Exams Made Easy visit - https://www.2PassEasy.com