Microsoft DP900 Exam Dumps

Here, the Microsoft DP900 Exam Dumps page contains 280 real and latest questions for Microsoft Azure Data Fundamentals.

DP900 Certification is intended for you if you’re a candidate beginning to work with data in the cloud.

You should be familiar with:

• Different types of data workloads such as transactional or analytical.
• The concepts of relational and non-relational data.

The AZ900 Certification skills measured:

• Describe core data concepts
• Identify considerations for relational data on Azure
• Describe considerations for working with non-relational data on Azure
• Describe an analytics workload on Azure

Other Microsoft Exam Dumps with Real Exam Questions
1. AZ900 Q1-250 (Part-1)
2. AZ900 Q251-458 (Part-2)

Microsoft DP900 Exam Dumps

Q1. You need to create an Azure Storage account.
Data in the account must replicate outside the Azure region automatically.
Which two types of replication can you use for the storage account?

1. zone-redundant storage (ZRS)
2. read-access geo-redundant storage (RA-GRS)
3. locally-redundant storage (LRS)
4. geo-redundant storage (GRS)

Correct answer

2. read-access geo-redundant storage (RA-GRS)
4. geo-redundant storage (GRS)

Reference:
https://docs.microsoft.com/en-us/azure/storage/common/storage-redundancy#redundancy-in-a-secondary-region

Q2. Platform as a Service database offerings in Azure require less setup and configuration effort than infrastructure as a service database offerings. _____
Platform as a service(PaaS) database offerings in Azure provide end users with the ability to control and update the operating system version. _____
All relation and non-relational platform as a service(PaaS) database offerings in Azure can be paused to reduce costs. _____

Correct answer

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

Q3. Descriptive analytics tells you ______

Correct answer

Q4. Normalization involves eliminating relationships between database tables. ______
Normalizing a database reduces data redundancy. ______
Normalization improves data integrity. ______

Correct answer

Q5. In a relational database, each row in a table has ______

Correct answer

Q6. Normalizing a database increases the throughput of writing transactions. ______
Analytics systems are more normalized than transactional systems. ______
Normalizing a database results in queries that require more joins. ______

Correct answer

Q7. A relational database is appropriate for scenarios that involve a high volume of ______

Correct answer

Q8. Batch processing can output data to a file store. ______
Batch processing can output data to a relational database. ______
Batch processing can output data to a NoSQL database. ______

Correct answer

Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/big-data/batch-processing

Q9. Image files, key/value pairs, Relationships between employees. ______
Azure Blob storage, Azure Cosmos DB Gremin API, Azure Table storage. ______

Correct answer

Reference:
https://docs.microsoft.com/en-us/azure/storage/tables/table-storage-design-modeling

Q10. Azure storage account ______
File share ______
Container ______

Correct answer

Reference:
https://docs.microsoft.com/en-us/azure/storage/files/storage-how-to-create-file-share

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

1. REVOKE
2. DISABLE
3. INSERT
4. GRANT

Correct answer

3. INSERT

Reference:
https://docs.microsoft.com/en-us/sql/t-sql/statements/statements

Q12. You have a SQL query that combines customer data and order data. The query includes calculated columns.
You need to create a database object that would allow other users to rerun the same SQL query.
What should you create?

1. an index
2. a view
3. a scalar function
4. a table

Correct answer

2. a view

Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/views/views

Q13. An extract, transform, and load(ETL) process requires ______

Correct answer

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

Q14. In batch processing, ______

Correct answer

Q15. ______ natively support the analysis of relationships between entities.

Correct answer

Reference:
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

Q16. A key/value data store is optimized for ______

Correct answer

Reference:
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

Q17. A key/value data store is optimized for ______

Correct answer

Reference:
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

Q18. 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?

Correct answer

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

Q19. A visualization that shows a university’s current student enrollment versus the maximum capacity is an example of ______ analytics.

Correct answer

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

Q20. What are two characteristics of real-time data processing?

1. Data is processed periodically
2. Low latency is expected
3. High latency is acceptable
4. Data is processed as it is created

Correct answer

2. Low latency is expected
4. Data is processed as it is created

Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/big-data/real-time-processing

Q21. Transcribing audio files is an example of ______ analytics.

Correct answer

Reference:
https://azure.microsoft.com/en-us/services/cognitive-services/speech-services/

Q22. In an infrastructure as a service instance of Microsoft SQL server on Azure you manage the ______ that hosts SQL server.

Correct answer

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/azure-sql-iaas-vs-paas-what-is-overview?view=azuresql

Q23. A chart of colored nested rectangles that displays individual data points represented by the size and color of a relative rectangle. ______
A chart that displays the major contributors of a selected result or value. ______
A chart that shows the relationship between two numerical values. ______

Correct answer

Q24. A representation of data structures within data stores. ______
The information used to connect to external resources. ______
A logical grouping of activities that performs a unit of work and can be scheduled. ______

Correct answer

Reference:
https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipelines-activities

Q25. Data for a product catalog will be loaded every 12 hours to a data warehouse. ______
Thousands of data sets per second for online purchases will be loaded into a data warehouse in real time. ______
Updates to inventory data will be loaded to a data warehouse every 1 million transactions. ______

Correct answer

Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/technology-choices/batch-processing

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

Correct answer

1. Azure Data Lake Storage

Reference:
https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-access-control

Q27. A ______ is a chart of colored rectangles. The size of the rectangle represent the relative value of each item. The chart can be hierarchical, displaying data as a set of rectangles nested within the main rectangle.

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

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

Correct answer

1. predictive

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

Correct answer

2. Azure Data Lake Storage

Reference:
https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-access-control

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.

Correct answer

4. Batch processing can only process data that is structured.

Q32. In a SQL statement, ______ are examples of aggregate functions.

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

Correct answer

4. UPDATE

Reference:
https://docs.microsoft.com/en-us/sql/t-sql/statements/statements

Q34. Creating closed caption text for audio files is an example of ______ analytics.

Correct answer

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

Q35. Relational data is stored in ______

Correct answer

Q36. A job that processes sales data once daily is an example of a batch workload. ______
A job that calculates a rolling average temperature reading is an example of a streaming workload. ______
A job that calculates average revenue per product for the last month is an example of a streaming workload. ______

Correct answer

Q37. A visualization that illustrates a university’s current student enrollment per department is an example of ______ analytics.

Correct answer

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

Q38. A block of code that runs in a database is called ______

Correct answer

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

Q39. Why did sales increase last month? ______
Provide specific guidance on how to allocate current budget to buy different inventory items. ______
Detect images of the company’s logo included in PDF documents. ______

Correct answer

Box 1: Diagnostic
Box 2: Prescriptive
Box 3: Cognitive

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

Q40. ______ Why did sales increase last month?
______ How do I allocate my budget to buy different inventory items?
______ Which people are mentioned in a company’s business documents?

