Azure Data Fundamental DP-900 MCQ Question Answer

Azure Data Fundamental DP-900 MCQ Question Answer

1. Azure Data Factory supports existing SSIS packages and can run them in the cloud.

 True

2.  What are the characteristics of an Online Transaction Processing (OLTP) workload?

     - heavy writes and moderate reads
     - schema on write
     - normalized data

3. Which of the following Azure Service uses the hierarchical namespace to store the data?

Azure Data Lake Storage

4. You need to use Transact-SQL to query files in Azure Data Lake Storage from an Azure Synapse Analytics data warehouse.

PolyBase

5. Which Power BI tool helps build paginated reports?

Power BI Report Builder is a tool that allows you to build paginated reports.

6. Which of the following are building blocks of Power BI?

 visualizations, datasets, reports, dashboards, tiles.

7. Which type of database workload is best for data that is historical and not used in your day-to-day business, going back 10 or 15 years?

Data Warehouses

 

8. Match the Azure services to the appropriate locations in the architecture.

Extract Transform Load (ETL) - Azure Data Factory
Data warehouse - Azure Synapse Analytics

 

9. Which of the following component is used to get messages from Twitter clients to Azure?

Azure Event Hubs

 

10. Which component of an Azure Data Factory can be triggered to run data ingestion tasks?

pipeline can be triggered to run data ingestion tasks

 

11. Which of the components of Azure Synapse Analytics allows you to train AI models using AzureML?

Synapse Spark   

 

12. Azure File storage is used to__________________________

To enable users at different sites to share files 

 

13. ___________ API of cosmos Db is used to work with data that has many differenct entities that share a relationship.

Gremlin

 

14. How much data can be stored in a single Table Storage account?

Azure single table storage can hold up to 500 TB of data.

 

15. Your company is designing a database that will contain session data for a website. The data will include notifications, personalization attributes, and products that are added to a shopping cart.

Which type of data store will provide the lowest latency to retrieve the data?

Columnar (Sensor data, Telemetry, messaging, web analytics, activity monitoring, recommendations)

16. When should you use a block blob, and when should you use a page blob?

-      Use a block blob for discrete objects that change infrequently.

-      Use a page block for blobs that require random read and write access.

 

17. You are building a system that monitors the temperature throughout a set of office blocks and sets the air conditioning in each room in each block to maintain a pleasant ambient temperature. Your system has to manage the air conditioning in several thousand buildings spread across the country/region, and each building typically contains at least 100 air-conditioned rooms.

What type of NoSQL datastore is most appropriate for capturing the temperature data to enable it to be processed quickly?

Send the data to an Azure Cosmos DB database and use Azure Functions to process the data 

 Or A key-value store

 

18. Match the following option.

Table API - Key/Value Data
MongoDB API - JSON Documents
Gremlin API - Graph Data

19. You need to insert a new JSON document into a Cosmos DB database, but there's a problem. All the previous customers have a valid name, and the data you are attempting to insert doesn't have it.

What happens when you attempt to add a JSON document that is missing a field that other documents all have?

NoSQL databases support not providing all properties with every record. The insert will succeed

 

20. When using the Azure cosmos DB Gremlin API, the container resource type is projected as a____________

Graph

 

21. A Relational database is appropriate for scenarios that involve a high volume of_______

Transactional writes

 

22. You can query a graph database in Azure cosmos DB as a_______

Nodes and edges by using the gremlin language

 

23. A visualization that shows a university’s current student enrolment versus the maximum capacity is an example of _____________

Descriptive analysis

 

24. Click the following Yes or no___________

   Batch processing can output data to a relational database

    Batch processing can output data to a NoSQL database

   Batch processing can output data to file storage

25. What happens when you add a new property to a JSON document, that doesn't exist in any other document, when storing in Cosmos DB?

You can dynamically insert a new property and the insert will succeed. Previous documents will not be updated

 

26. A key/Value data store is best suitable for_________________

Simple lookups

 

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

to automate the creation of an interdependent group of Azure resources in a repeatable way

 

28. When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure region?

Availability Zones

 

29. What database style is ideal for data that heavily relies on relationships, such as the relationships between People, Places, and Things?

Graph Data