Microsoft DP-900 問題練習

Question No : 1
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.

答えを確認する

正解:


Explanation:
Reference: https://www.bmc.com/blogs/what-is-batch-processing-batch-processing-explained/

Question No : 2
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.

答えを確認する

正解:


Explanation:
Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl

Question No : 3
HOTSPOT
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

答えを確認する

正解:


Explanation:
Reference: https://www.sqlshack.com/what-is-database-normalization-in-sql-server/

Question No : 4
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.

答えを確認する

正解:


Explanation:
Reference: https://demand-planning.com/2020/01/20/the-differences-between-descriptive-diagnostic-predictive-cognitive-analytics/

Question No : 5
HOTSPOT
To complete the sentence select the appropriate option in the answer area.

答えを確認する

正解:

Question No : 6
A team of developers has computers Thai run Windows 10 and Ubuntu Desktop.
The developers need to connect to and query an Azure SQL database from the computers. The developers require code assistance features such as intellSense.
What should the developers use ?

• A.Azure Data Studio
• B.sq1cmd
• C.Microsoft SQL Server Management Studio (SSMS)
• D.Azure Data Explorer

答えを確認する

正解:
Explanation:
Azure Data Studio is a cross-platform database tool for data professionals who use on-premises and cloud data platforms on Windows, macOS, and Linux.
Azure Data Studio offers a modern editor experience with IntelliSense, code snippets, source control integration, and an integrated terminal.
Reference: https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio

Question No : 7
HOTSPOT
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

答えを確認する

正解:

Question No : 8
DRAG DROP
You have a table named Sales that contains the following data.



You need to query the table to return the average sales amount day.
The output must produce the following results.



How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

答えを確認する

正解:


Explanation:
Box 1: SELECT
Box 2: GROUP BY
Example:
When used with a GROUP BY clause, each aggregate function produces a single value covering each group, instead of a single value covering the whole table. The following example produces summary values for each sales territory in the AdventureWorks2012 database. The summary lists the average bonus received by the sales people in each territory, and the sum of year-to-date sales for each territory.
SELECT TerritoryID, AVG(Bonus)as 'Average bonus', SUM(SalesYTD) as 'YTD sales'
FROM Sales.SalesPerson
GROUP BY TerritoryID;

Question No : 9
What Is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?

• A.native support for cross-database queries and transactions
• B.built-in high availability
• C.system-Initiated automatic backups
• D.support for encryption at rest

答えを確認する

正解:
Explanation:
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/features-comparison

Question No : 10
HOTSPOT
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

答えを確認する

正解:

Question No : 11
When you create an Azure SQL database, which account can always connect to the database ?

• A.the Azure Active director/ (Azure AO) account that created the database
• B.the Azure Active Directly Azure AD) administrator account
• C.the sa account
• D.the server admin login account of the logical server

答えを確認する

正解:
Explanation:
When you first deploy Azure SQL, you specify an admin login and an associated password for that login. This administrative account is called Server admin.
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/single-database-create-quickstart

Question No : 12
You have an Azure SQL database that you access directly from the internet.
You recently changed your external IP address.
After changing the IP address, you can no longer access the database. You can connect to other resources in Azure
What is a possible cause of the issue?

• A.a database-level firewall
• B.role-based access control (RSAC)
• C.Dynamic Host Configuration Protocol (DHCP)
• D.Domain Name Service (DNS)

答えを確認する

正解:
Explanation:
The Azure SQL Database firewall lets you decide which IP addresses may or may not have access to either your Azure SQL Server or your Azure SQL database.
When creating an Azure SQL Database, the firewall needs to be configured before anyone will be able to access the database. By default, no external access to your SQL Database will be allowed until you explicitly assign permission by creating a firewall rule.
Reference: https://www.sqlshack.com/configuring-the-azure-sql-database-firewall/

Question No : 13
HOTSPOT
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

答えを確認する

正解:


Explanation:
Box 1: No
Microsoft handles all patching and updating of the SQL and operating system code. You don't have to manage the underlying infrastructure.
Box 2: Yes
SQL Database is a fully managed service that has built-in high availability, backups, and other common maintenance operations.
Box 3: No
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview

Question No : 14
You are deploying a software as a service (SaaS) application that requires a relational database for Online Transaction Processing (OLTP).
Which Azure service should you use to support the application?

• A.Azure Cosmos D3
• B.Azure Synapse Analytics
• C.Azure HCMmtghi
• D.Azure SQL Database

答えを確認する

正解:
Explanation:
Azure SQL Database is relational database and a managed service.
Reference: https://cloud.netapp.com/blog/azure-cvo-blg-azure-database-review-your-guide-for-database-assessment

Question No : 15
Your company needs to ensure that in Azure virtual machine can connect to Azure SQL databases without exposing the databases to the internet.
What should you use?

• A.Azure DNS
• B.Azure Application Gateway
• C.Azure Private link
• D.Azure Traffic Manager

答えを確認する

正解:
Explanation:
Azure Private Link enables you to access Azure PaaS Services (for example, Azure Storage and SQL Database) and Azure hosted customer-owned/partner services over a private endpoint in your virtual network.
Traffic between your virtual network and the service travels the Microsoft backbone network. Exposing your service to the public internet is no longer necessary
Reference: https://techcommunity.microsoft.com/t5/azure-database-support-blog/azure-sql-db-private-link-private-endpoint-connectivity/ba-p/1235573