Microsoft DP-900 Practice Test - Questions Answers, Page 15

List of questions
Question 141

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.
Section: Describe core data concepts
D: Azure Storage offers two options for copying your data to a secondary region:
Geo-redundant storage (GRS)
Geo-zone-redundant storage (GZRS)
B: With GRS or GZRS, the data in the secondary region isn't available for read or write access unless there is a failover to the secondary region. For read access to the secondary region, configure your storage account to use read-access geo-redundant storage (RA-GRS) or read-access geo-zone-redundant storage (RA-GZRS).
Reference: https://docs.microsoft.com/en-us/azure/storage/common/storage-redundancy#redundancy-in-a-secondary-region
Question 142

Which statement is an example of Data Manipulation Language (DML)?
Data Manipulation Language (DML) statements:
DELETE
INSERT
UPDATE
Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-reference-tsql-statements
Question 143

Which command-line tool can you use to query Azure SQL databases?
The sqlcmd utility lets you enter Transact-SQL statements, system procedures, and script files at the command prompt.
Incorrect Answers:
B: The bulk copy program utility (bcp) bulk copies data between an instance of Microsoft SQL Server and a data file in a user-specified format.
D: The Azure CLI is the defacto tool for cross-platform and command-line tools for building and managing Azure resources.
Reference:
https://docs.microsoft.com/en-us/sql/tools/overview-sql-tools?view=sql-server-ver15
Question 144

Which statement is an example of Data Definition Language (DDL)?
Data Definition Language (DDL) statements defines data structures. Use these statements to create, alter, or drop data structures in a database. These statements include:
ALTER
Collations
CREATE
DROP
DISABLE TRIGGER
ENABLE TRIGGER
RENAME
UPDATE STATISTICS
TRUNCATE TABLE
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/statements/statements
Question 145

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?
Section: Describe how to work with relational data on Azure
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-mfa-ssms-overview
Question 146

What is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?
Section: Describe how to work with relational data on Azure
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/features-comparison
Question 147

You need to design and model a database by using a graphical tool that supports project-oriented offline database development.
What should you use?
Section: Describe how to work with relational data on Azure
Reference: https://docs.microsoft.com/en-us/sql/ssdt/project-oriented-offline-database-development?view=sql-server-ver15
Question 148

You have a transactional application that stores data in an Azure SQL managed instance.
When should you implement a read-only database replica?
Section: Describe how to work with relational data on Azure
Use read-only replicas to offload read-only query workloads.
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/read-scale-out
Question 149

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. (Choose three.)
NOTE: Each correct selection is worth one point.
Section: Describe how to work with relational data on Azure
Incorrect Answers:
A, D: Resource group permissions is not required to query an Azure SQL database table.
Reference: https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/getting-started-with-database-engine-permissions?view=sql-server-ver15
Question 150

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?
Section: Describe how to work with relational data on Azure
Reference: https://docs.microsoft.com/en-us/sql/t-sql/queries/update-transact-sql?view=sql-server-ver15
Question