Practice Questions For Azure Data DP-900 Fundamentals Exam Pt.2Questions With 100% Correct Answers.

100. Which clause should you use to retrieve the related data from multiple tables? - JOIN A join condition defines the way two tables are related in a query by: Specifying the column from each table to be used for the join. A typical join condition specifies a foreign key from one table and its associated primary key in the other table. Specifying a logical operator (for example, = or <>,) to be used in comparing values from the columns. 101. Consider the following SQL query which type of statement is this? - INSERT INTO MyTable(MyColumn1, MyColumn2, MyColumn3) VALUES (99, 'contoso', 'hello') DML 102. Consider the following SQL query which type of statement is this? - CREATE TABLE MyTable ( MyColumn1 INT NOT NULL PRIMARY KEY, MyColumn2 VARCHAR(50) NOT NULL, MyColumn3 VARCHAR(10) NULL ); DDL 66. We have IaaS, PaaS, SaaS. In which category that Azure data services fall into? - Azure Data Services fall into the PaaS category. These services are a series of DBMSs managed by Microsoft in the cloud. Each data service takes care of the configuration, day-to-day management, software updates, and security of the databases that it hosts. 67. What are currently available relational databases on Azure? - Azure SQL Database Azure Database for MySQL servers Azure Database for MariaDB servers Azure Database for PostgreSQL servers68. Using Azure Data Services reduces the amount of time that you need to invest to administer a DBMS. Is this true? - True 69. What is the availability of these Azure Data Services? - Azure Data Services ensure that your databases are available for at least 99.99% of the time. 70. How Azure data services cost you? - The base price of each service covers underlying infrastructure and licensing, together with the administration charges. Additionally, these services are designed to be always on. This means that you can't shut down a database and restart it later. 71. What is the limitation of Azure data services? - Not all features of a database management system are available in Azure Data Services. This is because Azure Data Services takes on the task of managing the system and keeping it running using hardware situated in an Azure datacenter. Exposing some administrative functions might make the underlying platform vulnerable to misuse, and even open up some security concerns. 72. How do you get more control than Azure Data Services allow? - you can install your database management system on a virtual machine that runs in Azure. 73. Migrating from the system running on-premises to an Azure virtual machine is no different than moving the databases from one on-premises server to another. Is this correct? - True SQL Server running on an Azure virtual machine effectively replicates the database running on real on-premises hardware. 74. When you are running SQL Server on Virtual Machines who takes care of maintaining the SQL Server software and performing the various administrative tasks to keep the database running from day-to-day. - Customer 75. In Which situation you should run the Microsoft SQL Server on Virtual Machines? - This approach is optimized for migrating existing applications to Azure, or extending existing on-premises applications to the cloud in hybrid deployments. A hybrid deployment is a system where part of the operation runs on-premises, and part in the cloud. Your database might be part of a larger system that runs on-premises, although the database elements might be hosted in the cloud.76. What are the capabilities of running SQL Server on Virtual machines? - Create rapid development and test scenarios when you do not want to buy on-premises non-production SQL Server hardware. Become lift-and-shift ready for existing applications that require fast migration to the cloud with minimal changes or no changes. Scale up the platform on which SQL Server is running, by allocating more memory, CPU power, and disk space to the virtual machine. You can quickly resize an Azure virtual machine without the requirement that you reinstall the software that is running on it