Microsoft DP900 Exam Dumps|QAs Page -2

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

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

Microsoft DP900 Exam Dumps – QAs 26-50

Q26. Which storage solution supports access control lists (ACLs) at the file and folder level?

1. Azure Data Lake Storage
2. Azure Queue storage
3. Azure Blob storage
4. Azure Cosmos DB

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

Correct answer

Reference:
https://docs.microsoft.com/en-us/sql/reporting-services/report-design/tree-map-and-sunburst-charts-in-reporting-services?view=sql-server-ver15

Q28. DRAG DROP –
Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract, load, and transform (ELT) process.
Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct stages. Each location may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

Correct answer

Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl

Q29. Your company recently reported sales from the third quarter.
You have the chart shown in the following exhibit.

Which type of analysis is shown in the fourth quarter?

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

Q30. Which Azure storage solution provides native support for POSIX-compliant access control lists (ACLs)?

1. Azure Table storage
2. Azure Data Lake Storage
3. Azure Queue storage
4. Azure Files

Q31. What is a characteristic of batch processing?

1. The data ingested during batch processing must be processed as soon as the data is received.
2. Large datasets must be split into batches of less than 1 GB before the data can be processed.
3. There is a noticeable time delay between ingesting data and obtaining the data processing results. 
4. Batch processing can only process data that is structured.

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

Correct answer

Reference:
https://docs.microsoft.com/en-us/sql/t-sql/functions/aggregate-functions-transact-sql?view=sql-server-ver15

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

1. REVOKE
2. DISABLE
3. CREATE
4. UPDATE

Q34. HOTSPOT –
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

Correct answer

Reference:
https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-will-happen-with-iot-analytics/

Q35. HOTSPOT –
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

Correct answer

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

Q37. HOTSPOT –
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

Correct answer

Reference:
https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-will-happen-with-iot-analytics/

Q38. HOTSPOT –
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

Correct answer

Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/stored-procedures/stored-procedures-database-engine?view=sql-server-ver15

Q39. DRAG DROP –
Match the types of analytics that can be used to answer the business questions.
To answer, drag the appropriate analytics type from the column on the left to its question on the right. Each analytics type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:

Q40. DRAG DROP –
Match the types of analytics that can be used to answer the business questions.
To answer, drag the appropriate analytics type from the column on the left to its question on the right. Each analytics type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:

Q41. Which type of database is Azure Database for PostgreSQL?

1. Platform as a service (PaaS)
2. Infrastructure as a service (IaaS)
3. Microsoft SQL Server
4. on-premises

Q42. HOTSPOT –
You have the following JSON document.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the JSON document.
NOTE: Each correct selection is worth one point.
Hot Area:

Correct answer

Q43. HOTSPOT –
You are reviewing the data model shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point
Hot Area:

Correct answer

Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-overview
https://azure.microsoft.com/en-us/blog/data-models-within-azure-analysis-services-and-power-bi/

Q44. You need to create an Azure resource to store data in Azure Table storage.
Which command should you run?

1. az storage share create
2. az storage account create
3. az cosmosdb create
4. az storage container create

Q45. HOTSPOT –
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

Correct answer

Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/choose-api

Q46. HOTSPOT –
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

Correct answer

Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/massively-parallel-processing-mpp-architecture

Q47. HOTSPOT –
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

Correct answer

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

Q48. You need to modify a view in a relational database by adding a new column.
Which statement should you use?

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

Q49. 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/azure/architecture/data-guide/relational-data/etl

Q50. HOTSPOT –
You plan to deploy a PostgreSQL database to Azure.
Which hosting model corresponds to the available deployment options? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Correct answer

Reference:
https://azure.microsoft.com/en-us/overview/what-is-saas/
https://azure.microsoft.com/en-us/overview/what-is-paas/