Microsoft DP900 Exam Dumps|QAs Page -8

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 176-200

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

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

Correct Answer

Q178. You need to create a visualization of running sales totals per quarter as shown in the following exhibit.

What should you create in Power BI Desktop?

1. a waterfall chart
2. a ribbon chart
3. a bar chart
4. a decomposition tree

Q179. You need to perform hybrid transactional and analytical processing (HTAP) queries against Azure Cosmos DB data sources by using Azure Synapse Analytics.
What should you use?

1. Synapse pipelines
2. a Synapse SQL pool
3. Synapse Link
4. Synapse Studio

Q180. A bar chart showing year-to-date sales by region is an example of which type of analytics?

1. predictive
2. prescriptive
3. descriptive
4. diagnostic

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

Correct Answer

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

Correct Answer

Q183. What is required to provision Azure Data Lake Storage in an Azure Storage account?

1. Versioning must be disabled.
2. Hierarchical namespace must be disabled.
3. Versioning must be enabled.
4. Hierarchical namespace must be enabled.

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

Correct Answer

Q185. Which Azure Storage service implements the key/value model?

1. Azure Queue
2. Azure Files
3. Azure Table
4. Azure Blob

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

Correct Answer

Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboards

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

Correct Answer

Q188. What is used to define a query in a stream processing jobs in Azure Stream Analytics?

1. YAML
2. KQL
3. SQL
4. XML

Q189. You plan to deploy an app. The app requires a nonrelational data service that will provide latency guarantees of less than 10-ms for reads and writes.
What should you include in the solution?

1. Azure Blob storage
2. Azure Files
3. Azure Table storage
4. Azure Cosmos DB

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

Correct Answer

Q191. DRAG DROP –
Match the processes to the appropriate scenarios.
To answer, drag the appropriate process from the column on the left to its scenario on the right. Each process 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://learn.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl

Q192. What can be used with native notebook support to query and visualize data by using a web-based interface?

1. Azure Databricks
2. pgAdmin
3. Microsoft Power BI

Q193. Which database transaction property ensures that individual transactions are executed only once and either succeed in their entirety or roll back?

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

Q194. You have data saved in the following format.

Which format was used?

1. XML
2. HTML
3. YAML
4. JSON

Q195. You have data saved in the following format.

Which format was used?

1. JSON
2. YAML
3. HTML
4. XML

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

Correct Answer

Reference:
https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview?view=azuresql

Q197. Which database transaction property ensures that transactional changes to a database are preserved during unexpected operating system restarts?

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

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

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

Correct Answer

Q200. You have data saved in the following format.

Which format was used?

1. YAML
2. CSV
3. JSON
4. HTML