DP-300最新練習資料、DP-300練習問題集、DP-300試験内容DP-300認定試験の準備をするために一生懸命勉強して疲れを感じるときには、他の人が何をしているかを知っていますか。あなたと同じIT認定試験を受験する周りの人を見てください。あなたが試験のために不安と感じているとき、どうして他の人が自信満々で、のんびり見ているのでしょうか。あなたの能力は彼らうより弱いですか。もちろんそんなことはないです。では、なぜ他の人が簡単にDP-300試験に合格することができるかを知りたいですか。それは彼らがTech4Exam のDP-300問題集を利用したからです。この問題集を勉強することだけで楽に試験に合格することができます。信じないのですか。不思議を思っていますか。では、急いで試してください。まず問題集のdemoを体験することができます。そうすれば、この問題集の品質を確認することができます。はやくTech4Examのサイトをクリックしてください。 Microsoft Administering Relational Databases on Microsoft Azure 認定 DP-300 試験問題 (Q35-Q40):質問 # 35
What should you implement to meet the disaster recovery requirements for the PaaS solution?
A. failover groups
B. geo-replication
C. Always On availability groups
D. Availability Zones
正解：A
解説：
Scenario: In the event of an Azure regional outage, ensure that the customers can access the PaaS solution with minimal downtime. The solution must provide automatic failover.
The auto-failover groups feature allows you to manage the replication and failover of a group of databases on a server or all databases in a managed instance to another region. It is a declarative abstraction on top of the existing active geo-replication feature, designed to simplify deployment and management of geo-replicated databases at scale. You can initiate failover manually or you can delegate it to the Azure service based on a user-defined policy.
The latter option allows you to automatically recover multiple related databases in a secondary region after a catastrophic failure or other unplanned event that results in full or partial loss of the SQL Database or SQL Managed Instance availability in the primary region.
Reference: https://docs.microsoft.com/en-us ... over-group-overview
Topic 1, Contoso Ltd
Existing Environment
Contoso, Ltd. is a financial data company that has 100 employees. The company delivers financial data to customers.
Active Directory
Contoso has a hybrid Azure Active Directory (Azure AD) deployment that syncs to on-premises Active Directory.
Database Environment
Contoso has SQL Server 2017 on Azure virtual machines shown in the following table.
SQL1 and SQL2 are in an Always On availability group and are actively queried. SQL3 runs jobs, provides historical data, and handles the delivery of data to customers.
The on-premises datacenter contains a PostgreSQL server that has a 50-TB database.
Current Business Model
Contoso uses Microsoft SQL Server Integration Services (SSIS) to create flat files for customers. The customers receive the files by using FTP.
Requirements
Planned Changes
Contoso plans to move to a model in which they deliver data to customer databases that run as platform as a service (PaaS) offerings. When a customer establishes a service agreement with Contoso, a separate resource group that contains an Azure SQL database will be provisioned for the customer. The database will have a complete copy of the financial data. The data to which each customer will have access will depend on the service agreement tier. The customers can change tiers by changing their service agreement.
The estimated size of each PaaS database is 1 TB.
Contoso plans to implement the following changes:
Business Goals
Contoso identifies the following business requirements:
Technical Requirements
Contoso identifies the following technical requirements:
Monitoring Requirements
Contoso identifies the following monitoring requirements:
PaaS Prototype
During prototyping of the PaaS solution in Azure, you record the compute utilization of a customer's Azure SQL database as shown in the following exhibit.
Role Assignments
For each customer's Azure SQL Database server, you plan to assign the roles shown in the following exhibit.
質問 # 36
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. 正解：
解説：
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/communit ... t-deleting-partitio
質問 # 37
You have an Azure SQL database named DB1 that contains a private certificate named Sales. The private key for Sales is encrypted with a password. You need to change the password for the private key. Which Transact-SQL statement should you run?
A)
B)
C)
D)
A. Option D
B. Option B
C. Option A
D. Option C
正解：D
質問 # 38
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: 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
正解：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 ... ements-transact-sql
質問 # 39
You have a Microsoft SQL Server 2019 database named DB1 that uses the following database-level and instance-level features.
* Clustered columnstore indexes
* Automatic tuning
* Change tracking
* PolyBase
You plan to migrate DB1 to an Azure SQL database.
What feature should be removed or replaced before DB1 can be migrated?
