Explore topic-wise InterviewSolutions in .

Azure SQL DATABASE is an EXAMPLE of what type of service?
Choose the correct OPTION from below list
(1)PaaS
(2)SaaS
(3)IAAS
(4)BpaaS

Answer:-(1)PaaS

In relation to Azure SQL Database export to the storage, which of the following is not TRUE?
Choose the correct option from below list
(1)It may be canceled if it takes longer than 20 hours.
(2)It can be written FASTER to Azure Premium Storage.
(3)All USER table DATA is exported.
(4)The OUTPUT BACPAC file cannot exceed 200GB.

Answer:-(2)It can be written faster to Azure Premium Storage.

Which of the FOLLOWING is are the standard monitoring uses for DYNAMIC Management Views available in AZURE SQL DATABASE?
Choose the correct option from below list
(1)CONNECTIONS
(2)Query performance
(3)Query plans
(4)All the options

Answer:-(4)All the options

Which of the following characteristics relate to Azure SQL Database?
CHOOSE the correct option from below list
(1)High AVAILABILITY is already built-in
(2)All the OPTIONS
(3)You control the DATA and access
(4)Most administration duties are managed by Azure

Answer:-(2)All the options

Templates for Azure Resource MANAGER deployment are written in which format?
Choose the correct option from below LIST
(1)XML
(2)T-SQL
(3)JSON
(4)CSV

Answer:-(3)JSON

In relation to the Azure SQL database active geo replication, which of the following is not true?
CHOOSE the correct option from below list
(1)All DATABASES need to be in the same data center
(2)Secondary databases are ABLE to be queried
(3)Secondary databases are available for failover if a data center outage occurs
(4)All databases need to be in the same subscription

Answer:-(1)All databases need to be in the same data center

In the AZURE PORTAL, which options let you adjust compute costs for an Azure SQL Data Warehouse?
Choose the CORRECT option from below list
(1)Pause, start and scale
(2)Scale
(3)Pause and start
(4)Monitoring
(5)Restore

Answer:-(1)Pause, start and scale

Which statements are true about Azure DocumentDB?
Choose the correct option from below LIST
(1)Azure DocumentDB lets you STORE non-relational DATA in a key/value store.
(2)Azure DocumentDB embraces industry standards like JSON and JavaScript.
(3)You must manually create indexes in DocumentDB databases.
(4)Azure DocumentDB provides developers with a schema-free data model embracing standards like JSON and JavaScript.
(5)All the options
(6)Azure DocumentDB provides developers with a schema-free data model.

Answer:-(4)Azure DocumentDB provides developers with a schema-free data model embracing standards like JSON and JavaScript.

Your boss is interested in Dynamic Management Views. She ASKS you for examples where you COULD USE this feature. Which of the following scenarios do you provide?
Choose the correct option from below list
(1)Monitor the number of connections
(2)Identify which QUERIES are using the most CPU
(3)All of the options
(4)Calculate the db size

Answer:-(3)All of the options

When loading data into Azure SQL Data Warehouse, what is the method that enables parallel reader loading?
Choose the CORRECT option from below list
(1)PolyBase
(2)SQL Server Integration Services
(3)Azure data FACTORY
(4)Bulk PROCESS copy

Answer:-(1)PolyBase

Before users can connect from their APPLICATIONS to an AZURE SQL SERVER that has just been created, what must you configure?
Choose the correct option from below list
(1)Firewall Rule
(2)IP address of the server
(3)NETWORK protocol of the server

Answer:-(1)Firewall Rule

When creating an Azure SQL Data Warehouse, which of the following options is INCORRECT?
Choose the correct option from below list
(1)Select the server, server location, admin login, and password.
(2)Select a resource group.
(3)Create a BLANK database as the data SOURCE.
(4)Choose the performance LEVEL or the DWUs.

Answer:-(3)Create a blank database as the data source.

Which of the following TOOLS can be used to connect to AZURE SQL DATABASE?
Choose the correct option from below list
(1)SSIS
(2)SQL-CMD
(3)SSMS, SQL-CMD, SSIS
(4)SSMS

Answer:-(3)SSMS, SQL-CMD, SSIS