Correct answer

Box 1: Diagnostic
Box 2: Prescriptive
Box 3: Descriptive

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

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

Correct answer

1. Platform as a service (PaaS)

Reference:
https://docs.microsoft.com/en-us/azure/postgresql/overview-postgres-choose-server-options

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

Correct answer

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

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

Correct answer

4. az storage container create

Reference:
https://docs.microsoft.com/en-us/cli/azure/storage/container?view=azure-cli-latest

Q45. The Azure Cosmos DB ______ API enables the use of SELECT statements to retrieve documents from Azure Cosmos DB.

Correct answer

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

Q46. The massively parallel processing engine of Azure Synapse Analytics ______

Correct answer

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

Q47. ______ is an object associated with a table that sorts and stores the data rows in the table based on their key values.

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

Correct answer

2. ALTER

Q49. Extract, transform, and load(ETL) can reduce the transfer of sensitive data to destination systems. ______
Extract, transform, and load(ETL) transforms data by using a compute resource independent of the source system and destination system. ______
Extract, transform, and load(ETL) minimizes the time it takes to copy large volumes of data to destination systems. ______

Correct answer

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

Q50. You plan to deploy a PostgreSQL database to Azure.
Which hosting model corresponds to the available deployment options?

Correct answer

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

Q51. Which property of a transactional workload guarantees that each transaction is treated as a single unit that either succeeds completely or fails completely?

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

Correct Answer

1. atomicity

Q52. The workflow for creating an analytics solution in Microsoft Power BI starts with ______

Correct Answer

Q53. You are writing a set of SQL queries that administrators will use to troubleshoot an Azure SQL database.
You need to embed documents and query results into a SQL notebook.
What should you use?

1. Microsoft SQL Server Management Studio (SSMS)
2. Azure Data Studio
3. Azure CLI
4. Azure PowerShell

Correct Answer

2. Azure Data Studio

Q54. ______ natively support the analysis of relationships between entities.

Correct Answer

Reference:
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

Q55. A key/value data store is optimized for ______

Correct Answer

Reference:
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

Q56. You have an inventory management database that contains the following table.

Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?

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

Correct Answer

3. UPDATE

Q57. Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance.
Which Azure service should you use?

1. Azure HDInsight
2. Azure SQL Database
3. Azure Cosmos DB
4. SQL Server on Azure Virtual Machines

Correct Answer

2. Azure SQL Database

Reference:
https://azure.microsoft.com/en-us/services/sql-database/#features

Q58. A JSON document is an example of ______

Correct Answer

Reference:
https://www.ibm.com/cloud/blog/structured-vs-unstructured-data

Q59. ______ A graphical tool for managing AQL server and Azure SQL databases that supports access configuration management and administration tasks.
______ A lightweight editor that can run on-demand SQL queries and view and save results as text, JSON, or Microsoft Excel files.
______ A development tool for building Azure SQL databases, Microsoft SQL Server relational databases, SQL Server Integration Services(SSIS) packages, and SQL Server Reporting Services(SSRS) reports.

Correct Answer

Reference:
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms
https://docs.microsoft.com/en-us/sql/azure-data-studio/what-is-azure-data-studio
https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt

Q60. Relational database tables contain columns and rows. ______
Indexes in a relational database describe the data types in a table. ______
A database view is a virtual table whose content is defined by a query. ______

Correct Answer

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

Q61. ______ A database object that holds data.
______ A database object whose content is defined by a query.
______ A database object that helps improve the speed of data retrieval.

Correct Answer

Reference:
https://en.wikipedia.org/wiki/Table_(database)
https://en.wikipedia.org/wiki/View_(SQL)
https://en.wikipedia.org/wiki/Database_index

Q62. You have an Azure SQL database that you access directly from the Internet.
You recently changed the public IP address of your computer.
After changing the IP address, you can no longer access the database. You can connect to other resources in Azure.
What is a possible cause of the issue?

1. role-based access control (RBAC)
2. Dynamic Host Configuration Protocol (DHCP)
3. Domain Name Service (DNS)
4. a database-level firewall

Correct Answer

4. a database-level firewall

Q63. You have a data store that has the structure shown in the following exhibit.

Which type of data store is this?

1. key/value
2. object data
3. graph
4. time series

Correct Answer

3. graph

Reference:
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

Q64. In an infrastructure as a service instance of Microsoft SQL server on Azure, you manage the ______ that hosts SQL server.

Correct Answer

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/azure-sql-iaas-vs-paas-what-is-overview?view=azuresql

Q65. Varying fields for each entity in a JSON document is an example of ______

Correct Answer

Reference:
https://docs.snowflake.com/en/user-guide/semistructured-considerations.html

Q66. You have an e-commerce application that reads and writes data to an Azure SQL database.
Which type of processing does the application use?

1. stream processing
2. batch processing
3. Online Analytical Processing (OLAP)
4. Online Transaction Processing (OLTP)

Correct Answer

4. Online Transaction Processing (OLTP)

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

1. to automate the creation of an interdependent group of Azure resources in a repeatable way
2. to apply Azure policies for multi-tenant deployments
3. to provision Azure subscriptions
4. to control which services and feature administrators and developers can deploy from the Azure portal

Correct Answer

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

Reference:
https://docs.microsoft.com/en-us/azure/azure-resource-manager/templates/overview

Q68. ______ is responsible for identifying which business rules must be applied to the data of a company.

Correct Answer

Reference:
https://www.edureka.co/blog/data-analyst-vs-data-engineer-vs-data-scientist/

Q69. Normalizing a database increases the throughput of writing transactions. ______
Analytics systems are more normalized than transactional systems. ______
Normalizing a database results in queries that require more joins. ______

Correct Answer

Q70. Which type of database contains nodes and edges?

1. graph
2. key/value
3. columnar
4. time series

Correct Answer

1. graph

Reference:
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

Q71. You can use Azure Data Studio to query a Microsoft SQL server big data cluster. ______
You can use Microsoft SQL Server Management Studio(SSMS) to query an Azure Synapse Analytics data warehouse. ______
You can use MySQL Workbench to query Azure Database for MariaDB databases. ______

Correct Answer

Reference:
https://docs.microsoft.com/en-us/sql/big-data-cluster/connect-to-big-data-cluster?view=sql-server-ver15
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-query-ssms
https://docs.microsoft.com/en-us/azure/mariadb/connect-workbench

Q72. You have the following SQL query.

What are dbo.Products and ProductName?

Correct Answer

Q73. Which command-line tool can you use to query Azure SQL databases?

1. sqlcmd
2. bcp
3. azdata
4. Azure CLI

Correct Answer

1. sqlcmd

Reference:
https://docs.microsoft.com/en-us/sql/tools/overview-sql-tools?view=sql-server-ver15

