Relational data on Azure
Practise only this domain. 50 questions with explanations, 20 at a time.
Start relational data on AzureSample questions
- A healthcare startup has to run a SQL Server instance inside a virtual machine in Azure. It also needs administrator rights on the guest Windows operating system so it can install a third-party monitoring agent. Which option meets these requirements?Easy
- An order-line table stores a product code that must always match a code that exists in the product catalog table. Which database construct enforces this link between the two tables?Easy
- An HR team wants staff to query employee records without seeing salary columns. The administrator defines a saved SELECT that exposes only the permitted columns. Which object does this describe?Medium
- An Azure SQL Database must keep serving requests if an entire datacenter fails within one region, and the team does not want to build any replicas by hand. Which configuration provides this?Medium
- A web application opens and closes thousands of short database sessions every minute against an Azure Database for PostgreSQL flexible server, and the server keeps hitting its connection limit. Which technique reduces this overhead?Medium
- A telecom keeps a customers table with 400 million rows. Plan A splits the table so customers from different regions sit in separate partitions. Plan B moves rarely used, very wide attachment columns into a companion table keyed by the same customer ID. Which statement correctly names these two approaches?Medium
- A manufacturer wants a managed SQL database running on its own Kubernetes cluster inside a factory, because the data must stay on site. The company still wants to view and govern that instance from the Azure portal. Which offering matches this need?Medium
- Sales representatives in every region query one shared orders table. Each representative should see only orders from their own territory, and the filtering must happen inside the database so no application code changes. Which feature should be applied?Hard