The DP-300 dumps are the best solution for preparing for the Administering Relational Databases on Microsoft Azure exam.
I have received many messages from test candidates:
Can I have cheaper DP-300 dumps?
Will the latest DP-300 dumps help me successfully pass the Administering Relational Databases on Microsoft Azure exam?
Will there be a refund if the DP-300 dumps exam fails?
and so on.
I will answer you, today I will share a 12% discount code in this DP-300 dumps question article, which you can use on any page to enjoy the discount.
DP-300 dumps are reviewed by a professional team to truly guarantee you pass the Administering Relational Databases on Microsoft Azure exam.
I really hate to talk about failures, but candidates can rest assured that leads4pass offers a money-back guarantee, if a customer fails the relevant exam using our product, they can get a 100% refund within 60 days of purchasing our product.
Enter the DP-300 dumps page: https://www.leads4pass.com/dp-300.html, download the PDF file or the VCE exam engine, both tools can help you easily study and successfully pass the Administering Relational Databases on Microsoft Azure exam .
More than just DP-300 exam discounts:
We also provide a selection of free DP-300 exam questions for your reference
Question 1:
What should you do after failover of SalesSQLDb1 to ensure that the database remains accessible to SalesSQLDb1App1?
A. Configure SalesSQLDb1 as writable.
B. Update the connection strings of SalesSQLDb1App1.
C. Update the firewall rules of SalesSQLDb1.
D. Update the users in SalesSQLDb1.
Correct Answer: C
Scenario: SalesSQLDb1 uses database firewall rules and contained database users.
Question 2:
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
Correct Answer: E
Scenario: Authenticate database users by using Active Directory credentials.
(Create a new Azure SQL database named ResearchDB1 on a logical server named ResearchSrv01.)
Authenticate the user in SQL Database or SQL Data Warehouse based on an Azure Active Directory user:
CREATE USER [[email protected]] FROM EXTERNAL PROVIDER;
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-user-transact-sql
Question 3:
Based on the PaaS prototype, which Azure SQL Database compute tier should you use?
A. Business Critical 4-vCore
B. Hyperscale
C. General Purpose v-vCore
D. Serverless
Correct Answer: A
There are CPU and Data I/O spikes for the PaaS prototype. Business Critical 4-vCore is needed.
Incorrect Answers:
B: Hyperscale is for large databases
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/reserved-capacity-overview
Question 4:
You need to design a data retention solution for the Twitter feed data records. The solution must meet the customer sentiment analytics requirements.
Which Azure Storage functionality should you include in the solution?
A. time-based retention
B. change feed
C. lifecycle management
D. soft delete
Correct Answer: C
The lifecycle management policy lets you:
Delete blobs, blob versions, and blob snapshots at the end of their lifecycles
Scenario:
1.
Purge Twitter feed data records that are older than two years.
2.
Store Twitter feeds in Azure Storage by using Event Hubs Capture. The feeds will be converted into Parquet files.
3.
Minimize administrative effort to maintain the Twitter feed data records.
Incorrect Answers:
A: Time-based retention policy support: Users can set policies to store data for a specified interval. When a time-based retention policy is set, blobs can be created and read, but not modified or deleted. After the retention period has expired, blobs can be deleted but not overwritten.
Reference: https://docs.microsoft.com/en-us/azure/storage/blobs/storage-lifecycle-management-concepts
Question 5:
You need to implement the surrogate key for the retail store table. The solution must meet the sales transaction dataset requirements.
What should you create?
A. a table that has a FOREIGN KEYconstraint
B. a table that has an IDENTITY property
C. a user-defined SEQUENCE object
D. a system-versioned temporal table
Correct Answer: B
Scenario: Contoso requirements for the sales transaction dataset include: Implementing a surrogate key to account for changes to the retail store addresses.
A surrogate key on a table is a column with a unique identifier for each row. The key is not generated from the table data. Data modelers like to create surrogate keys on their tables when they design data warehouse models. You can use the IDENTITY property to achieve this goal simply and effectively without affecting load performance.
Question 6:
Which windowing function should you use to perform the streaming aggregation of the sales data?
A. Sliding
B. Hopping
C. Session
D. Tumbling
Correct Answer: D
Scenario: The sales data, including the documents in JSON format, must be gathered as it arrives and analyzed online by using Azure Stream Analytics. The analytics process will perform aggregations that must be done continuously, without gaps, and without overlapping.
Tumbling window functions are used to segment a data stream into distinct time segments and perform a function against them, such as the example below. The key differentiators of a Tumbling window are that they repeat, do not overlap, and an event cannot belong to more than one tumbling window.
Question 7:
Which counter should you monitor for real-time processing to meet the technical requirements?
A. SU% Utilization
B. CPU% utilization
C. Concurrent users
D. Data Conversion Errors
Correct Answer: B
Scenario: Real-time processing must be monitored to ensure that workloads are sized properly based on actual usage patterns.
To monitor the performance of a database in Azure SQL Database and Azure SQL Managed Instance, start by monitoring the CPU and IO resources used by your workload relative to the level of database performance you chose in selecting a particular service tier and performance level.
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/monitor-tune-overview
Question 8:
You have an Azure SQL database named DB3.
You need to provide a user named DevUser with the ability to view the properties of DB3 from Microsoft SQL Server Management Studio (SSMS) as shown in the exhibit. (Click the Exhibit tab.)
Which Transact-SQL command should you run?
A. GRANT SHOWPLAN TO DevUser
B. GRANT VIEW DEFINITION TO DevUser
C. GRANT VIEW DATABASE STATE TO DevUser
D. GRANT SELECT TO DevUser
Correct Answer: C
The exhibits display Database [State] properties.
To query a dynamic management view or function requires SELECT permission on object and VIEW SERVER STATE or VIEW DATABASE STATE permission.
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/databases/database-properties-options-page
Question 9:
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
Correct Answer: C
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,
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/
Question 10:
You plan to perform batch processing in Azure Databricks once daily. Which type of Databricks cluster should you use?
A. automated
B. interactive
C. High Concurrency
Correct Answer: A
Azure Databricks makes a distinction between all-purpose clusters and job clusters. You use all-purpose clusters to analyze data collaboratively using interactive notebooks. You use job clusters to run fast and robust automated jobs.
The Azure Databricks job scheduler creates a job cluster when you run a job on a new job cluster and terminates the cluster when the job is complete.
Reference:
https://docs.microsoft.com/en-us/azure/databricks/clusters
Question 11:
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 on 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: 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?
A. Yes
B. No
Correct Answer: B
Instead, restore Database1 from Server1 to 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
Question 12:
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 on 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
Correct Answer: B
Instead, restore Database1 from Server1 to 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
Question 13:
You have an Always On availability group deployed to Azure virtual machines. The availability group contains a database named DB1 and has two nodes named SQL1 and SQL2. SQL1 is the primary replica.
You need to initiate a full backup of DB1 on SQL2.
Which statement should you run?
A. BACKUP DATABASE DB1 TO URL=\’https://mystorageaccount.blob.core.windows.net/ mycontainer/DB1.bak\’ with (Differential, STATS=5, COMPRESSION);
B. BACKUP DATABASE DB1 TO URL=\’https://mystorageaccount.blob.core.windows.net/ mycontainer/DB1.bak\’ with (COPY_ONLY, STATS=5, COMPRESSION);
C. BACKUP DATABASE DB1 TO URL=\’https://mystorageaccount.blob.core.windows.net/ mycontainer/DB1.bak\’ with (File_Snapshot, STATS=5, COMPRESSION);
D. BACKUP DATABASE DB1 TO URL=\’https://mystorageaccount.blob.core.windows.net/ mycontainer/DB1.bak\’ with (NoInit, STATS=5, COMPRESSION);
Correct Answer: B
BACKUP DATABASE supports only copy-only full backups of databases, files, or filegroups when it\’s executed on secondary replicas. Copy-only backups don\’t impact the log chain or clear the differential bitmap. Incorrect Answers:
A: Differential backups are not supported on secondary replicas. The software displays this error because the secondary replicas support copy-only database backups.
Reference:
Question 14:
You have 10 Azure virtual machines that have SQL Server installed.
You need to implement a backup strategy to ensure that you can restore specific databases to other SQL Server instances. The solution must provide centralized management of the backups.
What should you include in the backup strategy?
A. Automated Backup in the SQL virtual machine settings
B. Azure Backup
C. Azure Site Recovery
D. SQL Server Agent jobs
Correct Answer: B
Azure Backup provides an Enterprise-class backup capability for SQL Server on Azure VMs. All backups are stored and managed in a Recovery Services vault. There are several advantages that this solution provides, especially for Enterprises.
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/backup-restore#azbackup
Question 15:
You need to recommend an availability strategy for an Azure SQL database. The strategy must meet the following requirements:
1.
Support failovers that do not require client applications to change their connection strings.
2.
Replicate the database to a secondary Azure region.
3.
Support failover to the secondary region. What should you include in the recommendation?
A. failover groups
B. transactional replication
C. Availability Zones
D. geo-replication
Correct Answer: D
Active geo-replication is an Azure SQL Database feature that allows you to create readable secondary databases of individual databases on a server in the same or different data center (region). Incorrect Answers:
C: Availability Zones are unique physical locations within a region. Each zone is made up of one or more data centers equipped with independent power, cooling, and networking.
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-overview
……
