Microsoft DP900 Exam Dumps|QAs Page -3

Last updated on October 16th, 2024 at 03:51 pm

Microsoft DP900 Exam Dumps post contains real and latest questions for Microsoft Azure Fundamentals.

Microsoft DP900 Exam Dumps – QAs 51-75

Q51. Which property of a transactional workload guarantees that each transaction is treated as a single unit that either succeeds completely or fails completely?

1. atomicity
2. isolation
3. durability
4. consistency

Q52. HOTSPOT –
Select the answer that correctly completes the sentence.

Correct Answer

Q53. You are writing a set of SQL queries that administrators will use to troubleshoot an Azure SQL database.
You need to embed documents and query results into a SQL notebook.
What should you use?

1. Microsoft SQL Server Management Studio (SSMS)
2. Azure Data Studio
3. Azure CLI
4. Azure PowerShell

Q54. HOTSPOT –
Select the answer that correctly completes the sentence.
Hot Area:

Correct Answer

Reference:
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

Q55. HOTSPOT –
Select the answer that correctly completes the sentence.
Hot Area:

Correct Answer

Reference:
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

Q56. You have an inventory management database that contains the following table.

Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?

1. INSERT
2. MERGE
3. UPDATE
4. CREATE

Q57. Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance.
Which Azure service should you use?

1. Azure HDInsight
2. Azure SQL Database
3. Azure Cosmos DB
4. SQL Server on Azure Virtual Machines

Q58. HOTSPOT –
Select the answer that correctly completes the sentence.
Hot Area:

Correct Answer

Reference:
https://www.ibm.com/cloud/blog/structured-vs-unstructured-data

Q59. DRAG DROP –
Match the tools to the appropriate descriptions.
To answer, drag the appropriate tool from the column on the left to its description on the right. Each tool may be used once, more than once, or not at all.
Select and Place:

Correct Answer

Reference:
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms
https://docs.microsoft.com/en-us/sql/azure-data-studio/what-is-azure-data-studio
https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt

Q60. 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:

Correct Answer

Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/tables/tables
https://docs.microsoft.com/en-us/sql/relational-databases/indexes/clustered-and-nonclustered-indexes-described
https://docs.microsoft.com/en-us/sql/relational-databases/views/views?view=sql-server-ver15

Q61. DRAG DROP –
Match the terms to the appropriate descriptions.
To answer, drag the appropriate term from the column on the left to its description on the right. Each term may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:

Correct Answer

Reference:
https://en.wikipedia.org/wiki/Table_(database)
https://en.wikipedia.org/wiki/View_(SQL)
https://en.wikipedia.org/wiki/Database_index

Q62. 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?

1. role-based access control (RBAC)
2. Dynamic Host Configuration Protocol (DHCP)
3. Domain Name Service (DNS)
4. a database-level firewall

Q63. You have a data store that has the structure shown in the following exhibit.

Which type of data store is this?

1. key/value
2. object data
3. graph
4. time series

Q64. HOTSPOT –
Select the answer that correctly completes the sentence.
Hot Area:

Correct Answer

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/azure-sql-iaas-vs-paas-what-is-overview?view=azuresql

Q65. HOTSPOT –
Select the answer that correctly completes the sentence.
Hot Area:

Correct Answer

Reference:
https://docs.snowflake.com/en/user-guide/semistructured-considerations.html

Q66. You have an e-commerce application that reads and writes data to an Azure SQL database.
Which type of processing does the application use?

1. stream processing
2. batch processing
3. Online Analytical Processing (OLAP)
4. Online Transaction Processing (OLTP)

Q67. When can you use an Azure Resource Manager template?

1. to automate the creation of an interdependent group of Azure resources in a repeatable way
2. to apply Azure policies for multi-tenant deployments
3. to provision Azure subscriptions
4. to control which services and feature administrators and developers can deploy from the Azure portal

Q68. HOTSPOT –
Select the answer that correctly completes the sentence.
Hot Area:

Correct Answer

Reference:
https://www.edureka.co/blog/data-analyst-vs-data-engineer-vs-data-scientist/

Q69. 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:

Correct Answer

Q70. Which type of database contains nodes and edges?

1. graph
2. key/value
3. columnar
4. time series

Q71. 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:

Correct 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

Q72. 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:

Correct Answer

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

1. sqlcmd
2. bcp
3. azdata
4. Azure CLI

Q74. 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:

Correct Answer

Reference:
https://docs.microsoft.com/en-us/sql/azure-data-studio/what-is-azure-data-studio

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

1. SELECT
2. JOIN
3. UPDATE
4. CREATE