When migrating an existing on PREMISES SQL Server database, what type of export file needs to be created when both schema and DATA need to be EXPORTED?
Choose the correct option from below list
(1).data
(2).schema
(3).dacpac
(4).bacpac

Answer:-(4).bacpac

If an existing login can ACCESS the MASTER database of an AZURE SQL Server, which type of OBJECT needs to be created before the login can access another database on the same server?
Choose the correct option from below list
(1)Firewall
(2)Certificate
(3)User
(4)Schema

Answer:-(3)User

Which of the following services is designed for storage, AUTOMATIC INDEXING, and rapid querying of JSON documents that are commonly found in NOSQL APPLICATIONS?
Choose the correct option from below list
(1)Azure Document DB
(2)Azure SQL data warehouse
(3)Azure table storage
(4)Azure Blob storage

Answer:-(1)Azure Document DB

Which THREE of the FOLLOWING settings need to be configured for a new Azure SQL Server?
Choose the correct option from below LIST
(1)Location
(2)All the options
(3)Server ADMIN login
(4)Server name

Answer:-(2)All the options

In relation to Azure SQL Database firewall rules, which of the FOLLOWING is TRUE?
CHOOSE the correct option from below list
(1)They are configured USING T-SQL statements.
(2)All the options
(3)They can be configured in the Azure portal.
(4)They are stored in the master database for the server.

Answer:-(2)All the options

Where is the output of Azure SQL Database AUDITING STORED?
Choose the correct option from below LIST
(1)In a protected table in the user database
(2)In the Windows security log
(3)In a protected table in a master database
(4)In a log written to Azure storage

Answer:-(4)In a log written to Azure storage

If it TAKES 15 minutes to load 3 tables into an Azure SQL DATA Warehouse that has been provisioned with 100 DWUs, how many DWUs will it take to load those same tables in 3 minutes?
Choose the CORRECT option from below list
(1)500
(2)300
(3)400
(4)1000

Answer:-(1)500

You are creating a Firewall Blocked alert for your SQL Server database. You are using the Azure portal and need to specify a TIME span to monitor the metric DATA. Which parameter do you configure?
Choose the correct option from below LIST
(1)Metric
(2)Period
(3)Condition
(4)DURATION
(5)Threshold

Answer:-(2)Period

Which four of the following detection types are available to Azure SQL Database THREAT Detection?
Choose the correct option from below list
(1)All the options
(2)SQL Injection
(3)SQL Injection vulnerability
(4)UNUSUAL USAGE pattern
(5)Login from new location

Answer:-(1)All the options

How is AZURE SQL Database Auditing configured?
CHOOSE the correct option from below list
(1)T-SQL QUERY to the MASTER database
(2)T-SQL query to the user database
(3)Via an Azure portal CONFIGURATION
(4)T-SQL query to the msdb database

Answer:-(3)Via an Azure portal configuration

When configuring Azure SQL Data Warehouse to access TEXT files in an Azure STORAGE container, which of the FOLLOWING features is used?
Choose the correct OPTION from below list
(1)OPENQUERY
(2)Linked SERVERS
(3)Ploy base
(4)Azure table storage

Answer:-(3)Ploy base

Audit logs can be written to which two of the FOLLOWING?
Choose the correct option from below LIST
(1)Queue storage
(2)Both blob and table storage
(3)Blob storage
(4)Table storage
(5)FILE storage
(6)All the MENTIONED options

Answer:-(2)Both blob and table storage

You are planning on creating a new Azure SQL Database on an existing SQL Server by using Azure portal. Which settings can you configure for the new database?
Choose the correct option from below LIST
(1)COLLATION
(2)Resource Group
(3)Pricing tier and collation
(4)Pricing tier
(5)sign in and password
(6)All the mentioned options

Answer:-(5)sign in and password

Which of the following options is best for working with large scale, high volume non relational DATA?
Choose the correct OPTION from below list
(1)Azure SQL Data Warehouse
(2)Azure SQL DATABASE
(3)Azure STORAGE Tables
(4)Azure Cosmos DB

Answer:-(4)Azure Cosmos DB

Up to how many online SECONDARY BACKUPS are available within a PREMIUM pricing tier?
CHOOSE the correct option from below list
(1)4
(2)5
(3)6
(4)3

Answer:-(1)4