Skip to Content

DP-900 Microsoft Azure Data Fundamentals Exam Questions and Answers – Page 1 Part 2

By: Author Alex Lim

Posted on

Categories Exam

The latest Microsoft DP-900 Azure Data Fundamentals certification actual real practice exam question and answer (Q&A) dumps are available free, which are helpful for you to pass the Microsoft DP-900 Azure Data Fundamentals exam and earn Microsoft DP-900 Azure Data Fundamentals certification.

DP-900 Question 91

Exam Question

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

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

Correct Answer

D. CREATE

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

Microsoft Learn > SQL > SQL Server > Transact-SQL statements

DP-900 Question 92

Exam Question

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

Statement 1: You must apply operating system updates to Azure SQL databases regularly.
Statement 2: You need a Microsoft 365 subscription to create an Azure SQL database.
Statement 3: You can use existing Microsoft SQL Server licenses to reduce the cost of Azure SQL databases.

Correct Answer

Statement 1: You must apply operating system updates to Azure SQL databases regularly: No
Statement 2: You need a Microsoft 365 subscription to create an Azure SQL database: No
Statement 3: You can use existing Microsoft SQL Server licenses to reduce the cost of Azure SQL databases: Yes

Reference

This is what hot patching looks like under the covers. If you’re interested in the low-level details.

DP-900 Question 93

Exam Question

You have the following SQL query.

INSERT INTO dbo.Products (ProductID, ProductName, Price, ProductDescription) VALUES (1, 'Clamp', 12.48, 'Workbench clamp');

What are dbo.Products and ProductName?

dbo.Products: __________

A. A column
B. A database
C. A table
D. An index

ProductName: __________

A. A column
B. A database
C. A table
D. An index

Correct Answer

dbo.Products: A table
ProductName: A column

DP-900 Question 94

Exam Question

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

Statement 1: Platform as a service (PaaS) database offerings in Azure provide built-in high availability.
Statement 2: Platform as a service (PaaS) database offerings in Azure provide configurable scaling options.
Statement 3: Platform as a service (PaaS) database offerings in Azure reduce the administrative overhead for managing hardware.

Correct Answer

Statement 1: Platform as a service (PaaS) database offerings in Azure provide built-in high availability: Yes
Statement 2: Platform as a service (PaaS) database offerings in Azure provide configurable scaling options: Yes
Statement 3: Platform as a service (PaaS) database offerings in Azure reduce the administrative overhead for managing hardware: Yes

Reference

Microsoft Learn > Azure SQL Database (SQL DB) > What is Azure SQL Database?

DP-900 Question 95

Exam Question

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

Statement 1: You can use Azure Data Studio to query a Microsoft SQL Server big data cluster.
Statement 2: You can use Microsoft SQL Server Management Studio (SSMS) to query an Azure Synapse Analytics data warehouse.
Statement 3: You can use MySQL Workbench to query Azure Database for MariaDB databases.

Correct Answer

Statement 1: You can use Azure Data Studio to query a Microsoft SQL Server big data cluster: Yes
Statement 2: You can use Microsoft SQL Server Management Studio (SSMS) to query an Azure Synapse Analytics data warehouse: Yes
Statement 3: You can use MySQL Workbench to query Azure Database for MariaDB databases: Yes

Reference

DP-900 Question 96

Exam Question

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

Statement 1: Azure SQL Database includes a managed backup service.
Statement 2: Azure SQL Database has built-in high availability.
Statement 3: Azure SQL Database can use Azure Defender.

Correct Answer

Statement 1: Azure SQL Database includes a managed backup service: Yes
Statement 2: Azure SQL Database has built-in high availability: Yes
Statement 3: Azure SQL Database can use Azure Defender: Yes

Explanation

Azure Defender provides security alerts and advanced threat protection for virtual machines, SQL databases, containers, web applications, your network, and more.

Reference

DP-900 Question 97

Exam Question

Which command-line tool can you use to query Azure SQL databases?

A. sqlcmd
B. bcp
C. azdata
D. Azure CLI

Correct Answer

A. sqlcmd

Explanation

The sqlcmd utility lets you enter Transact-SQL statements, system procedures, and script files at the command prompt.

Incorrect Answers:
B: The bulk copy program utility (bcp) bulk copies data between an instance of Microsoft SQL Server and a data file in a user-specified format.
D: The Azure CLI is the defacto tool for cross-platform and command-line tools for building and managing Azure resources.

Reference

Microsoft Learn >SQL >SQL Server > SQL tools overview

DP-900 Question 98

Exam Question

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

