Loading provider exams...
Know a question that should be here? Contribute to this exam
Loading provider exams...
Which Azure storage solution natively supports POSIX-compliant access control lists (ACLs)?
Select the answer that correctly completes the sentence.
Match the Azure services with the appropriate locations in the architecture.
Each service may be used once, multiple times, or not at all.
Which type of non-relational data store supports a flexible schema, stores data as JSON files, and keeps all data for an entity within the same document?
Select the answer that correctly completes the sentence.
Go ad-free and unlock Learn Mode, Exam Mode, AstroTutor AI and every premium tool — everything you need to walk in prepared, and confident.
Match the security components to their appropriate scenarios.
Each component may be used once, more than once, or not at all.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
| Yes | No | Statements |
|---|---|---|
| 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. |
Which clause should be used in a SELECT statement to combine rows from one table with rows from another table?
Match the analytics types that can be used to answer the business questions. Each analytics type may be used once, more than once, or not at all.
Select the answer that correctly completes the sentence.
For each statement below, select Yes when it is true. Otherwise, select No.
| Yes | No | Statements |
|---|---|---|
| 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. |
For each statement below, select Yes when it is true. Otherwise, select No.
| Yes | No | Statements |
|---|---|---|
| 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 |
Which statement is an example of Data Definition Language (DDL)?
Select the answer that correctly completes the sentence.
Select the answer that correctly completes the sentence.
Select the answer that correctly completes the sentence.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
| Yes | No | Statements |
|---|---|---|
| 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 |
You intend to deploy an app. The app needs a nonrelational data service that provides latency guarantees of less than 10 ms for reads and writes.
What should you include in the solution?
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
| Yes | No | Statements |
|---|---|---|
| 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. |
For each of the following statements, select Yes if it is true. Otherwise, select No.
| Yes | No | Statements |
|---|---|---|
| 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. |
Your company has a reporting solution containing paginated reports. The reports query a dimensional model in a data warehouse.
Which type of processing does the reporting solution use?
You are provided with the following data.
What type of data is this?
What can be used with built-in notebook support to query and visualize data through a web-based interface?
Select the answer that correctly completes the sentence.
Select the answer that correctly completes the sentence.
Community Discussion