Azure Data Fundamental DP-900 MCQ Question Answer

 

1. When you create an Azure SQL database, which account can always connect to the database?

the server admin login account of the logical server

2. [ Sending cloud infrastructure metadata every 30 minutes ] is an example of a streaming workload?

Keywords: Streaming workload => send data in realtime

Correct answer is option sending telemetry data from edge devices

 

3. Match the Azure Data Lake Storage terms to the appropriate levels in the hierarchy.

Resource Group > Azure Storage account > Container > Folders > Files

 

4. Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract, transform, and load (ETL) process.

Where does data processing occur for each stage of the ETL process?

Extract - The CRM System.
Load - The data warehouse.
Transform - An in-memory data ingestion tool.

 

5. Click the following yes or no

Azure Synapse Analytics scales storage and computes independently

Azure Synapse Analytics can be paused to reduce compute costs

 

6. Drag and drop the following

Batch - Data for a product catalog will be loaded every 12 hours to a data warehouse.
Streaming - Data for online purchases will be loaded to a data warehouse as the purchase occurs.
Batch - Updates to inventory data will be loaded to a data warehouse every 1000 transactions.

7. Drag and drop the following

Key influencer - A chart that displays the major contributors of a selected result or value.
Scatter - A chart that shows the relationship between two numeric values.
Treemap - A chart of colored, nested rectangles that display individual data points represented by the size and color of a relative rectangle.

 

8. You need to recommend a non-relational data store that is optimized for storing and retrieving text files, videos, audio streams, and virtual disk images. The data store must store data, some metadata, and a unique ID for each file.

Which type of data store should you recommend?

Object

 

9. You have a SQL query that combines customer data and order data. The query includes calculated columns.

You need to persist in the SQL query so that other users can use the query. What should you create?

 

a view

10. Which of the following Azure databases would be considered as "Infrastructure as a service"?

IaaS, Database => Database hosted on VM

Correct answer is option SQL Server in a VM

11. Drag and drop the following correct answer.

Subscription -> Resource Group -> Storage Account -> File Storage -> Folders & Files

12. Which Azure Data Factory component provides the compute environment for activities?

an integration runtime

13. Which type of non-relational data store supports a flexible schema, stores data as JSON files, and stores the all the data for an entity in the same document?

Keywords: non-relational database, flexible schema, JSON => document db

 

14. By default, each Azure SQL database is protected by______________

A server-level firewall

15. Your manager assigned you a task to find out a way to extract employee names from thousand of PDFs.

 

Bulk data processing, PDFs, Extract name => Cognitive analytics

 

16. Which activities can be performed entirely by using the Microsoft Power BI service?

Report sharing and distribution

Report and dashboard creation

 

17. Azure Resource Manager (ARM) templates use [ XML ] format.

JSON

 

18. Click the following yes or no

A wind turbine that sends 100 sensor readings per second is an example of a streaming workload?

A wind turbine that sends 100 sensor readings per second is an example of a streaming workload?

Salary credited to your account on the last day of every month is an example of a batch workload?

 

19. Click the following yes or no

 Does normalizing a database reduces data redundancy?

Does normalization improve data integrity?

 

20. You manage an application that stores data in a shared folder on a Windows server. You need to move the shared folder to Azure Storage.

Which type of Azure Storage should you use?

Shared folder, windows server => use File storage

 

21. Which of the following tools can be used in macOS to access data stored in Azure SQL Database?

 access data stored in Azure SQL Database => Azure Data Studio

 

22. Drag and drop the following options

Table - a database object that holds data.
View - a database object whose content is defined by a query.
Index - a database object that helps improve data retrieval time.

 

 

23. Azure Synapse Analytics is used to [ perform very complex queries and aggregations ]

No change needed ie. perform very complex queries and aggregations

 

24. Relational data uses ___________ to enfornce the relationship between different tables

Keys

 

25. What type of analytics answers the question "why did it happen", such as comparing sales of first-time customers to sales of long-term customers?

why it happened => Diagnostic analytics

 

26. Which are the services in Azure that can be used to ingest the data?

 Event hub & IoT hub

 

27. An ETL process requires__________________________

Data that is fully processed before being loaded to the target datastore

 

28. Match the types of activities to the appropriate Azure Data Factory activities.

Control - Until

Data movement - Copy

Data transformation - Mapping data flow

 

29. A relational database must be used when______________________

Strong consistency guarantees are required

 

30. Click the following yes or no options

Azure SQL database includes a fully managed backup service

Azure SQL database has built-in high availability

Azure SQL database uses Azure Advanced Threat Protection

31. Which of the following are common characteristics of a relational database?

Foreign Keys

Database prevents deletion of a parent record if a child record exists

 Data is stored in a table format of rows and columns

32. You have a quality assurance application that reads data from a data warehouse. Which type of processing does the application use?

Online Analytical Processing (OLAP)

 

33. Which of the following Azure services can be used to provision Apache Spark clusters?

Azure Databricks & Azure HDInsight

Which type of database workload is the day-to-day operation of your business?

Database workload for day-to-day operation => OLTP

 

34. You have an Azure Cosmos DB account that uses the Core (SQL) API. Which settings can you configure at the container level?

the throughput & the partition key

 

35. Which of the following is a characteristic of non-relational databases?

Non-relational databases are either schema-free or have relaxed schemas