Q74. Azure Data Studio can be used to query an Azure AQL database from a device that runs macOS. ______
Microsoft SQL Server Management Studio(SSMS) enables users to create and use SQL notebooks. ______
Azure Data Studio can be used to restore a database. ______

Correct Answer

Reference:
https://docs.microsoft.com/en-us/sql/azure-data-studio/what-is-azure-data-studio

Q75. Which statement is an example of Data Definition Language (DDL)?

1. SELECT
2. JOIN
3. UPDATE
4. CREATE

Correct Answer

4. CREATE

Reference:
https://docs.microsoft.com/en-us/sql/t-sql/statements/statements

Q76. You are deploying a software as a service (SaaS) application that requires a relational database for Online Transaction Processing (OLTP).
Which Azure service should you use to support the application?

1. Azure Cosmos DB
2. Azure HDInsight
3. Azure SQL Database
4. Azure Synapse Analytics

Correct Answer

3. Azure SQL Database

Q77. What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database?

1. access to the latest features
2. complete control over backup and restore processes
3. in-database machine learning services
4. reduced administrative effort for managing the server infrastructure

Correct Answer

1. access to the latest features
4. reduced administrative effort for managing the server infrastructure

Q78. Platform as a service(PaaS) database offerings in Azure provide built-in high availability. ______
Platform as a service(PaaS) database offerings in Azure provide configurable scaling options. ______
Platform as a service(PaaS) database offerings in Azure reduce the administrative overhead for managing hardware. ______

Correct Answer

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview

Q79. Azure SQL database includes a managed backup service. ______
Azure SQL Database has built-in-high availability. ______
Azure SQL Database can use Azure Defender. ______

Correct Answer

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview
https://azure.microsoft.com/en-us/blog/announcing-sql-atp-and-sql-vulnerability-assessment-general-availability/
https://docs.microsoft.com/en-us/azure/security-center/azure-defender

Q80. You must apply operating system updates to Azure SQL databases regularly. ______
You need a Microsoft 365 subscription to create an Azure SQL database. ______
You can use existing Microsoft SQL Server licenses to reduce the cost of Azure SQL databases. ______

Correct Answer

Reference:
https://azure.microsoft.com/en-gb/blog/hot-patching-sql-server-engine-in-azure-sql-database/
https://azure.microsoft.com/en-us/services/sql-database/#product-overview

Q81. You have a table named Sales that contains the following data.

You need to query the table to return the average sales amount per day. The output must produce the following results.

How should you complete the query?

Correct Answer

Reference:
https://docs.microsoft.com/en-us/sql/t-sql/functions/avg-transact-sql

Q82. Transparent Data Encryption (TDE) encrypts ______

Correct Answer

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-tde-overview?tabs=azure-portal

Q83. Which statement is an example of Data Definition Language (DDL)?

1. SELECT
2. INSERT
3. DELETE
4. DROP

Correct Answer

4. DROP

Reference:
https://docs.microsoft.com/en-us/sql/t-sql/statements/statements

Q84. You need to design and model a database by using a graphical tool that supports project-oriented offline database development.
What should you use?

1. Microsoft SQL Server Data Tools (SSDT)
2. Microsoft SQL Server Management Studio (SSMS)
3. Azure Databricks
4. Azure Data Studio

Correct Answer

1. Microsoft SQL Server Data Tools (SSDT)

Reference:
https://docs.microsoft.com/en-us/sql/ssdt/project-oriented-offline-database-development?view=sql-server-ver15

Q85. By default, each Azure SQL database is protected by ______

Correct Answer

Reference:
https://docs.microsoft.com/en-us/azure/security/fundamentals/infrastructure-sql

Q86. What is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?

1. built-in high availability
2. native support for cross-database queries and transactions
3. system-initiated automatic backups
4. support for encryption at rest

Correct Answer

2. native support for cross-database queries and transactions

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/features-comparison

Q87. A team of developers has computers that run Windows 10 and Ubuntu Desktop.
The developers need to connect to and query an Azure SQL database from each of their computers. The developers require code assistance features such as
IntelliSense.
What should the developers use?

1. sqlcmd
2. Microsoft SQL Server Management Studio (SSMS)
3. Azure Data Studio
4. Azure Data Explorer

Correct Answer

3. Azure Data Studio

Reference:
https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio

Q88. You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure SQL database.
Which type of authentication should you use?

1. service principal authentication
2. Azure Active Directory (Azure AD) authentication
3. SQL authentication
4. certificate authentication

Correct Answer

2. Azure Active Directory (Azure AD) authentication

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-mfa-ssms-overview

Q89. If you have a Platform as a Service(PaaS) database in Azure, you are responsible for applying operating system updates. ______
If you have a Platform as a Service(PaaS) database in Azure, backups are performed automatically. ______
If you have a Platform as a Service(PaaS) database in Azure, you are responsible for installation of the database engine. ______

Correct Answer

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview

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

1. the Azure Active Directory (Azure AD) account that created the database
2. the server admin login account of the logical server
3. the Azure Active Directory (Azure AD) administrator account
4. the sa account

Correct Answer

2. the server admin login account of the logical server

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/single-database-create-quickstart

Q91. Relational data uses ______ to enforce relationships between different tables.

Correct Answer

Q92. Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?

1. SELECT
2. WHERE
3. JOIN

Correct Answer

1. SELECT

Reference:
https://docs.microsoft.com/en-us/sql/t-sql/queries/hints-transact-sql-table

Q93. Your company needs to ensure that an Azure virtual machine can connect to Azure SQL databases without exposing the databases to the internet.
What should you use?

1. Azure Application Gateway
2. Azure Traffic Manager
3. Azure DNS
4. Azure Private Link

Correct Answer

4. Azure Private Link

Reference:
https://techcommunity.microsoft.com/t5/azure-database-support-blog/azure-sql-db-private-link-private-endpoint-connectivity/ba-p/1235573

Q94. ______ is a virtual table that contains content defined by a query.

Correct Answer

Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/views/views

Q95. A relational database must be used when ______

Correct Answer

Q96. ______ A serverless configuration.
______ A database that has the highest compatibility with on-premises Microsoft SQL server.
______ A low-cost, low-maintenance database.

Correct Answer

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview?view=azuresql
https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview?view=azuresql
https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview

Q97. Which clause should you use in a SELECT statement to combine rows in one table with rows in another table?

1. SET
2. VALUES
3. KEY
4. JOIN

Correct Answer

4. JOIN

Q98. You need to query a table named Products in an Azure SQL database.
Which three requirements must be met to query the table from the internet?

1. You must be assigned the Reader role for the resource group that contains the database.
2. You must have SELECT access to the Products table.
3. You must have a user in the database.
4. You must be assigned the Contributor role for the resource group that contains the database.
5. Your IP address must be allowed to connect to the database.

Correct Answer

