Microsoft DP900 Exam Dumps|QAs Page -10

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 226-250

Q226. DRAG DROP-
Match the data processing languages to the appropriate real-time analytics services.
To answer, drag the appropriate language from the column on the left to its service on the right. Each language may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

Correct Answer

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

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

Correct Answer

Q229. Which file format has defined names and data types for each column and uses compressed columnar storage?

1. HTML
2. CSV
3. Apache Parquet
4. JSON

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

Correct Answer

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

Correct Answer

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

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

Correct Answer

Reference:
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-publish-to-web

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

Correct Answer

Q235. You have structured data in tabular format.
What represents an individual instance of a data entity?

1. a column
2. a table
3. a cell
4. a row

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

Correct Answer

Q237. A retail point of sale (POS) system is an example of which type of solution?

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

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

Q239. DRAG DROP-
Match the data storage options to the appropriate types of data.
To answer, drag the appropriate data storage option from the column on the left to its data type on the right. Each data storage option may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

Correct Answer

Q240. Which type of Azure resource supports the serverless configuration of an Azure SQL database?

1. SQL Server on Azure Virtual Machines
2. an Azure SQL Database elastic pool
3. a single database in Azure SQL Database
4. Azure SQL Managed Instance

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

Correct Answer

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

Correct Answer

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

Q244. Which activity is most common for transactional workloads?

1. recording small units of work events in real time
2. aggregating massive amounts of data
3. producing complex reports
4. performing self-service data exploration

Q245. Which statement is an example of Data Manipulation Language (DML)?

1. INSERT
2. ALTER
3. DROP
4. CREATE

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

Correct Answer

Q247. Blob rehydration occurs in Azure Blob storage when a blob moves between which access tiers?

1. Hot to Cool
2. Hot to Archive
3. Cool to Archive
4. Archive to Cool

Q248. Which Azure Cosmos DB API should you use for a graph database?

1. Azure Cosmos DB for Table
2. Azure Cosmos DB for Apache Cassandra
3. Azure Cosmos DB for NoSQL
4. Azure Cosmos DB for Apache Gremlin

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

Correct Answer

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

Correct Answer