DP-900 Flashcards
Descriptive analytics tells you
1. what is most likely to occur in the future
2. what occurred in the past
3. which actions you can perform to affect outcomes
4. why something occurred in the past
2
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
1. Normalization involves eliminating relationships between database tables
2. Normalizing a database reduces data redundancy
3. Normalization improves data integrity
- No
- Yes
- Yes
An extract, transform and load (ETL) process requires:
1. a matching schema in the data source and the data target
2. a target data store powerful enough to transform data
3. data that is fully processed before being loaded to the target data store
4. that the data target be a relational database
3
In batch processing
1. data is always inserted one row at a time
2. data is processed in real-time
3. latency in delivery data processing results is acceptable
4. processing can only execute serially
3
Transcibing audio files is an example of
1. cognitive
2. descriptive
3. predictive
4. prescriptive
analytics
1
Match the types of analytics that can be used to answer the business questions.
Cognitive, diagnostic, descriptive, predictive, prescriptive
1. why did sales increase last month?
2. how do I allocate my budget to buy different inventory items?
3. which people are mentioned in a company’s business documents?
- diagnostic
- prescriptive
- descriptive
Are the Customer, Address, and Social Media objects:
a) a nested array
b) a nested object
c) a root object
Customer - root object
Address - nested object
Social media - nested array
The data model is:
- transactional model
- star schema
- snowflake schema
Customer is a [] table:
- fact
- dimension
- bridge
- star
- dimension
distributes processing across compute nodes
a clustered index
transactional writes
yes
yes
yes
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? To answer, drag the appropriate locations to the correct stages. Each location may be used once, more than once, or not at all.
Extract: CRM system
Load: Data warehouse
Transform: Data warehouse
descriptive
Match the types of visualizations to the appropriate descriptions.
To answer, drag the appropriate visualization type from the column on the left to its description on the right. Each visualization type may be used once, more than once, or not at all.
Tree map
Key influencer
Scatter
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? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. zone-redundant storage (ZRS)
B. read-access geo-redundant storage (RA-GRS)
C. locally-redundant storage (LRS)
D. geo-redundant storage (GRS)
B and D
Yes
No
No
Which statement is an example of Data Manipulation Language (DML)?
A. REVOKE
B. DISABLE
C. INSERT
D. GRANT
INSERT
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?
A. an index
B. a view
C. a scalar function
D. a table
a view
simple lookups
Image files - Azure Blob storage
Key/value pairs - Azure Table storage
Relationships - Gremlin API
- Azure Storage account
- Container
What are two characteristics of real-time data processing? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. Data is processed periodically
B. Low latency is expected
C. High latency is acceptable
D. Data is processed as it is created
B and D
Dataset
Linked service
Pipeline
Batch
Streaming
Batch
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? To answer, drag the appropriate locations to the correct stages. Each location may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
Extract: The CRM system
Load: the data warehouse
Transform: the data warehouse
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?
A. predictive
B. prescriptive
C. descriptive
D. diagnostic
A
Which statement is an example of Data Manipulation Language (DML)?
A. REVOKE
B. DISABLE
C. CREATE
D. UPDATE
D Update
descriptive
B
You need to create an Azure resource to store data in Azure Table storage.
Which command should you run?
A. az storage share create
B. az storage account create
C. az cosmosdb create
D. az storage container create
az storage account create
Core (SQL)
You need to modify a view in a relational database by adding a new column.
Which statement should you use?
A. MERGE
B. ALTER
C. INSERT
D. UPDATE
ALTER
Yes
No
Yes
You plan to deploy a PostgreSQL database to Azure.
Which hosting model corresponds to the available deployment options? To answer, select the appropriate options in the answer area.
IaaS
PaaS
cognitive
Graph databases
Which Azure storage solution provides native support for POSIX-compliant access control lists (ACLs)?
A. Azure Table storage
B. Azure Data Lake Storage
C. Azure Queue storage
D. Azure Files
B Azure Data Lake Storage
C) a tabular form of rows and columns
A stored procedure
Diagnostic
Prescriptive
Cognitive
A view
Which type of database is Azure Database for PostgreSQL?
A. Platform as a service (PaaS)
B. Infrastructure as a service (IaaS)
C. Microsoft SQL Server
D. on-premises
Platform as a Service
Which storage solution supports access control lists (ACLs) at the file and folder level?
A. Azure Data Lake Storage
B. Azure Queue storage
C. Azure Blob storage
D. Azure Cosmos DB
Azure Data Lake Storage
Treemap
What is a characteristic of batch processing?
A. The data ingested during batch processing must be processed as soon as the data is received.
B. Large datasets must be split into batches of less than 1 GB before the data can be processed.
C. There is a noticeable time delay between ingesting data and obtaining the data processing results.
D. Batch processing can only process data that is structured.
C
MAX and MIN
Yes
Yes
No
The same set of columns
A clustered index
No
No
Yes
Graph databases
Simple lookups
virtual machine
semi-structured data
semi-structured data
Which property of a transactional workload guarantees that each transaction is treated as a single unit that either succeeds completely or fails completely?
A. atomicity
B. isolation
C. durability
D. consistency
atomicity
Which type of data store is this?
A. key/value
B. object data
C. graph
D. time series
Graph
Which type of database contains nodes and edges?
A. graph
B. key/value
C. columnar
D. time series
graph
data engineer
keys
A. INSERT
B. MERGE
C. UPDATE
D. CREATE
UPDATE
Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance.
Which Azure service should you use?
A. Azure HDInsight
B. Azure SQL Database
C. Azure Cosmos DB
D. SQL Server on Azure Virtual Machines
B. Azure SQL Database
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?
A. Microsoft SQL Server Management Studio (SSMS)
B. Azure Data Studio
C. Azure CLI
D. Azure PowerShell
B. Azure Data Studio
Table
View
Index
You have an e-commerce application that reads and writes data to an Azure SQL database.
Which type of processing does the application use?
A. stream processing
B. batch processing
C. Online Analytical Processing (OLAP)
D. Online Transaction Processing (OLTP)
OLTP
When can you use an Azure Resource Manager template?
A. to automate the creation of an interdependent group of Azure resources in a repeatable way
B. to apply Azure policies for multi-tenant deployments
C. to provision Azure subscriptions
D. to control which services and feature administrators and developers can deploy from the Azure portal
to automate the creation of an interdependent group of Azure resources in a repeatable way
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?
A. role-based access control (RBAC)
B. Dynamic Host Configuration Protocol (DHCP)
C. Domain Name Service (DNS)
D. a database-level firewall
a database level firewall
Microsoft SQL Server Management Studio (SSMS)
Azure Data Studio
Microsoft SQL Server Data Tools (SSDT)
Yes
No
Yes
Which command-line tool can you use to query Azure SQL databases?
A. sqlcmd
B. bcp
C. azdata
D. Azure CLI
sqlcmd
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
You have the following SQL query.
INSERT INTO dbo.Products (ProductID, ProductName, Price, ProductDescription)
VALUES (1, ‘Clamp’, 12.48, ‘Workbench clamp’);
What are dbo.Products and ProductName? To answer, select the appropriate options in the answer area.
Table
Column
No
No
Yes
Which statement is an example of Data Definition Language (DDL)?
A. SELECT
B. JOIN
C. UPDATE
D. CREATE
CREATE
Yes
No
Yes
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?
A. Azure Cosmos DB
B. Azure HDInsight
C. Azure SQL Database
D. Azure Synapse Analytics
Azure SQL Database
What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database?
A. access to the latest features
B. complete control over backup and restore processes
C. in-database machine learning services
D. reduced administrative effort for managing the server infrastructure
access to the latest features
reduced administrative effort
No
Yes
No
How would you query this table to return the average sales per day?
SELECT, GROUP BY
When you create an Azure SQL database, which account can always connect to the database?
A. the Azure Active Directory (Azure AD) account that created the database
B. the server admin login account of the logical server
C. the Azure Active Directory (Azure AD) administrator account
D. the sa account
the server admin
Which statement is an example of Data Definition Language (DDL)?
A. SELECT
B. INSERT
C. DELETE
D. DROP
DROP
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?
A. sqlcmd
B. Microsoft SQL Server Management Studio (SSMS)
C. Azure Data Studio
D. Azure Data Explorer
Azure Data Studio
the database to protect data at rest
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?
A. service principal authentication
B. Azure Active Directory (Azure AD) authentication
C. SQL authentication
D. certificate authentication
Azure Active Directory (Azure AD) authentication)
What is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?
A. built-in high availability
B. native support for cross-database queries and transactions
C. system-initiated automatic backups
D. support for encryption at rest
native support for cross-database queries and transactions
a server-level firewall
You need to design and model a database by using a graphical tool that supports project-oriented offline database development.
What should you use?
A. Microsoft SQL Server Data Tools (SSDT)
B. Microsoft SQL Server Management Studio (SSMS)
C. Azure Databricks
D. Azure Data Studio
Microsoft SQL Server Data Tools (SSDT)
Match the security components to the appropriate scenarios.
Firewall
Authentication
Encryption
You have a transactional application that stores data in an Azure SQL managed instance.
When should you implement a read-only database replica?
A. You need to generate reports without affecting the transactional workload.
B. You need to audit the transactional application.
C. You need to implement high availability in the event of a regional outage.
D. You need to improve the recovery point objective (RPO).
you need to generate reports without affecting the transactional workload
strong consistency guarantees are required
keys
a view
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? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. You must be assigned the Reader role for the resource group that contains the database.
B. You must have SELECT access to the Products table.
C. You must have a user in the database.
D. You must be assigned the Contributor role for the resource group that contains the database.
E. Your IP address must be allowed to connect to the database.
SELECT access, user in the database, IP address
Which clause should you use in a SELECT statement to combine rows in one table with rows in another table?
A. SET
B. JOIN
C. KEY
JOIN
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?
A. Azure Application Gateway
B. Azure Traffic Manager
C. Azure DNS
D. Azure Private Link
Azure Private Link
Azure SQL Database single database = a serverless configuration
Azure SQL Database Managed Instance = highest compatibility with on-prem Microsoft SQL Server
Azure SQL Database elastic pool = a low-cost, low-maintenance database
Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?
A. SELECT
B. WHERE
C. JOIN
WHERE
Azure Synapse Analytics
A clustered index
What are dbo.Products and ProductName?
A Table, a column
Primary key
A view
Which Azure service provides the highest compatibility for databases migrated from Microsoft SQL Server 2019 Enterprise edition?
A. Azure SQL Database
B. Azure Database for MySQL
C. Azure SQL Managed Instance
D. an Azure SQL Database elastic pool
Azure SQL Managed Instance
Which setting can only be configured during the creation of an Azure Cosmos DB account?
A. geo-redundancy
B. multi-region writes
C. production or non-production account type
D. API
API
Key/value
Object
Graph
You have an Azure Cosmos DB account that uses the Core (SQL) API.
Which two settings can you configure at the container level?
A. the throughput
B. the read region
C. the partition key
D. the API
throughput and partition key
Which type of data store should you use?
A. graph
B. key/value
C. object
D. columnar
columnar