2. You must have SELECT access to the Products table.
3. You must have a user in the database.
5. Your IP address must be allowed to connect to the database.

Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/getting-started-with-database-engine-permissions?view=sql-server-ver15

Q99. ______ Prevent access to an Azure SQL database from another network.
______ Support Azure Active Directory(Azure AD) sign-ins to an Azure SQL database.
______ Ensure that sensitive data never appears as plain text in an Azure SQL database.

Correct Answer

Reference:
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-windows-firewall-for-database-engine-access?view=sql-server-ver15
https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-overview
https://docs.microsoft.com/en-us/azure/azure-sql/database/always-encrypted-certificate-store-configure

Q100. You have a transactional application that stores data in an Azure SQL managed instance.
When should you implement a read-only database replica?

1. You need to generate reports without affecting the transactional workload.
2. You need to audit the transactional application.
3. You need to implement high availability in the event of a regional outage.
4. You need to improve the recovery point objective (RPO).

Correct Answer

1. You need to generate reports without affecting the transactional workload.

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/read-scale-out

Q101. ______ A list of application user names and for each the default language.
______ A collection of medical images and their associated metadata.
______ Employee data that shows the relationships between employees.

Correct Answer

Reference:
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

Q102. In relational database, the ______ uniquely identifies each row in a table.

Correct Answer

Q103. ______ presents content defined by a query.

Correct Answer

Reference:
https://www.ibm.com/docs/SSWT9A_7.6.0/com.ibm.mbs.doc/configur/c_views.html

Q104. Which Azure service provides the highest compatibility for databases migrated from Microsoft SQL Server 2019 Enterprise edition?

1. Azure SQL Database
2. Azure Database for MySQL
3. Azure SQL Managed Instance
4. an Azure SQL Database elastic pool

Correct Answer

3. Azure SQL Managed Instance

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview?view=azuresql

Q105. Which setting can only be configured during the creation of an Azure Cosmos DB account?

1. geo-redundancy
2. multi-region writes
3. production or non-production account type
4. API

Correct Answer

4. API

Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/how-to-manage-database-account

Q106. ______ is a platform as a service(PaaS) relational data service that uses massively parallel processing(MPP).

Correct Answer

Q107. ______ physically sorts the data in a table based on the values in a specified column.

Correct Answer

Q108. Which storage solution supports role-based access control (RBAC) at the file and folder level?

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

Correct Answer

2. Azure Data Lake Storage

Reference:
https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-access-control

Q109. Your company is designing a data store that will contain student data. The data has the following format.

Which type of data store should you use?

1. graph
2. key/value
3. object
4. columnar

Correct Answer

4. columnar

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

1. the throughput
2. the read region
3. the partition key
4. the API

Correct Answer

1. the throughput
3. the partition key

Q111. Azure table storage within a single Azure Storage account supports multiple concurrent reads in different Azure regions. ______
Azure table storage within a single Azure Storage account supports multiple concurrent writes in different Azure regions. ______
An Azure Cosmos DB account that uses the Table API supports multiple concurrent reads in different Azure regions. ______
An Azure Cosmos DB account that uses the Table API supports multiple concurrent writes in different Azure regions. ______

Correct Answer

Reference:
https://docs.microsoft.com/en-us/azure/storage/common/storage-redundancy

Q112. ______ Graph data
______ JSON documents
______ Key/value data.

Correct Answer

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

Q113. What is a benefit of the Azure Cosmos DB Table API as compared to Azure Table storage?

1. provides resiliency if an Azure region fails
2. supports partitioning
3. provides a higher storage capacity
4. supports a multi-master model

Correct Answer

4. supports a multi-master model

Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/table-support

Q114. 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?

1. document
2. columnar
3. graph
4. time series

Correct Answer

1. document

Q115. To configure an azure storage account to support both security at the folder level and atomic directory manipulation, ______

Correct Answer

Reference:
https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-namespace

Q116. 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?

1. queue
2. blob
3. file
4. table

Correct Answer

3. file

Reference:
https://azure.microsoft.com/en-us/services/storage/files/

Q117. You can query a graph database in Azure Cosmos DB ______

Correct Answer

Q118. When provisioning an Azure Cosmos DB ______, you need to specify which type of API you will use.

Correct Answer

Q119. You need to store data by using Azure Table storage.
What should you create first?

1. an Azure Cosmos DB instance
2. a storage account
3. a blob container
4. a table

Correct Answer

2. a storage account

Reference:
https://docs.microsoft.com/en-us/azure/storage/tables/table-storage-quickstart-portal
https://docs.microsoft.com/en-us/azure/storage/common/storage-account-create

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

1. multi-master replication
2. Availability Zones
3. the strong consistency level
4. automatic failover

Correct Answer

2. Availability Zones

Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/high-availability

Q121. Your company needs to design a database that shows how changes in network traffic in one area of a network affect network traffic in other areas of the network.
Which type of data store should you use?

1. graph
2. key/value
3. document
4. columnar

Correct Answer

1. graph

Q122. Your company needs to design a database that illustrates the relationships between utilization levels of individual network devices across a local area network.
Which type of data store should you use?

1. graph
2. key/value
3. document
4. columnar

Correct Answer

1. graph

Q123. You need to store data in Azure Blob storage for seven years to meet your company’s compliance requirements. The retrieval time of the data is unimportant. The solution must minimize storage costs.
Which storage tier should you use?

1. Archive
2. Hot
3. Cool

Correct Answer

1. Archive

Q124. Azure Databricks can consume data from Azure SQL Database. ______
Azure Databricks can consume data from Azure Event Hubs. ______
Azure Databricks can consume data from Azure Cosmos DB. ______

Correct Answer

Reference:
https://docs.microsoft.com/en-us/azure/databricks/data/data-sources/sql-databases-azure
https://docs.microsoft.com/en-us/azure/databricks/scenarios/databricks-stream-from-eventhubs

Q125. 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?

1. key/value
2. graph
3. columnar
4. document

Correct Answer

3. columnar

Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/technology-choices/analytical-data-stores

Q126. The Azure Cosmos DB API is configured separately for each database in an Azure Cosmos DB account. ______
Partition keys are used in Azure Cosmos DB to optimize queries. ______
Items contained in the same Azure Cosmos DB logical partition can have different partition keys. ______

Correct Answer

Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/partitioning-overview

Q127. You need to recommend a data store service that meets the following requirements:
-> Native SQL API access
-> Configurable indexes
What should you recommend?

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

Correct Answer

4. Azure Cosmos DB

Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/sql/how-to-manage-indexing-policy

Q128. ______ Enables the use of SQL queries against data stored in JSON documents.
______ Enables users to access data by using the Server Message Block(SMB) version 3 protocol.

Correct Answer

Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/sql-query-working-with-json

Q129. You have an application that runs on Windows and requires access to a mapped drive.
Which Azure service should you use?

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

