Hello friends if you are looking for DP 900 Multiple choice questions | DP 900 MCQ with answers | DP 900 Objective type questions | Azure DP 900 Questions with answers | DP 900 Accenture tech leap answers | Azure DP 900 MCQ
Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?
A. INSERT
B. MERGE
C. UPDATE
D. CREATE
Ans: c
QUESTION 3
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
Ans: b
QUESTION 4
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
Ans: b
QUESTION 5
Which command-line tool can you use to query Azure SQL databases?
A. sqlcmd
B. bcp
C. azdata
D. Azure CLI
Ans: d
QUESTION 6
Which statement is an example of Data Definition Language (DDL)?
A. SELECT
B. JOIN
C. MERGE
D. CREATE
Ans: d
QUESTION 7
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
Ans: b
QUESTION 8
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
Ans: b
QUESTION 9
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
Ans: a
QUESTION 10
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).
Ans: c
QUESTION 11
At which two levels can you set the throughput for an Azure Cosmos DB account? Each correct answer presents a complete solution. (Choose two.)
A. database
B. item
C. container
D. partition
Ans: ac
QUESTION 12
You have an Azure Cosmos DB account that uses the Core (SQL) API.
Which two settings can you configure at the container level? Each correct answer presents a complete solution. (Choose two.)
A. the throughput
B. the read region
C. the partition key
D. the API
Ans: ac
QUESTION 13
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?
A. graph
B. key/value
C. object
D. columna
Ans: d
QUESTION 14
Which storage solution supports role-based access control (RBAC) at the file and folder level?
A. Azure Disk Storage
B. Azure Data Lake Storage
C. Azure Blob storage
D. Azure Queue storage
Ans: b
QUESTION 15
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?
A. Archive
B. Hot
C. Cool
Ans: a
QUESTION 16
Which type of data store will provide the lowest latency to retrieve the data?
A. key/value
B. graph
C. columnar
D. document
Ans: c
QUESTION 19
Which scenario is an example of a streaming workload?
A. sending transactions that are older than a month to an archive
B. sending transactions daily from point of sale (POS) devices
C. sending telemetry data from edge devices
D. sending cloud infrastructure metadata every 30 minutes
Ans: c
QUESTION 20
You need to gather real-time telemetry data from a mobile application.
Which type of workload describes this scenario?
A. Online Transaction Processing (OLTP)
B. batch
C. massively parallel processing (MPP)
D. streaming
Ans: d
QUESTION 21
You have a SQL pool in Azure Synapse Analytics that is only used actively every night for eight hours. You need to minimize the cost of the SQL pool during idle times. The solution must ensure that the data remains intact.
What should you do on the SQL pool?
A. Scale down the data warehouse units (DWUs).
B. Pause the pool.
C. Create a user-defined restore point.
D. Delete the pool
Ans: b
QUESTION 22
Which Azure Data Factory component initiates the execution of a pipeline?
A. a control flow
B. a trigger
C. a parameter
D. an activity
Ans: b
QUESTION 23
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?
A. stream processing
B. batch processing
C. Online Analytical Processing (OLAP)
D. Online Transaction Processing (OLTP)
Ans: c
QUESTION 24
What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution. (Choose three.)
A. denormalized data
B. heavy writes and moderate reads
C. light writes and heavy reads
D. schema on write
E. schema on read
F. normalized data
Ans: bde
QUESTION 25
Which two activities can be performed entirely by using the Microsoft Power BI service? Each correct answer presents a complete solution. (Choose two.)
A. report and dashboard creation
B. report sharing and distribution
C. data modeling
D. data acquisition and preparation
Ans: ad
QUESTION 26
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?
A. a dashboard
B. a report
C. a dataflow
D. Microsoft Power Apps
Ans: b
QUESTION 27
Which two Azure services can be used to provision Apache Spark clusters? Each correct answer presents a complete solution. (Choose two.)
A. Azure Time Series Insights
B. Azure HDInsight
C. Azure Databricks
D. Azure Log Analytics
Ans: cb
QUESTION 28
You have a quality assurance application that reads data from a data warehouse.Which type of processing does the application use?
A. Online Transaction Processing (OLTP)
B. batch processing
C. Online Analytical Processing (OLAP)
D. stream processing
Ans: a
QUESTION 29
Which three objects can be added to a Microsoft Power BI dashboard? Each correct answer presents a complete solution. (Choose three.)
A. a report page
B. a Microsoft PowerPoint slide
C. a visualization from a report
D. a dataflow
E. a text box
Ans: ace
QUESTION 30
Which Azure Data Factory component provides the compute environment for activities?
A. a linked service
B. an integration runtime
C. a control flow
D. a pipeline
Ans: a
Which statement is an example of Data Manipulation Language (DML)?
A. REVOKE
B. DISABLE
C. INSERT
D. GRANT
Ans: c
You have a SQL query that combines customer data and order data. The query includes calculated columns.
You need to persist the SQL query so that other users can use the query.
What should you create?
A. an index
B. a view
C. a scalar function
D. a table
Ans: b
What are two characteristics of real-time data processing? Each correct answer presents a complete solution.
A. Data is processed periodically
B. Low latency is expected
C. High latency is acceptable
D. Data is processed as it is created
Ans: bd
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
Ans: b
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
Ans: b
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
Ans: a
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
Ans: b
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
Ans: b
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)
Ans: d
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
Ans: a
You have an Azure SQL database that you access directly from the Internet.
You recently changed your external IP address.
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
Ans: d