<< Prev Question Next Question >>

Question 183/278

You have an Azure Data Lake Storage Gen2 container.
Data is ingested into the container, and then transformed by a data integration application. The data is NOT modified after that. Users can read files in the container but cannot modify the files.
You need to design a data archiving solution that meets the following requirements:
New data is accessed frequently and must be available as quickly as possible.
Data that is older than five years is accessed infrequently but must be available within one second when requested.
Data that us older than seven years is NOT accessed. After seven years, the data must be persisted at the lowest cost possible.
Costs must be minimized while maintaining the required availability.
How should you manage the data? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

LEAVE A REPLY

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

Question List (278q)
Question 1: You have an Azure SQL Database managed instance. The instanc...
Question 2: You have an Azure SQL database named DB 1 in the General Pur...
Question 3: Note: This question is part of a series of questions that pr...
Question 4: What should you do after a failover of SalesSQLDb1 to ensure...
Question 5: You are developing an application that uses Azure Data Lake ...
Question 6: You have an on-premises Microsoft SQL Server 2019 instance n...
Question 7: You have a Microsoft SQL Server database named DB1 that cont...
Question 8: Which audit log destination should you use to meet the monit...
Question 9: DRAG DROP You need to implement statistics maintenance for S...
Question 10: Note: This question is part of a series of questions that pr...
Question 11: What should you implement to meet the disaster recovery requ...
Question 12: You have an Azure SQL managed instance. You need to restore ...
Question 13: You need to recommend a configuration for ManufacturingSQLDb...
Question 14: Note: This question is part of a series of questions that pr...
Question 15: You have an on-premises Microsoft SQL Server 2019 instance t...
Question 16: You are creating a new notebook in Azure Databricks that wil...
Question 17: DRAG DROP You have an Azure SQL database that contains a tab...
Question 18: You need to migrate an on-premises Microsoft SQL Server data...
Question 19: You have an Azure subscription. You need to deploy an Azure ...
Question 20: Which audit log destination should you use to meet the monit...
Question 21: You have an Azure SQL database named DB1. The automatic tuni...
Question 22: You have an Azure subscription that contains the resources s...
Question 23: You have SQL Server on an Azure virtual machine that contain...
Question 24: You have an Azure SQL database. You identify a long running ...
Question 25: You have an Azure SQL database. Users report that the execut...
Question 26: You have a Microsoft SQL Server database named DB1 that cont...
Question 27: You have an Azure SQL database named DB1. You run a query wh...
Question 28: You have an Azure SQL database named DB1. The automatic tuni...
Question 29: You have an Azure SQL database named DB1 that contains two t...
Question 30: You have an Azure data solution that contains an enterprise ...
Question 31: You have SQL Server on Azure virtual machines in an availabi...
Question 32: You have SQL Server on an Azure virtual machine named SQL1. ...
Question 33: Note: This question is part of a series of questions that pr...
Question 34: You have an on-premises Microsoft SQL Server 2019 instance t...
Question 35: You have an Azure SQL database named db1 that contains an Az...
Question 36: You have an Azure Synapse Analytics Apache Spark pool named ...
Question 37: You have an Azure SQL database named DB1. The automatic tuni...
Question 38: You plan to migrate on-premises Microsoft SQL Server databas...
Question 39: You have an Azure SQL database. The database contains a tabl...
Question 40: You are planning disaster recovery for the failover group of...
Question 41: You are provisioning an Azure SQL database in the Azure port...
Question 42: You have an Azure SQL database named db1 that contains an Az...
Question 43: You are designing a star schema for a dataset that contains ...
Question 44: You have a data warehouse in Azure Synapse Analytics. You ne...
Question 45: You have an Azure virtual machine named VM1 on a virtual net...
Question 46: You need to recommend the appropriate purchasing model and d...
Question 47: You are designing an enterprise data warehouse in Azure Syna...
Question 48: You have an on-premises Microsoft SQL Server 2016 server nam...
Question 49: You have an Azure virtual machine named VM1 on a virtual net...
Question 50: You have an Azure SQL Database managed instance named sqldbm...
Question 51: You plan to migrate on-premises Microsoft SQL Server databas...
Question 52: You need to recommend a configuration for ManufacturingSQLDb...
Question 53: You have an Azure SQL database named DB1 that contains two t...
Question 54: You have an Azure SQL managed instance. You need to restore ...
Question 55: You have an Azure SQL database. You have a query and the ass...
Question 56: You have an Azure Data Lake Storage Gen2 container. Data is ...
Question 57: You have an Azure subscription that contains the resources s...
Question 58: You have a new Azure SQL database named DB1 on an Azure SQL ...
Question 59: HOTSPOT You need to recommend the appropriate purchasing mod...
Question 60: You have an Azure subscription that uses a domain named cont...
Question 61: You have an Azure Data Lake Storage Gen2 account named accou...
Question 62: You are building a database backup solution for a SQL Server...
Question 63: You have an Azure Data Lake Storage Gen2 account named accou...
Question 64: You need to configure user authentication for the SERVER1 da...
Question 65: You have an Azure SQL managed instance named SQLMI1 that has...
Question 66: You are evaluating the business goals. Which feature should ...
Question 67: You are building a database in an Azure Synapse Analytics se...
Question 68: You have an on-premises Microsoft SQL Server 2016 server nam...
Question 69: You have an Azure SQL database named db1. You need to retrie...
Question 70: You have a SQL Server on Azure Virtual Machines instance nam...
Question 71: You need to implement statistics maintenance for SalesSQLDb1...
Question 72: You need to recommend a configuration for ManufacturingSQLDb...
Question 73: You need to design an analytical storage solution for the tr...
Question 74: Note: This question is part of a series of questions that pr...
Question 75: You have a Microsoft SQL Server 2019 database named DB1 that...
Question 76: You have the following Azure Data Factory pipelines: * Inges...
Question 77: You have an Azure SQL database. You have a query and the ass...
Question 78: You have an Azure SQL database named DB1. You need to ensure...
Question 79: You have an Azure virtual machine named VM1 on a virtual net...
Question 80: Which windowing function should you use to perform the strea...
Question 81: You have two Azure virtual machines named VM1 and VM2 that r...
Question 82: You have an Azure SQL database named DB1 that contains two t...
Question 83: You have an Azure Synapse Analytics workspace named WS1 that...
Question 84: You have a Microsoft SQL Server 2017 server that hosts five ...
Question 85: What should you use to migrate the PostgreSQL database?...
Question 86: You have an Azure data factory that has two pipelines named ...
Question 87: You have SQL Server on Azure virtual machines in an availabi...
Question 88: You have SQL Server on an Azure virtual machine that contain...
Question 89: A company plans to use Apache Spark analytics to analyze int...
Question 90: You have an Azure Data Factory instance named ADF1 and two A...
Question 91: You have an Azure SQL database named DBI that contains a non...
Question 92: You have an Azure SQL managed instance named SQLMI1 that hos...
Question 93: You have an Azure SQL database named DB1 that contains two t...
Question 94: You have an Azure SQL database named db1 that contains an Az...
Question 95: You are provisioning an Azure SQL database in the Azure port...
Question 96: You have an Azure subscription that is linked to a hybrid Az...
Question 97: You have a Microsoft SQL Server database named DB1 that cont...
Question 98: You have SQL Server on an Azure virtual machine that contain...
Question 99: You have SQL Server on an Azure virtual machine. You review ...
Question 100: You are creating a new notebook in Azure Databricks that wil...
Question 101: You need to identify the cause of the performance issues on ...
Question 102: You have an Azure SQL database named that contains a table n...
Question 103: You are provisioning an Azure SQL database in the Azure port...
Question 104: You have an Azure SQL managed instance named SQL1 and two Az...
Question 105: HOTSPOT You have an Azure SQL database named DB1. The automa...
Question 106: You have an Azure SQL database. You have a query and the ass...
Question 107: Note: This question is part of a series of questions that pr...
Question 108: You have an Azure subscription that is linked to an Azure AD...
Question 109: You have SQL Server on an Azure virtual machine that contain...
Question 110: DRAG DROP You have SQL Server on an Azure virtual machine th...
Question 111: You plan to create a table in an Azure Synapse Analytics ded...
Question 112: You have an Azure SQL database named DB1 that contains a tab...
Question 113: You need to implement the surrogate key for the retail store...
Question 114: You need to implement the surrogate key for the retail store...
Question 115: You have an Azure subscription that is linked to a hybrid Az...
Question 116: You are planning the migration of the SERVER1 databases. The...
Question 117: You are creating a new notebook in Azure Databricks that wil...
Question 118: You need to implement authentication for ResearchDB1. The so...
Question 119: You have an on-premises Microsoft SQL Server 2019 instance t...
Question 120: You have a Microsoft SQL Server database named DB1 that cont...
Question 121: You are building an Azure Stream Analytics job to retrieve g...
Question 122: You are performing exploratory analysis of bus fare data in ...
Question 123: Note: This question is part of a series of questions that pr...
Question 124: You have SQL Server 2019 on an Azure virtual machine that co...
Question 125: You are planning the migration of the SERVER1 databases. The...
Question 126: You manage 100 Azure SQL managed instances located across 10...
Question 127: You are evaluating the role assignments. For each of the fol...
Question 128: You have an Azure SQL Database instance named DatabaseA on a...
Question 129: You have a 50-TB Microsoft SQL Server database named DB1. Yo...
Question 130: You have an Azure subscription that contains a logical SQL s...
Question 131: You have an Azure subscription that contains the resources s...
Question 132: You need to use an Azure Resource Manager ARM) template to d...
Question 133: You have an Azure SQL database that contains a table named E...
Question 134: You have an Azure subscription that contains an Azure SQL ma...
Question 135: You are designing an enterprise data warehouse in Azure Syna...
Question 136: Based on the PaaS prototype, which Azure SQL Database comput...
Question 137: You have an Azure subscription that contains an Azure SQL da...
Question 138: HOTSPOT You need to recommend a configuration for Manufactur...
Question 139: You have an Azure SQL database named db1 that contains an Az...
Question 140: Note: This question is part of a series of questions that pr...
Question 141: You have an Azure SQL database named db1. You need to retrie...
Question 142: You plan to migrate on-premises Microsoft SQL Server databas...
Question 143: You have SQL Server on an Azure virtual machine that contain...
Question 144: You create a new Azure SQL managed instance named SQL1 and e...
Question 145: You configure version control for an Azure Data Factory inst...
Question 146: You need to configure user authentication for the SERVER1 da...
Question 147: Which audit log destination should you use to meet the monit...
Question 148: You configure a long-term retention policy for an Azure SQL ...
Question 149: You have an Azure SQL database named DB1 that contains two t...
Question 150: You have an Azure SQL logical server. You run the following ...
Question 151: You have an Azure SQL database named DB1 that contains two t...
Question 152: Your on-premises network contains a server that hosts a 60-T...
Question 153: You have an Azure subscription that contains an Azure SQL ma...
Question 154: You have an Azure Data Factory pipeline that is triggered ho...
Question 155: You are building an Azure Stream Analytics job to retrieve g...
Question 156: You need to implement statistics maintenance for SalesSQLDb1...
Question 157: You plan to create a table in an Azure Synapse Analytics ded...
Question 158: You have an Azure SQL database that contains a table named f...
Question 159: You have an on-premises Microsoft SQL Server 2019 instance t...
Question 160: You have a Microsoft SQL Server 2019 instance in an on-premi...
Question 161: You have an Azure subscription that contains an Azure SQL ma...
Question 162: You have 50 Azure SQL databases. You need to notify the data...
Question 163: You have an Azure Synapse Analytics dedicated SQL pool. You ...
Question 164: You have a burstable Azure virtual machine named VMI that ho...
Question 165: You deploy a database to an Azure SQL Database managed insta...
Question 166: You have a 50-TB Microsoft SQL Server database named DB1. Yo...
Question 167: You have an Azure Data Factory instance named ADF1 and two A...
Question 168: You need to identify the cause of the performance issues on ...
Question 169: You have an Azure SQL database named DB 1 in the General Pur...
Question 170: You are evaluating the role assignments. For each of the fol...
Question 171: You need to design an analytical storage solution for the tr...
Question 172: You have an Azure SQL database named DB1. You have a table n...
Question 173: You are designing a security model for an Azure Synapse Anal...
Question 174: You have an Azure SQL database. You need to identify whether...
Question 175: You have a resource group named App1Dev that contains an Azu...
Question 176: Note: This question is part of a series of questions that pr...
Question 177: You have an Azure SQL database that contains a table named E...
Question 178: You have a SQL Server on Azure Virtual Machines instance tha...
Question 179: You have an Azure Data Lake Storage Gen2 account named accou...
Question 180: You have an Azure SQL database. You need to identify whether...
Question 181: You have several Azure SQL databases on the same Azure SQL D...
Question 182: You have a SQL Server on Azure Virtual Machines instance nam...
Question 183: You have an Azure Data Lake Storage Gen2 container. Data is ...
Question 184: You need to recommend a configuration for ManufacturingSQLDb...
Question 185: You have an Azure SQL database named DB1. You need to displa...
Question 186: You have a new Azure SQL database. The database contains a c...
Question 187: Note: This question is part of a series of questions that pr...
Question 188: You configure a long-term retention policy for an Azure SQL ...
Question 189: You have a version-8.0 Azure Database for MySQL database. Yo...
Question 190: You need to recommend a configuration for ManufacturingSQLDb...
Question 191: You have an Azure SQL database that contains a table named E...
Question 192: Note: This question is part of a series of questions that pr...
Question 193: You are designing a streaming data solution that will ingest...
Question 194: What should you do after a failover of SalesSQLDb1 to ensure...
Question 195: You have an Azure SQL database named db1 on a server named s...
Question 196: You are planning the migration of the SERVER1 databases. The...
Question 197: You have a new Azure SQL database. The database contains a c...
Question 198: You have the following Azure Resource Manager template. (Exh...
Question 199: HOTSPOT You need to implement the monitoring of SalesSQLDb1....
Question 200: You have an Azure SQL database named DB1. The automatic tuni...
Question 201: You have SQL Server on an Azure virtual machine. You review ...
Question 202: You have an Azure Data Factory instance named ADF1 and two A...
Question 203: Your company uses Azure Stream Analytics to monitor devices....
Question 204: You have an instance of SQL Server on Azure Virtual Machines...
Question 205: You are planning the migration of the SERVER1 databases. The...
Question 206: Note: This question is part of a series of questions that pr...
Question 207: You have a new Azure SQL database named DB1 on an Azure SQL ...
Question 208: You have an Azure virtual machine named VM1 on a virtual net...
Question 209: You have an Azure subscription. You plan to deploy a new Azu...
Question 210: HOTSPOT You need to implement the monitoring of SalesSQLDb1....
Question 211: You have a new Azure SQL database named DB1 on an Azure SQL ...
Question 212: You have an Azure subscription that contains a SQL Server on...
Question 213: You are planning the migration of the SERVER1 databases. The...
Question 214: You have a SQL Server on Azure Virtual Machines instance nam...
Question 215: You have an Azure Synapse Analytics Apache Spark pool named ...
Question 216: From a website analytics system, you receive data extracts a...
Question 217: Note: This question is part of a series of questions that pr...
Question 218: You have an Azure SQL Database managed instance named sqldbm...
Question 219: You have SQL Server 2019 on an Azure virtual machine that ru...
Question 220: You have an Azure Data Factory pipeline that performs an inc...
Question 221: You need to implement the monitoring of SalesSQLDb1. The sol...
Question 222: You have a new Azure SQL database named DB1 on an Azure SQL ...
Question 223: You have an Azure SQL database named DB1. You need to ensure...
Question 224: You have an Azure subscription that contains a group named G...
Question 225: You have an Azure Synapse Analytics dedicated SQL pool named...
Question 226: You have a SQL Server on Azure Virtual Machines instance nam...
Question 227: HOTSPOT You have a Microsoft SQL Server database named DB1 t...
Question 228: You have an Azure SQL database named DB1 that contains two t...
Question 229: You plan to move two 100-GB databases to Azure. You need to ...
Question 230: DRAG DROP You need to apply 20 built-in Azure Policy definit...
Question 231: You have a Microsoft SQL Server database named DB1 that cont...
Question 232: You have SQL Server on an Azure virtual machine that contain...
Question 233: You have an Azure subscription that contains the resources s...
Question 234: Note: This question is part of a series of questions that pr...
Question 235: You have SQL Server on an Azure virtual machine named SQL1. ...
Question 236: You have an on-premises Microsoft SQL Server 2019 instance t...
Question 237: You have an Azure data solution that contains an enterprise ...
Question 238: You plan to migrate on-premises Microsoft SQL Server databas...
Question 239: You configure version control for an Azure Data Factory inst...
Question 240: You have an Azure SQL database that contains a table named C...
Question 241: You plan to create a table in an Azure Synapse Analytics ded...
Question 242: DRAG DROP You have an Azure SQL Database instance named Data...
Question 243: You need to implement authentication for ResearchDB1. The so...
Question 244: Note: This question is part of a series of questions that pr...
Question 245: You have the following Azure Resource Manager template. (Exh...
Question 246: You are designing an enterprise data warehouse in Azure Syna...
Question 247: You have SQL Server on an Azure virtual machine that contain...
Question 248: You have an Azure SQL database named DB1. DB1 contains a tab...
Question 249: You have an Azure subscription that is linked to an Azure AD...
Question 250: You have SQL Server on an Azure virtual machine that contain...
Question 251: You plan to move two 100-GB databases to Azure. You need to ...
Question 252: You have an Azure Data Factory instance named ADF1 and two A...
Question 253: You are designing an enterprise data warehouse in Azure Syna...
Question 254: You have an Azure SQL database named DB1 that contains two t...
Question 255: You are building a database in an Azure Synapse Analytics se...
Question 256: You plan to develop a dataset named Purchases by using Azure...
Question 257: You have an Azure virtual machine named VM1 on a virtual net...
Question 258: You need to implement statistics maintenance for SalesSQLDb1...
Question 259: You have a Microsoft SQL Server 2019 instance in an on-premi...
Question 260: You plan to develop a dataset named Purchases by using Azure...
Question 261: You are designing a security model for an Azure Synapse Anal...
Question 262: You plan to develop a dataset named Purchases by using Azure...
Question 263: You have a resource group named App1Dev that contains an Azu...
Question 264: From a website analytics system, you receive data extracts a...
Question 265: You have an Azure SQL database named DB1. You run a query wh...
Question 266: Note: This question is part of a series of questions that pr...
Question 267: You have an Azure subscription. You plan to deploy a new Azu...
Question 268: You have an Azure Data Factory instance named ADF1 and two A...
Question 269: You have an Azure SQL database named that contains a table n...
Question 270: You have an Azure data factory that has two pipelines named ...
Question 271: You have an Azure subscription that contains an Azure SQL ma...
Question 272: You have two Azure virtual machines named VM1 and VM2 that r...
Question 273: You have an instance of SQL Server on Azure Virtual Machine ...
Question 274: You are building a database in an Azure Synapse Analytics se...
Question 275: You have SQL Server on an Azure virtual machine. You need to...
Question 276: You have an Azure AD tenant and a logical Microsoft SQL serv...
Question 277: You have an Azure SQL Database managed instance named SQLMI1...
Question 278: You have an Azure subscription that contains the resources s...