Correct Answer

1. Azure Files

Reference:
https://docs.microsoft.com/en-us/azure/storage/files/storage-how-to-use-files-windows

Q130. To configure an Azure storage account to support access control lists that have object-level permissions, ______

Correct Answer

Reference:
https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-namespace

Q131. Copying data to Azure data lake storage from another Azure region results in extra cost. ______
You can use blob, table, and file storage in the same Azure Storage account. ______
You implement Azure Data Lake Storage by creating an Azure Storage account. ______

Correct Answer

Reference:
https://docs.microsoft.com/en-us/azure/data-lake-store/data-lake-store-get-started-portal
https://docs.microsoft.com/en-us/azure/storage/common/storage-account-overview
https://azure.microsoft.com/en-us/pricing/details/bandwidth/

Q132. ______ is an azure synapse analytics feature that retrieves data from azure blob storage by using Transact-SQL queries.

Correct Answer

Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/polybase/polybase-guide?view=sql-server-ver15

Q133. You have a dedicated SQL pool in Azure Synapse Analytics that is only used actively every night for eight hours.
You need to minimize the cost of the dedicated SQL pool as much as possible during idle times. The solution must ensure that the data remains intact.
What should you do on the dedicated SQL pool?

1. Scale down the data warehouse units (DWUs).
2. Pause the pool.
3. Create a user-defined restore point.
4. Delete the pool

Correct Answer

2. Pause the pool.

Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-manage-compute-overview

Q134. 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?

1. key/value
2. columnar
3. object
4. document

Correct Answer

3. object

Reference:
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

Q135. Which Azure Data Factory component initiates the execution of a pipeline?

1. a control flow
2. a trigger
3. a parameter
4. an activity

Correct Answer

2. a trigger

Reference:
https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipeline-execution-triggers#trigger-execution

Q136. What are three characteristics of an Online Transaction Processing (OLTP) workload?

1. denormalized data
2. heavy writes and moderate reads
3. light writes and heavy reads
4. schema on write
5. schema on read
6. normalized data

Correct Answer

2. heavy writes and moderate reads
4. schema on write
6. normalized data

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

Q137. In azure data factory, you can use ______ to orchestrate pipeline activities that depend on the output of other pipeline activities.

Correct Answer

Reference:
https://docs.microsoft.com/en-us/azure/data-factory/frequently-asked-questions

Q138. When using the Azure Cosmos DB Gremlin API, the container resource type is projected as a ______

Correct Answer

Q139. Your company is designing a data store for internet-connected temperature sensors.
The collected data will be used to analyze temperature trends.
Which type of data store should you use?

1. relational
2. time series
3. graph
4. columnar

Correct Answer

2. time series

Reference:
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

Q140. Which two Azure services can be used to provision Apache Spark clusters?

1. Azure Time Series Insights
2. Azure HDInsight
3. Azure Databricks
4. Azure Log Analytics

Correct Answer

2. Azure HDInsight
3. Azure Databricks

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

1. Online Transaction Processing (OLTP)
2. batch processing
3. Online Analytical Processing (OLAP)
4. stream processing

Correct Answer

1. Online Transaction Processing (OLTP)

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

Q142. Azure table storage supports multiple read replicas. ______
Azure table storage supports multiple write regions. ______
The Azure Cosmos DB Table API supports multiple read replicas. ______
The Azure Cosmos DB Table API supports multiple write regions. ______

Correct Answer

Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/high-availability

Q143. Your company is designing an application that will write a high volume of JSON data and will have an application-defined schema.
Which type of data store should you use?

1. columnar
2. key/value
3. document
4. graph

Correct Answer

2. key/value

Reference:
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

Q144. At which two levels can you set the throughput for an Azure Cosmos DB account?

1. database
2. item
3. container
4. partition

Correct Answer

1. database
3. container

Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/set-throughput

Q145. What is a characteristic of non-relational data?

1. no indexes
2. self-describing entities
3. a well-defined schema
4. no unique key values

Correct Answer

4. no unique key values

Q146. You need to gather real-time telemetry data from a mobile application.
Which type of workload describes this scenario?

1. Online Transaction Processing (OLTP)
2. batch
3. massively parallel processing (MPP)
4. streaming

Correct Answer

4. streaming

Reference:
https://docs.microsoft.com/en-in/azure/azure-monitor/overview

Q147. You need to develop a solution to provide data to executives. The solution must provide an interactive graphical interface, depict various key performance indicators, and support data exploration by using drill down.
What should you use in Microsoft Power BI?

1. a view
2. a report
3. a dataflow
4. Microsoft Power Apps

Correct Answer

2. a report

Reference:
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-dashboards
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill

Q148. Your company has a reporting solution that has paginated reports. The reports query a dimensional model in a data warehouse.
Which type of processing does the reporting solution use?

1. stream processing
2. batch processing
3. Online Analytical Processing (OLAP)
4. Online Transaction Processing (OLTP)

Correct Answer

3. Online Analytical Processing (OLAP)

Q149. Which two activities can be performed entirely by using the Microsoft Power BI service without relying on Power BI Desktop?

1. report and dashboard creation
2. report sharing and distribution
3. data modeling
4. data acquisition and preparation

Correct Answer

1. report and dashboard creation
4. data acquisition and preparation

Q150. ______ Copy
______ Mapping data flow
______ Lookup.

Correct Answer

Reference:
https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipelines-activities#data-transformation-activities

Q151. A Microsoft Power BI dashboard is associated with a single workspace. ______
A Microsoft Power BI dashboard can only display visualizations from a single dataset. ______
A Microsoft Power BI dashboard can display visualizations from a Microsoft Excel workbook. ______

Correct Answer

Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-across-workspaces
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-dashboards
https://powerbi.microsoft.com/en-us/excel-and-power-bi/

Q152. Azure Cognitive Search ______
Azure Data Catalog ______
Azure Data Factory ______
Azure Synapse Analytics ______

Correct Answer

Reference:
https://docs.microsoft.com/en-us/azure/machine-learning/how-to-data-ingest-adf
https://docs.microsoft.com/en-us/azure/machine-learning/team-data-science-process/sqldw-walkthrough

Q153. Which scenario is an example of a streaming workload?

1. sending transactions that are older than a month to an archive
2. sending transactions daily from point of sale (POS) devices
3. sending telemetry data from edge devices
4. sending cloud infrastructure metadata every 30 minutes

Correct Answer

3. sending telemetry data from edge devices

Q154. Azure Synapse Analytics scales storage and compute independently. ______
Azure synapse analytics can be paused to reduce compute costs. ______
An Azure Synapse analytics data warehouse has a fixed storage capacity. ______

Correct Answer

Reference:
https://azure.microsoft.com/en-us/pricing/details/synapse-analytics/

Q155. Which three objects can be added to a Microsoft Power BI dashboard?

