Microsoft DP900 Exam Dumps|QAs Page -11

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

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

Microsoft DP900 Exam Dumps – QAs 251-270

Q251. A bank needs to ensure that after an account transfer transaction completes, the revised account balances persists even if the database system hosting the transaction becomes temporarily unavailable.
Of which ACID semantic is this an example?

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

Q252. You have a banking application that transfers money in to and out of accounts.
Of which type of solution is this is an example?

1. online transaction processing (OLTP)
2. online analytical processing (OLAP)
3. extract, transform and load (ETL)
4. a data warehouse

Q253. HOTSPOT-
Select the answer that correctly completes the sentence.

Correct Answer

Reference:
https://support.microsoft.com/en-us/office/excel-formatting-and-features-that-are-not-transferred-to-other-file-formats-8fdd91a3-792e-4aef-a5bb-46f603d0e585

Q254. What is a difference between structured data and semi-structured data?

1. Only Structured data supports entities.
2. Structured data has a fixed schema and semi-structured data has a flexible schema.
3. Structured data has a flexible schema and semi-structured data has a fixed schema.
4. Only Structured data supports attributes.

Q255. DRAG DROP-
Match the Azure Data Lake Storage Gen 2 terms to the appropriate levels in the hierarchy.
To answer, drag the appropriate term from the column on the left to its level on the right. Each term may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

Correct Answer

Q256. 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.

Correct Answer

Q257. DRAG DROP-
Match the job roles to the appropriate tasks.
To answer, drag the appropriate role from the column on the left to its task on the right. Each role may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

Q258. Which language is used to define queries in Azure Synapse Data Explorer?

1. Bash
2. PowerShell
3. KQL
4. SQL

Q259. DRAG DROP-
Match the Azure Cosmos DB APIs to the appropriate data structures.
To answer, drag the appropriate API from the column on the left to its data structure on the right. Each API may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

Correct Answer

Q260. A bank needs to ensure that a transaction involving debiting funds from a source account and crediting the same funds to a destination account must complete both actions. If either action falls to complete, the other action must fail.
Of which ACID semantic is this an example?

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

Q261. SELECT INSERT and UPDATE are examples of which type of SQL statement?

1. Data Definition Language (DDL)
2. Data Control Language (DCL)
3. Data Manipulation Language (DML)

Q262. HOTSPOT-
Select the answer that correctly completes the sentence.

Correct Answer

Q263. HOTSPOT-
Select the answer that correctly completes the sentence.

Correct Answer

Q264. 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.

Correct Answer

Q265. HOTSPOT-
Select the answer that correctly completes the sentence.

Correct Answer

Reference:
https://learn.microsoft.com/en-us/azure/data-explorer/data-explorer-overview

Q266. HOTSPOT-
Select the answer that correctly completes the sentence.

Correct Answer

Q267. HOTSPOT-
Select the answer that correctly completes the sentence.

Correct Answer

Q268. 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)

Q269. 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

Q270. 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