<< Prev Question Next Question >>

Question 22/75

Based on the PaaS prototype, which Azure SQL Database compute tier should you use?

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (75q)
Question 1: You have an Azure SQL database. You are reviewing a slow per...
Question 2: You are planning the migration of the SERVER1 databases. The...
Question 3: You have an Azure SQL database. You identify a long running ...
Question 4: You have SQL Server 2019 on an Azure virtual machine that ru...
Question 5: You have an Azure SQL database. Users report that the execut...
Question 6: You have a SQL pool in Azure Synapse that contains a table n...
Question 7: You have an Azure SQL managed instance named SQL1 and two Az...
Question 8: Note: This question is part of a series of questions that pr...
Question 9: What should you use to migrate the PostgreSQL database?...
Question 10: Note: This question is part of a series of questions that pr...
Question 11: You have the following Azure Resource Manager template. (Exh...
Question 12: You have an Azure SQL database named DB1. You need to ensure...
Question 13: Note: This question is part of a series of questions that pr...
Question 14: You have SQL Server on an Azure virtual machine that contain...
Question 15: Note: This question is part of a series of questions that pr...
Question 16: You have the following Transact-SQL query. (Exhibit) Which c...
Question 17: You are monitoring an Azure Stream Analytics job. You discov...
Question 18: Which counter should you monitor for real-time processing to...
Question 19: You are creating a managed data warehouse solution on Micros...
Question 20: You create five Azure SQL Database instances on the same log...
Question 21: You have an on-premises Microsoft SQL Server 2019 instance t...
Question 22: Based on the PaaS prototype, which Azure SQL Database comput...
Question 23: You have a new Azure SQL database named DB1 on an Azure SQL ...
Question 24: You have a data warehouse in Azure Synapse Analytics. You ne...
Question 25: You have an Azure subscription that contains an Azure Data F...
Question 26: You have a version-8.0 Azure Database for MySQL database. Yo...
Question 27: You have SQL Server on Azure virtual machines in an availabi...
Question 28: You have an Azure SQL database. The database contains a tabl...
Question 29: Note: This question is part of a series of questions that pr...
Question 30: You have a 50-TB Microsoft SQL Server database named DB1. Yo...
Question 31: You have an Azure SQL database named db1. You need to retrie...
Question 32: You have an Azure SQL database that contains a table named C...
Question 33: Your company uses Azure Stream Analytics to monitor devices....
Question 34: You are designing an enterprise data warehouse in Azure Syna...
Question 35: Note: This question is part of a series of questions that pr...
Question 36: You have an Azure Synapse Analytics workspace named WS1 that...
Question 37: Note: This question is part of a series of questions that pr...
Question 38: You plan to build a structured streaming solution in Azure D...
Question 39: You have an Azure Data Lake Storage Gen2 container. Data is ...
Question 40: You need to design an analytical storage solution for the tr...
Question 41: You are creating a new notebook in Azure Databricks that wil...
Question 42: Note: This question is part of a series of questions that pr...
Question 43: You have an on-premises Microsoft SQL Server 2019 server tha...
Question 44: You have an Azure SQL database. You discover that the plan c...
Question 45: You are designing a star schema for a dataset that contains ...
Question 46: You plan to migrate on-premises Microsoft SQL Server databas...
Question 47: You have an Azure Data Lake Storage Gen2 account named accou...
Question 48: You have an Azure subscription that contains an Azure SQL da...
Question 49: You have an Azure SQL database that contains a table named E...
Question 50: You plan to move two 100-GB databases to Azure. You need to ...
Question 51: A data engineer creates a table to store employee informatio...
Question 52: You have an Azure virtual machine named VM1 on a virtual net...
Question 53: You are developing an application that uses Azure Data Lake ...
Question 54: You have an Azure Data Factory that contains 10 pipelines. Y...
Question 55: You have the following Azure Data Factory pipelines: Ingest ...
Question 56: You have 10 Azure virtual machines that have SQL Server inst...
Question 57: You have SQL Server 2019 on an Azure virtual machine that co...
Question 58: You create all of the tables and views for ResearchDB1. You ...
Question 59: You have an on-premises Microsoft SQL Server 2016 server nam...
Question 60: You have an Azure SQL database named db1 on a server named s...
Question 61: You have an instance of SQL Server on Azure Virtual Machines...
Question 62: A data engineer creates a table to store employee informatio...
Question 63: You have an Azure SQL Database managed instance. The instanc...
Question 64: You have an Azure Synapse Analytics dedicated SQL pool named...
Question 65: You need to trigger an Azure Data Factory pipeline when a fi...
Question 66: You have a Microsoft SQL Server 2019 instance in an on-premi...
Question 67: You have SQL Server on an Azure virtual machine. You need to...
Question 68: You have an Azure SQL database named sqldb1. You need to min...
Question 69: You have an Azure SQL managed instance named SQLMI1 that hos...
Question 70: You have an Azure SQL Database managed instance named SQLMI1...
Question 71: You need to recommend an availability strategy for an Azure ...
Question 72: You are designing a dimension table in an Azure Synapse Anal...
Question 73: You have 50 Azure SQL databases. You need to notify the data...
Question 74: From a website analytics system, you receive data extracts a...
Question 75: Note: This question is part of a series of questions that pr...