1. a report page
2. a Microsoft PowerPoint slide
3. a visualization from a report
4. a dataflow
5. a text box

Correct Answer

1. a report page
3. a visualization from a report
5. a text box

Reference:
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-dashboards
https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-add-widget

Q156. Azure analysis services ______
Azure Data Factory ______
Azure Table Storage ______
Azure Cosmos DB ______
Azure Synapse Analytics ______

Correct Answer

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

Q157. ______ Output data to parquet format.
______ Store data that is in Parquet format.
______ Persist a tabular representation of data that is stored in Parquet format.

Correct Answer

Reference:
https://docs.microsoft.com/en-us/azure/data-factory/supported-file-formats-and-compression-codecs

Q158. What are two uses of data visualization?

1. Represent trends and patterns over time
2. Implement machine learning to predict future values
3. Communicate the significance of data
4. Enforce business logic across reports

Correct Answer

1. Represent trends and patterns over time
3. Communicate the significance of data

Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-data-visualization

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

1. SSIS packages
2. an integration runtime
3. a control flow
4. a pipeline

Correct Answer

2. an integration runtime

Reference:
https://docs.microsoft.com/en-us/azure/data-factory/concepts-integration-runtime

Q160. A pipeline is a representation of a data structure within azure data factory. ______
Azure Data Factory pipelines can execute other pipelines. ______
A processing step within an Azure Data Factory pipeline is an activity. ______

Correct Answer

Q161. What should you use to build a Microsoft Power BI paginated report?

1. Charticulator
2. Power BI Desktop
3. the Power BI service
4. Power BI Report Builder

Correct Answer

4. Power BI Report Builder

Reference:
https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-report-builder-power-bi

Q162. ______ Analyzing historical data containing web traffic collected during the previous year.
______ Classifying images that were uploaded last month.
______ Tracking in real time how many people are currently using a website.

Correct Answer

Q163. In a data warehousing workload, data ______

Correct Answer

Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-workload-management

Q164. What are three characteristics of an Online Transaction Processing (OLTP) workload?

1. denormalized data
2. heavy writes and moderate reads
3. light writes and heavy reads
4. schema defined in a database
5. schema defined when reading unstructured data from a database
6. normalized data

Correct Answer

2. heavy writes and moderate reads
4. schema defined in a database
6. normalized data

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

Q165. Processing salary payments once a month is an example of a batch workload. ______
A wind turbine that sends 50 sensor readings per second is an example of a streaming workload. ______
A home electricity meter that sends readings once a day to an energy provider is an example of a streaming workload. ______

Correct Answer

Q166. Batch workloads ______

Correct Answer

Q167. What is the primary purpose of a data warehouse?

1. to provide answers to complex queries that rely on data from multiple source
2. to provide transformation services between source and target data stores
3. to provide read-only storage of relational and non-relational historical data
4. to provide storage for transactional line-of-business (LOB) applications

Correct Answer

3. to provide read-only storage of relational and non-relational historical data

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

Q168. You can copy a dashboard between Microsoft power BI workspaces. ______
A Microsoft Power BI dashboard can display visualizations from a single dataset. ______
A Microsoft Power BI dashboard can display visualizations from a Microsoft Excel workbook. ______

Correct Answer

Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-across-workspaces
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-dashboards
https://powerbi.microsoft.com/en-us/excel-and-power-bi/

Q169. A Microsoft Power BI ______ enables users to create highly formatted, fixed-layout documents optimized for printing and archiving.

Correct Answer

Reference:
https://powerbi.microsoft.com/en-us/blog/announcing-paginated-reports-in-power-bi-general-availability/

Q170. Azure Databricks is an Apache Spark-based analytics platform. ______
Azure Analysis Services is used for transactional workloads. ______
Azure Data Factory orchestrates data integration workflows. ______

Correct Answer

Reference:
https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-overview
https://docs.microsoft.com/en-us/azure/data-factory/introduction

Q171. You have an on-premises Microsoft SQL Server database.
You need to migrate the database to the cloud. The solution must meet the following requirements:
-> Minimize maintenance effort.
-> Support the Database Mail and Service Broker features.
What should you include in the solution?

1. Azure SQL Database single database
2. an Azure SQL Database elastic pool
3. Azure SQL Managed instance
4. SQL Server on Azure virtual machines

Correct Answer

3. Azure SQL Managed instance

Q172. You have an Azure subscription.
You need to implement approval-based, time-bound role activation.
What should you use?

1. access reviews in Azure AD
2. Azure AD Privileged Identity Management (PIM)
3. Azure AD Identity Protection
4. Conditional access in Azure AD

Correct Answer

2. Azure AD Privileged Identity Management (PIM)

Q173. A company is creating a canvas app to manage weekly status reports from users about projects.
Status reports must be created weekly. Users can enter project tasks with descriptions. Users can also add escalation requests for tasks that are late or at risk.
When a status report is submitted with an escalation request, the app must automatically send a text message to the submitter’s manager. A reminder must be sent at 8 PM on Sunday to everyone who has not yet submitted a status report for the previous week.
You need to identify the appropriate components to use in the solution.
What should you use?

Correct Answer

Reference:
https://docs.microsoft.com/en-us/power-apps/mobile/power-apps-mobile-notification
https://docs.microsoft.com/en-us/power-apps/maker/data-platform/data-platform-create-business-rule

Q174. You have the following two tables of customer data.

Which type of data do the tables contain?

1. structured
2. non-relational
3. semi-structured
4. unstructured

Correct Answer

4. unstructured

Q175. What is a function of a modern data warehouse?

1. supports batch processing only
2. supports real-time and batch processing
3. provides built-in or native online analytical processing
4. stores raw data only

Correct Answer

3. provides built-in or native online analytical processing

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

Q176. Stream processing has access to the most recent data received or data within a rolling time window. ______
Batch processing must occur immediately and have latency in the order of seconds or milliseconds. ______
Stream processing is used for simple response functions, aggregates, or calculations such as rolling averages. ______

Correct Answer

Q177. An Azure Storage account must have ______ enabled to support Azure Data Lake Storage.

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

Correct Answer

1. a waterfall chart

Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-types-for-reports-and-q-and-a

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

Correct Answer

3. Synapse Link

Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/synapse-link

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

Correct Answer

4. diagnostic

Q181. ______ is an object associated with a table that sorts on their key values.

Correct Answer

Q182. Social media users and followers in a graph database is an example of ______

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.

Correct Answer

4. Hierarchical namespace must be enabled.

Q184. Backing up and restoring data are the responsibilities of a ______

Correct Answer

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

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

Correct Answer

3. Azure Table

Reference:
https://learn.microsoft.com/en-us/azure/architecture/data-guide/technology-choices/data-storage

Q186. In Microsoft Power BI, a ______ is a collection of visualizations that appear together on one or more pages.

