- Home
- Microsoft
- Administering Relational Databases on Microsoft Azure
- Microsoft.DP-300.v2025-01-27.q162
- Question 21
Valid DP-300 Dumps shared by ExamDiscuss.com for Helping Passing DP-300 Exam! ExamDiscuss.com now offer the newest DP-300 exam dumps, the ExamDiscuss.com DP-300 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com DP-300 dumps with Test Engine here:
Access DP-300 Dumps Premium Version
(464 Q&As Dumps, 35%OFF Special Discount Code: freecram)
<< Prev Question Next Question >>
Question 21/162
You are creating a new notebook in Azure Databricks that will support R as the primary language but will also support Scala and SQL.
Which switch should you use to switch between languages?
Which switch should you use to switch between languages?
Correct Answer: B
Explanation/Reference:
You can override the default language by specifying the language magic command %<language> at the beginning of a cell. The supported magic commands are: %python, %r, %scala, and %sql.
Reference:
https://docs.microsoft.com/en-us/azure/databricks/notebooks/notebooks-use
You can override the default language by specifying the language magic command %<language> at the beginning of a cell. The supported magic commands are: %python, %r, %scala, and %sql.
Reference:
https://docs.microsoft.com/en-us/azure/databricks/notebooks/notebooks-use
- Question List (162q)
- Question 1: Note: This question is part of a series of questions that pr...
- Question 2: You have two on-premises Microsoft SQL Server instances name...
- Question 3: What should you use to migrate the PostgreSQL database?...
- Question 4: You have a SQL Server on Azure Virtual Machines instance nam...
- Question 5: You have an on-premises Microsoft SQL Server 2016 server nam...
- Question 6: You have an Azure SQL database named DB 1 in the General Pur...
- Question 7: You have an Azure virtual machine named VM1 on a virtual net...
- Question 8: You have an Azure subscription that contains an Azure SQL da...
- Question 9: You have an Azure Databricks workspace named workspace1 in t...
- Question 10: Note: This question is part of a series of questions that pr...
- Question 11: You have an Azure data solution that contains an enterprise ...
- Question 12: You have an Azure subscription that contains two Azure SQL m...
- Question 13: You have an on-premises multi-tier application named App1 th...
- Question 14: You have an on-premises app named App1 that stores data in a...
- Question 15: You have an Azure SQL managed instance named SQL1 and two Az...
- Question 16: A company plans to use Apache Spark analytics to analyze int...
- Question 17: You have an Azure subscription that uses a domain named cont...
- Question 18: You are provisioning an Azure SQL database in the Azure port...
- Question 19: You have an Azure Synapse Analytics Apache Spark pool named ...
- Question 20: You have an on-premises Microsoft SQL server that uses the F...
- Question 21: You are creating a new notebook in Azure Databricks that wil...
- Question 22: Which counter should you monitor for real-time processing to...
- Question 23: Based on the PaaS prototype, which Azure SQL Database comput...
- Question 24: You have an Azure SQL database named DB1 in the General Purp...
- Question 25: You have a 50-TB Microsoft SQL Server database named DB1. Yo...
- Question 26: You have an Azure SQL database that contains a table named C...
- Question 27: You have a SQL Server on Azure Virtual Machines instance nam...
- Question 28: You need to recommend a solution to ensure that the customer...
- Question 29: You create all of the tables and views for ResearchDB1. You ...
- Question 30: You have an Azure subscription. You need to deploy a logical...
- Question 31: You configure a long-term retention policy for an Azure SQL ...
- Question 32: You have an Azure subscription. You plan to deploy an Azure ...
- Question 33: You have an Azure SQL database named DB1. You need to encryp...
- Question 34: You have an Always On availability group deployed to Azure v...
- Question 35: You have an Azure subscription that contains the following r...
- Question 36: You create five Azure SQL Database instances on the same log...
- Question 37: You have an Azure SQL database named that contains a table n...
- Question 38: You have SQL Server 2019 on an Azure virtual machine that ru...
- Question 39: You have an Azure SQL logical server. You run the following ...
- Question 40: You are evaluating the business goals. Which feature should ...
- Question 41: You have an Azure SQL managed instance named SQLMI1 that hos...
- Question 42: You have an Azure virtual machine based on a custom image na...
- Question 43: You need to recommend the appropriate purchasing model and d...
- Question 44: You have the following Azure Resource Manager template. (Exh...
- Question 45: You have two instances of SQL Server on Azure virtual Machin...
- Question 46: Task 11 You have a legacy application written for Microsoft ...
- Question 47: You have SQL Server 2019 on an Azure virtual machine that ru...
- Question 48: You plan to deploy two instances of SQL Server on Azure virt...
- Question 49: You have an Azure virtual machine named Server1 that has Mic...
- Question 50: You have SQL Server on an Azure virtual machine that contain...
- Question 51: You have an Azure SQL database named DB1. You have a table n...
- Question 52: You have an Azure subscription that contain an Azure SQL man...
- Question 53: You are planning disaster recovery for the failover group of...
- Question 54: You need to configure user authentication for the SERVER1 da...
- Question 55: You need to recommend a configuration for ManufacturingSQLDb...
- Question 56: You have an Azure subscription. You plan to deploy an instan...
- Question 57: You have a database named db1. The log for db1 contains the ...
- Question 58: Note: This question is part of a series of questions that pr...
- Question 59: You configure version control for an Azure Data Factory inst...
- Question 60: You need to recommend a disaster recovery solution for an on...
- Question 61: You have 20 Azure SQL databases provisioned by using the vCo...
- Question 62: You have an Azure SQL Database server named sqlsrv1 that hos...
- Question 63: You have an instance of SQL Server on Azure Virtual Machines...
- Question 64: You have a Microsoft SQL Server 2017 server. You need to mig...
- Question 65: Which windowing function should you use to perform the strea...
- Question 66: Your on-premises network contains a Microsoft SQL Server 201...
- Question 67: Vou have an Azure SQL database named DB1. You have 10 Azure ...
- Question 68: You have an Azure SQL database named DB1 that contains a tab...
- Question 69: You have an Azure data factory that has two pipelines named ...
- Question 70: You have an on-premises datacenter that contains a 2-TB Micr...
- Question 71: You have two Azure virtual machines named Server 1 and Serve...
- Question 72: You have an Azure virtual machine named VM1 on a virtual net...
- Question 73: You have an Azure SQL database named DB1 that contains a pri...
- Question 74: You have two on-premises servers that run Windows Server 201...
- Question 75: You configure backup for an Azure SQL database as shown in t...
- Question 76: You have an Azure subscription that contains a logical SQL s...
- Question 77: You have an Azure Data Lake Storage Gen2 container. Data is ...
- Question 78: You need to recommend which service and target endpoint to u...
- Question 79: You have a Microsoft SQL Server 2017 server that hosts five ...
- Question 80: Your company uses Azure Stream Analytics to monitor devices....
- Question 81: You have an Azure subscription that is linked to an Azure AD...
- Question 82: You Save an Azure SCX database named DB1. You need to query ...
- Question 83: You have an Azure SQL database named DBI that contains a non...
- Question 84: You need to recommend a solution to meet the security requir...
- Question 85: You have a new Azure SQL database named DB1 on an Azure SQL ...
- Question 86: You have two on-premises Microsoft SQL Server 2019 instances...
- Question 87: You need to design a data retention solution for the Twitter...
- Question 88: Task 3 You need to ensure that all queries executed against ...
- Question 89: You have an Azure SQL database named DB1. You run a query wh...
- Question 90: You have an Azure subscription that contains a logical SQL s...
- Question 91: You need to implement the surrogate key for the retail store...
- Question 92: Note: This question is part of a series of questions that pr...
- Question 93: You are building a database backup solution for a SQL Server...
- Question 94: You need to recommend an authentication solution for App1 ac...
- Question 95: You plan to deploy Instance1 by using the following script. ...
- Question 96: Note: This question is part of a series of questions that pr...
- Question 97: You have an Azure SQL database named DB1. The automatic tuni...
- Question 98: You are building an Azure Stream Analytics job to retrieve g...
- Question 99: You have an Azure SQL database. You are reviewing a slow per...
- Question 100: You have an Azure Synapse Analytics dedicated SQL pool. You ...
- Question 101: You have an Azure subscription that contains an instance of ...
- Question 102: You have SQL Server on an Azure virtual machine named SQL1. ...
- Question 103: Task 5 You need to configure a disaster recovery solution fo...
- Question 104: You have an Azure SQL database named db1 on a server named s...
- Question 105: You are designing a security model for an Azure Synapse Anal...
- Question 106: You are designing a dimension table in an Azure Synapse Anal...
- Question 107: You have an Azure Stream Analytics job. You need to ensure t...
- Question 108: You have an Azure SQL database. You run the following PowerS...
- Question 109: You have an on-premises Microsoft SQL Server 2019 server tha...
- Question 110: You are designing a date dimension table in an Azure Synapse...
- Question 111: You have an Azure subscription that contains an Azure SQL da...
- Question 112: Task 9 You need to generate an email alert to admin@contoso....
- Question 113: Task 6 You need to ensure that any enhancements made to the ...
- Question 114: You have an Azure SQL database. Users report that the execut...
- Question 115: You have an Azure subscription that contains an instance of ...
- Question 116: You have an Azure SQL database named DB1 that contains two t...
- Question 117: You have an instance of SQL Server on Azure Virtual Machines...
- Question 118: Note: This question is part of a series of questions that pr...
- Question 119: You are planning the migration of the SERVER1 databases. The...
- Question 120: Note: This question is part of a series of questions that pr...
- Question 121: You have an Azure subscription that contains a resource grou...
- Question 122: You need to recommend a solution to ensure that the performa...
- Question 123: You have a resource group named App1Dev that contains an Azu...
- Question 124: You have SQL Server on an Azure virtual machine that contain...
- Question 125: You are designing an anomaly detection solution for streamin...
- Question 126: You need to recommend which configuration to perform twice t...
- Question 127: You have an Azure subscription that contains an Azure SQL da...
- Question 128: You need to use an Azure Resource Manager ARM) template to d...
- Question 129: You have an Azure subscription that contains an instance of ...
- Question 130: You have SQL Server on an Azure virtual machine that contain...
- Question 131: You have an instance of SQL Server on Azure Virtual Machines...
- Question 132: You are planning a solution that will use Azure SQL Database...
- Question 133: You have an Azure virtual machine named VM1 on a virtual net...
- Question 134: You have an Azure SQL database named DB1. A user named User ...
- Question 135: You have SQL Server 2019 or an Azure virtual machine that ru...
- Question 136: You have an Azure SQL database that contains a table named f...
- Question 137: You have an Azure subscription that contains the resources s...
- Question 138: You have an Azure Data Lake Storage Gen2 account named accou...
- Question 139: You have an Azure SQL database. You discover that the plan c...
- Question 140: You plan to create a table in an Azure Synapse Analytics ded...
- Question 141: You have SQL Server on an Azure virtual machine. You need to...
- Question 142: You have an Azure subscription. You create a logical SQL ser...
- Question 143: You have an on-premises Microsoft SQL Server 2016 instance t...
- Question 144: Note: This question is part of a series of questions that pr...
- Question 145: You have an Azure SQL managed instance named SQLMI1 that has...
- Question 146: You have an Azure SQL database. You identify a long running ...
- Question 147: You need to implement a solution to notify the administrator...
- Question 148: You have an on-premises Microsoft SQL Server 2019 database n...
- Question 149: You have 40 Azure SQL databases, each for a different custom...
- Question 150: You have SQL Server on Azure virtual machines in an availabi...
- Question 151: You have an Azure SQL database named DB1. You need to displa...
- Question 152: Note: This question is part of a series of questions that pr...
- Question 153: Note: This question is part of a series of questions that pr...
- Question 154: You have an Azure SQL Database managed instance. The instanc...
- Question 155: You have an Azure SQL database named DB1. DB1 has a table na...
- Question 156: You plan to build a structured streaming solution in Azure D...
- Question 157: You need to migrate an on-premises Microsoft SQL Server data...
- Question 158: You have 25 Azure SQL databases. You need to implement a cen...
- Question 159: You are creating a managed data warehouse solution on Micros...
- Question 160: You plan to deploy two instances of SQL Server on Azure virt...
- Question 161: You configure backups for an Azure SQL database as shown in ...
- Question 162: You have an Azure Data Factory instance named ADF1 and two A...
