Microsoft Azure Data Fundamentals v1.0 (DP-900)

Page:    1 / 11   
Total 165 questions

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.
Hot Area:




Answer :

Explanation:

Box 1: Yes -

Box 2: Yes -

Box 3: Yes -
Azure Defender provides security alerts and advanced threat protection for virtual machines, SQL databases, containers, web applications, your network, and more.
Azure Defender provides security alerts and advanced threat protection for virtual machines, SQL databases, containers, web applications, your network, and more.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview https://azure.microsoft.com/en-us/blog/announcing-sql-atp-and-sql-vulnerability-assessment-general-availability/ https://docs.microsoft.com/en-us/azure/security-center/azure-defender

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.
Hot Area:




Answer :

Reference:
https://docs.microsoft.com/en-us/sql/big-data-cluster/connect-to-big-data-cluster?view=sql-server-ver15 https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-query-ssms https://docs.microsoft.com/en-us/azure/mariadb/connect-workbench

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.
Hot Area:




Answer :

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview

HOTSPOT -
You have the following SQL query.


What are dbo.Products and ProductName? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:



Answer :

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.
Hot Area:




Answer :

Reference:
https://azure.microsoft.com/en-gb/blog/hot-patching-sql-server-engine-in-azure-sql-database/ https://azure.microsoft.com/en-us/services/sql-database/#product-overview

Which statement is an example of Data Definition Language (DDL)?

  • A. SELECT
  • B. JOIN
  • C. UPDATE
  • D. CREATE


Answer : D

Explanation:
Data Definition Language (DDL) statements defines data structures. Use these statements to create, alter, or drop data structures in a database. These statements include:
✑ ALTER
✑ Collations
✑ CREATE
✑ DROP
✑ DISABLE TRIGGER
✑ ENABLE TRIGGER
✑ RENAME
✑ UPDATE STATISTICS
✑ TRUNCATE TABLE
✑ INSERT
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/statements/statements

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.
Hot Area:




Answer :

Explanation:

Box 1: Yes -
Azure Data Studio is a cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
You can use Azure Data Studio to connect to an Azure SQL Database server. You'll then run Transact-SQL (T-SQL) statements to create and query Azure SQL databases.

Box 2: No -
SQL Server Management Studio is for configuring, managing, and administering all components within Microsoft SQL Server, not to create SQL notebooks.
Instead use Azure Data Studio to create SQL notebook.

Box 3: Yes -
You can use the Azure Data Studio to restore databases.
Reference:
https://docs.microsoft.com/en-us/sql/azure-data-studio/what-is-azure-data-studio

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 DB
  • B. Azure HDInsight
  • C. Azure SQL Database
  • D. Azure Synapse Analytics


Answer : C

Explanation:
Azure SQL Database is relational database and a managed service.
Incorrect Answers:
A, B: Cosmos DB, HDInsight are non-relational databases.
D: Azure Synapse Analytics is for data warehousing, not for Online Transaction Processing
Reference:
https://cloud.netapp.com/blog/azure-cvo-blg-azure-database-review-your-guide-for-database-assessment

What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

  • A. access to the latest features
  • B. complete control over backup and restore processes
  • C. in-database machine learning services
  • D. reduced administrative effort for managing the server infrastructure


Answer : AD

Explanation:
A: Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement.
D: SQL Database delivers predictable performance with multiple resource types, service tiers, and compute sizes. It provides dynamic scalability with no downtime, built-in intelligent optimization, global scalability and availability, and advanced security options. These capabilities allow you to focus on rapid app development and accelerating your time-to-market, rather than on managing virtual machines and infrastructure.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview

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.
Hot Area:




Answer :

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

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 per 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.
Select and Place:



Answer :

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;
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/functions/avg-transact-sql

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

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


Answer : B

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

Which statement is an example of Data Definition Language (DDL)?

  • A. SELECT
  • B. INSERT
  • C. DELETE
  • D. DROP


Answer : D

Explanation:
Data Definition Language (DDL) statements defines data structures. Use these statements to create, alter, or drop data structures in a database. These statements include:
✑ ALTER
✑ Collations
✑ CREATE
✑ DROP
✑ DISABLE TRIGGER
✑ ENABLE TRIGGER
✑ RENAME
✑ UPDATE STATISTICS
✑ TRUNCATE TABLE
✑ UPDATE
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/statements/statements

A team of developers has computers that run Windows 10 and Ubuntu Desktop.
The developers need to connect to and query an Azure SQL database from each of their computers. The developers require code assistance features such as IntelliSense.
What should the developers use?

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


Answer : C

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

HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:




Answer :

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-tde-overview?tabs=azure-portal

Page:    1 / 11   
Total 165 questions