Correct Answer

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

Q187. ______ is responsible for managing the security of the data in a database.

Correct Answer

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

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

Correct Answer

3. SQL

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

Correct Answer

4. Azure Cosmos DB

Q190. A non relational database ______

Correct Answer

Q191. Data is retrieved and processed before being saved to a target system. ______
Data is saved to a target system, and then processed. ______
Data is extracted from asource system, and then saved to a target system. ______

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

Correct Answer

1. Azure Databricks

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

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

Correct Answer

1. atomicity

Q194. You have data saved in the following format.

Which format was used?

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

Correct Answer

4. JSON

Q195. You have data saved in the following format.

Which format was used?

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

Correct Answer

4. XML

Q196. ______ enables multiple Azure SQL databases to share resources such as memory, data storage space, and processing power.

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

Correct Answer

3. durability

Q198. In a transactional database that guarantees atomicity all statements in a transaction must complete successfully or the transaction must roll back. ______
In a transactional database that guarantees consistency, all data changes will be logged and accounted for. ______
In a transactional database that guarantees isolation, processes can see only data in a consistent state. ______

Correct Answer

Q199. ______ can be used as part of a lift and shift solution for migrating an on-premises application to the cloud with minimal changes.

Correct Answer

Q200. You have data saved in the following format.

Which format was used?

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

Correct Answer

1. YAML

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

1. GRANT
2. INSERT
3. REVOKE
4. DROP

Correct Answer

2. INSERT

Q202. What should you use to automatically delete blobs from Azure Blob Storage?

1. archive storage
2. the change feed
3. soft delete
4. a lifecycle management policy

Correct Answer

4. a lifecycle management policy

Q203. ______ is responsible for creating visuals and charts that help a company make informed decisions.

Correct Answer

Q204. XML formatted files are examples of ______

Correct Answer

Q205. ______ enables multiple Azure SQL databases to share resources such as memory, data storage space, and processing power.

Correct Answer

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

Q206. A data engineer is responsible for which task?

1. Explore data to identify trends.
2. Implement policies, tools, and processes for backup and recovery plans.
3. Design and build analytical models.
4. Design and implement data stores for analytical workloads.

Correct Answer

2. Implement policies, tools, and processes for backup and recovery plans.

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

1. Table
2. Cassandra
3. Core (SQL)
4. Gremlin

Correct Answer

4. Gremlin

Q208. Data in a data warehouse can be aggregated and loaded into an Online Analytical Processing (OLAP) model, which is also known as ______

Correct Answer

Reference:
https://aws.amazon.com/what-is/olap/

Q209. The ______ clause can be used in Data Manipulation Language(DML) statements to specify the criteria that rows must watch.

Correct Answer

Q210. In Azure Table storage, each row in a table must be uniquely identified by which two components?

1. a partition key
2. a range
3. a row key
4. a timestamp

Correct Answer

1. a partition key
3. a row key

Q211. What is a primary characteristic of a relational database?

1. a flexible data structure
2. data is queried and manipulated by using a variant of the SQL language
3. a lack of dependencies between tables
4. a large amount of duplicate data

Correct Answer

4. a large amount of duplicate data

Q212. You have an Azure virtual machine named VM1.
You plan to encrypt VM1 by using Azure Disk Encryption.
Which Azure resource must you create first?

1. an Azure Storage account
2. an Azure Key Vault
3. an Azure Information Protection policy
4. an Encryption key

Correct Answer

2. an Azure Key Vault

Reference:
https://docs.microsoft.com/en-us/azure/virtual-machines/windows/disk-encryption-overview

Q213. In a fully normalized database, how is data read and written for a single entity?

1. Data is read from multiple tables and written to multiple tables.
2. Data is read from a single table and written to a single table.
3. Data is read from a single table and written to multiple tables.
4. Data is read from multiple tables and written to a single table.

Correct Answer

2. Data is read from a single table and written to a single table.

Q214. ______ A solution that copies data from files and Online Transaction Processing(OLTP) databases into an analytical processing system.
______ Contains numeric values that can be analyzed.
______ A solution that stores data in a relational schema that is optimized for read operations.

Correct Answer

Q215. What is a characteristic of a non-relational database?

1. full support for Transact-SQL
2. a fixed schema
3. self-describing entities

Correct Answer

3. self-describing entities

Q216. ______ are used to compare two numeric measures and identify a relationship or correlation between them.

Correct Answer

Q217. A bank has a system that manages financial transactions.
When transferring money between accounts. the system must never retrieve a value for the source account that reflects the balance before the transfer and a value for the destination account that reflects the balance after the transfer.
Of which ACID semantic is this an example?

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

Correct Answer

1. atomicity

Q218. You need to store event log data that is semi-structured and received as the logs occur.
What should you use?

1. Azure Table storage
2. Azure Queue storage
3. Azure Files

Correct Answer

1. Azure Table storage

Q219. Azure Data Lake Storage can be used as a staging area for ingested data before the data is converted into a format suitable for performing analytics. ______
Azure Data Factory is an analytics engine that uses a massively parallel processing(MPP) architecture. ______
Azure HDinsight enables you to build tabular models from multiple data sources to support online analytical processing(OLAP) queries. ______

Correct Answer

Q220. Power Virtual Agents chatbots can be created directly in Microsoft Teams. ______
Power Virtual Agents chatbots can use the bot testing feature directly within Microsoft Teams. ______

Correct Answer

Q221. In a graph database, edges specify relationships between ______

Correct Answer

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

1. Table
2. Cassandra
3. NoSQL
4. Gremlin

Correct Answer

4. Gremlin

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

Q223. Relational data uses ______ to enforce relationships between different tables.

Correct Answer

Q224. Which Azure SQL offering provides near-100 percent compatibility with on-premises Microsoft SQL Server instances, while providing automated updates. backups, and maintenance tasks?

1. Azure SQL Managed Instance
2. SQL Server on Azure Virtual Machines
3. Azure SQL Database
4. Azure SQL Edge

Correct Answer

1. Azure SQL Managed Instance

Q225. Online analytical processing(OAP) systems are particularly suitable for analytical workloads because data is ______

Correct Answer

Q226. ______ Azure Data Explorer
______ Azure Stream Analytics
______ Azure Synapse Analytics.

Correct Answer

Q227. You create Azure File Storage in a storage account. ______
The Premium tier of Azure File Storage uses HDD-based hardware in a datacenter. ______
The Standard tier of Azure File Storage uses SSDs. ______

Correct Answer

Q228. ______ provides a full range of Power BI data modeling and report editing features.

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

Correct Answer

3. Apache Parquet

Reference:
https://www.databricks.com/glossary/what-is-parquet

Q230. In an analytical model designed as a star schema, the entities by which you aggregate or slice measures are called ______

Correct Answer

Q231. Relational databases are commonly used to store and query ______