Statement 1: Relational database tables contain columns and rows.
Statement 2: Indexes in a relational database describe the data types in a table.
Statement 3: A database view is a virtual table whose content is defined by a query.

Correct Answer

Statement 1: Relational database tables contain columns and rows: Yes
Statement 2: Indexes in a relational database describe the data types in a table: No
Statement 3: A database view is a virtual table whose content is defined by a query: Yes

Explanation

Statement 1: Relational database tables contain columns and rows: Yes
Tables are database objects that contain all the data in a database. In tables, data is logically organized in a row-and-column format similar to a spreadsheet. Each row represents a unique record, and each column represents a field in the record.

Statement 2: Indexes in a relational database describe the data types in a table: No
An index is an on-disk structure associated with a table or view that speeds retrieval of rows from the table or view.

Statement 3: A database view is a virtual table whose content is defined by a query: Yes
A view is a virtual table whose contents are defined by a query. Like a table, a view consists of a set of named columns and rows of data.

Reference

DP-900 Question 99

Exam Question

Match the tools to the appropriate descriptions. Each tool may be used once, more than once, or not at all.

Tools:

  • Azure Data Studio
  • Microsoft SQL Server Data Tools (SSDT)
  • Microsoft SQL Server Management Studio (SSMS)
  • Microsoft Visual Studio Code

Descriptions:

  • A graphical tool for managing SQL Server or Azure SQL databases that supports access, configuration, management, and administration tasks.
  • A lightweight source code editor with an mssql extension that supports connections to SQL Server and a rich editing experience for T-SQL.
  • A lightweight editor that can run on-demand SQL queries and view and save results as text, JSON, or Microsoft Excel files.
  • A development tool for building Azure SQL databases, Microsoft SQL Server relational databases, SQL Server Analysis Services (SSAS) data models, SQL Server Integration Services (SSIS) packages, and SQL Server Reporting Services (SSRS) reports.

Correct Answer

Microsoft SQL Server Management Studio (SSMS): A graphical tool for managing SQL Server or Azure SQL databases that supports access, configuration, management, and administration tasks.

Microsoft Visual Studio Code: A lightweight source code editor with an mssql extension that supports connections to SQL Server and a rich editing experience for T-SQL.

Azure Data Studio: A lightweight editor that can run on-demand SQL queries and view and save results as text, JSON, or Microsoft Excel files.

Microsoft SQL Server Data Tools (SSDT): A development tool for building Azure SQL databases, Microsoft SQL Server relational databases, SQL Server Analysis Services (SSAS) data models, SQL Server Integration Services (SSIS) packages, and SQL Server Reporting Services (SSRS) reports.

Explanation

Microsoft SQL Server Management Studio (SSMS): A graphical tool for managing SQL Server or Azure SQL databases that supports access, configuration, management, and administration tasks.

SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database.

Microsoft Visual Studio Code: A lightweight source code editor with an mssql extension that supports connections to SQL Server and a rich editing experience for T-SQL.

Visual Studio Code is a streamlined code editor with support for development operations like debugging, task running, and version control. It aims to provide just the tools a developer needs for a quick code-build-debug cycle and leaves more complex workflows to fuller featured IDEs, such as Visual Studio IDE.

Azure Data Studio: A lightweight editor that can run on-demand SQL queries and view and save results as text, JSON, or Microsoft Excel files.

Azure Data Studio offers a modern, keyboard-focused SQL coding experience that makes your everyday tasks easier with built-in features, such as multiple tab windows, a rich SQL editor, IntelliSense, keyword completion, code snippets, code navigation, and source control integration (Git). Run on-demand SQL queries, view and save results as text, JSON, or Excel. Edit data, organize your favorite database connections, and browse database objects in a familiar object browsing experience.

Microsoft SQL Server Data Tools (SSDT): A development tool for building Azure SQL databases, Microsoft SQL Server relational databases, SQL Server Analysis Services (SSAS) data models, SQL Server Integration Services (SSIS) packages, and SQL Server Reporting Services (SSRS) reports.

SQL Server Data Tools (SSDT) is a modern development tool for building SQL Server relational databases, databases in Azure SQL, Analysis Services (AS) data models, Integration Services (IS) packages, and Reporting Services (RS) reports. With SSDT, you can design and deploy any SQL Server content type with the same ease as you would develop an application in Visual Studio.

Reference

DP-900 Question 100

Exam Question

You have an Azure SQL database that you access directly from the Internet.

You recently changed the public IP address of your computer.

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. role-based access control (RBAC)
B. Dynamic Host Configuration Protocol (DHCP)
C. Domain Name Service (DNS)
D. a database-level firewall

Correct Answer

D. a database-level firewall

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.