Microsoft DP-900 Practice Test - Questions Answers, Page 21
List of questions
Question 201

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

Which Azure storage solution provides native support for POSIX-compliant access control lists (ACLs)?
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-access-control
Question 203

A bar chart showing year-to-date sales by region is an example of which type of analytics?
Question 204

Which setting can only be configured during the creation of an Azure Cosmos DB account?
Explanation:
You must create a separate account for each API.
Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/how-to-manage-database-account
Question 205

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?
Explanation:
https://docs.microsoft.com/en-us/azure/cosmos-db/synapse-link
Question 206

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?
Explanation:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-types-for-reports-and-q-and-a
Question 207

Which type of database is Azure Database for PostgreSQL?
Explanation:
Reference: https://docs.microsoft.com/en-us/azure/postgresql/overview-postgres-choose-server-options
Question 208

Which storage solution supports access control lists (ACLs) at the file and folder level?
Explanation:
Azure Data Lake Storage Gen2 implements an access control model that supports both Azure role-based access control (Azure RBAC) and POSIX-like access control lists (ACLs).
Reference: https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-access-control
Question 209

What is a characteristic of batch processing?
Explanation:
Box 1: Yes Tables are database objects that contain all the data in a database. In tables, data is logically organized in a row-and-column format similar to a spreadsheet. Each row represents a unique record, and each column represents a field in the record.
Box 2: No
An index is an on-disk structure associated with a table or view that speeds retrieval of rows from the table or view.
Box 3: Yes
A view is a virtual table whose contents are defined by a query. Like a table, a view consists of a set of named columns and rows of data.
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
Question 210

Which clause should you use in a SELECT statement to combine rows in one table with rows in another table?
Explanation:
Reference:
https://www.tutorialspoint.com/sql/sql-using-joins.htm
Question