Correct Answer

Q232. Online transaction processing(OLTP) relies on a database system where data storage is optimized for both read and write operations. ______
Online analytical processing(OLAP) relies on a database system where data storage is optimized for both read and write operations. ______
Data warehouses are optimized for read operations. ______

Correct Answer

Q233. After you create Microsoft Power BI data models and reports, you can publish them to ______

Correct Answer

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

Q234. An extract, load, and transform(ETL) process requires ______

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

Correct Answer

4. a row

Q236. The Azure Cosmos DB ______ API enables the use of select statements to retrieve documents from Azure Cosmos DB.

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)

Correct Answer

1. a data warehouse

Q238. Data stored in the Hot access tier of Azure Blob storage is stored on high-performance media. ______
Ther Cool access tier in Azure Blob storage incurs higher storage costs compared to the Hot access tier. ______
The Archive access tier in Azure Blob storage has the highest latency of the three available tiers. ______

Q239. Azure Blob Storage ______
Azure Cosmos DB for NoSQL ______
Azure Data Factory ______
Azure SQL Database ______

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

Correct Answer

3. a single database in Azure SQL Database

Reference:
https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview?view=azuresql&tabs=general-purpose

Q241. The ______ service is optimized for IoT solutions.

Correct Answer

Q242. The ______ file format uses a hierarchical document schema to define data entities that have multiple attributes.

Correct Answer

Q243. Database administrators apply data cleansing routines and turn data into useful information. ______
Data engineers manage databases, store backup copies of data, and restore data in the event of a failure. ______
Data analysts create data visuals and enable companies to make data-driven decisions. ______

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

Correct Answer

1. recording small units of work events in real time

Reference:
https://www.ibm.com/topics/workload

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

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

Correct Answer

1. INSERT

Q246. ______ are responsible for the availability performance and optimization of databases.

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

Correct Answer

4. Archive to Cool

Reference:
https://learn.microsoft.com/en-us/azure/storage/blobs/archive-rehydrate-overview

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

Correct Answer

4. Azure Cosmos DB for Apache Gremlin

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

Q249. ______ Assign permissions to users.
______ Derive meaning from data by creating visualization and charts.
______ Implement which pipelines to transfer and transform data between systems.

Correct Answer

Q250. ______ Create a pipeline to transfer data from a database to a data warehouse.
______ Create a transactional database.
______ Create a chart that shows sales transactions by week.

Correct Answer

Q251. A bank needs to ensure that after an account transfer transaction completes, the revised account balances persists even if the database system hosting the transaction becomes temporarily unavailable.
Of which ACID semantic is this an example?

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

Correct Answer

1. durability

Q252. You have a banking application that transfers money in to and out of accounts.
Of which type of solution is this is an example?

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

Correct Answer

1. online transaction processing (OLTP)

Q253. The ______ format is used to store delimited data, separate data fields by using commas, and terminates rows by using a carriage return.

Correct Answer

Reference:
https://support.microsoft.com/en-us/office/excel-formatting-and-features-that-are-not-transferred-to-other-file-formats-8fdd91a3-792e-4aef-a5bb-46f603d0e585

Q254. What is a difference between structured data and semi-structured data?

1. Only Structured data supports entities.
2. Structured data has a fixed schema and semi-structured data has a flexible schema.
3. Structured data has a flexible schema and semi-structured data has a fixed schema.
4. Only Structured data supports attributes.

Correct Answer

2. Structured data has a fixed schema and semi-structured data has a flexible schema.

Q255. Azure Storage account ______
File share ______
Container ______

Correct Answer

Q256. In a relational database, the schema is defined before data is written to the table. ______
Key/value data stores are highly optimized for complex queries that contain multiple joins. ______
A relational database is commonly used to store and query structured data. ______

Correct Answer

Q257. ______ Database backup and recovery.
______ Enabling advanced analytic capabilities through reports.
______ Monitoring data pipelines.

Q258. Which language is used to define queries in Azure Synapse Data Explorer?

1. Bash
2. PowerShell
3. KQL
4. SQL

Correct Answer

3. KQL

Reference:
https://learn.microsoft.com/en-us/azure/data-explorer/data-explorer-overview

Q259. Azure Cosmos DB for Apache Cassandra API ______
Azure Cosmos DB for Apache Gremlin API ______
Azure Cosmos DB for NoSQL API ______
Azure Cosmos DB for Table API ______

Correct Answer

Q260. A bank needs to ensure that a transaction involving debiting funds from a source account and crediting the same funds to a destination account must complete both actions. If either action falls to complete, the other action must fail.
Of which ACID semantic is this an example?

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

Correct Answer

3. atomicity

Q261. SELECT INSERT and UPDATE are examples of which type of SQL statement?

1. Data Definition Language (DDL)
2. Data Control Language (DCL)
3. Data Manipulation Language (DML)

Correct Answer

3. Data Manipulation Language (DML)

Q262. An online analytical processing (OLAP) model stores ______ data that is optimized for analytical workloads.

Correct Answer

Q263. ______ is an example of a Data Manipulation Language(DML) statement.

Correct Answer

Q264. The pgadmin tool can be used to manage Azure Database for PostgreSQL. ______
Azure Database for MariaDB offers point-in-time restore for up to 365 days. ______
Azure Database for MySQL always requires SSL connections. ______

Correct Answer

Q265. Azure Data Explorer uses ______ to explore, filter, and aggregate data quickly.

Correct Answer

Reference:
https://learn.microsoft.com/en-us/azure/data-explorer/data-explorer-overview

Q266. ______ is responsible for finding hidden patterns in data and creating graphical reports that deliver information in a useful and appealing format.

Correct Answer

Q267. A JSON document that contains customer entities with a variable number of properties is an example of ______ data.

Correct Answer

Q268. You have an e-commerce application that reads and writes data to an Azure SQL database.
Which type of processing does the application use?

1. stream processing
2. batch processing
3. Online Analytical Processing (OLAP)
4. Online Transaction Processing (OLTP)

Correct answer

4. Online Transaction Processing (OLTP)

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

1. to automate the creation of an interdependent group of Azure resources in a repeatable way
2. to apply Azure policies for multi-tenant deployments
3. to provision Azure subscriptions
4. to control which services and feature administrators and developers can deploy from the Azure portal

Correct answer

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

Reference:
https://docs.microsoft.com/en-us/azure/azure-resource-manager/templates/overview

Q270. You have an Azure SQL database that you access directly from the Internet.
You recently changed the public IP address of your computer.
After changing the IP address, you can no longer access the database. You can connect to other resources in Azure.
What is a possible cause of the issue?

1. role-based access control (RBAC)
2. Dynamic Host Configuration Protocol (DHCP)
3. Domain Name Service (DNS)
4. a database-level firewall

Correct answer

4. a database-level firewall