Which of the following statements Authentication in SQL Server are not correct. Choose all that applies:

Logins cannot access databases if they have not been granted access. To grant access to a principal, you create a user. Following are some Create User statements, in which you have to choose which one is correct. You can also choose none or more than one.

You are configuring Linked Servers, and you already know that distributed queries reach the correct data source and return the data, the deployment of the linked server require building of three Tiers. Which one of the following is not a tier in Linked Server Configuration?

These are actual data sources and you can use multiple SQL Server databases for your distributed query. Which of the following Tier describes the above-mentioned statement?

Permission at the server level generally relate to administrative actions, such as:

You can add and remove database principals from database roles using the Alter Role command. Which of the following statements about Assigning Database Principals to Database Roles are correct. Choose All that are correct.

You have been given a task by your manager to assign roles based on Finance department’s request. Their main requirement is to restrict a group of users to Select Permissions on a table or Execute permissions on a stored procedure on Database Level. Also, note that accounts are both application and service based. Which of the following T-SQL statements can be used to achieve this objective?

Which of the following is true about Column Level Security:

Which of the following permission enables a user to change the definition of a stored procedure?

Choose all the options below which describes User-Schema Separation:

Triggers are a form of stored procedure that is triggered automatically in response to an event .There are three forms of Triggers in SQL Server. Which of the following Trigger/s is/are not supported in Azure SQL database?

SQL Server Supports 3 forms of triggers DDL,DML and Logon Triggers. But, they have some limitations . Choose all the statements below which are not true about Trigger limitations:

Given below is a statement to create a temporal table with System Versioning feature on: CREATE TABLE db. Employee
(
EmployeeID int NOT NULL PRIMARY KEY CLUSTERED,
ManagerID int NULL,
FirstName varchar(50) NOT NULL,
LastName varchar(50) NOT NULL,
SysStartTime datetime2 GENERATED ALWAYS AS ROW START NOT NULL,
SysEndTime datetime2 GENERATED ALWAYS AS ROW END NOT NULL,
PERIOD FOR SYSTEM_TIME (SysStartTime,SysEndTime)
)
WITH (SYSTEM_VERSIONING = ON (HISTORY_TABLE = dbo.EmployeeHistory));
GO
But, Temporal tables have some limitations. Choose all the answers below which does not fall under the limitations of Temporal Table:

You are considering to Backup your on-premises SQL Server database to Microsoft Azure Blob storage. But, only you are aware of its benefits and not your Project Manager. Your Project Manager wants to know the benefits of it. Consider the following statements below and choose all those options which you think are the Benefit/s of Microsoft Azure Blob storage:

Which of the following options are true about SQL Server Transaction Logs. Mark all that are correct:

SQL Server has three database recovery models : Simple , Full and Bulk Logged. There are four options given below regarding Bulk Logged . You have to select all answers which you think is true about Bulk Logged:

Being the database administrator of your organization you want to perform Backup of your database. You have chosen Full Database Backup but also know about Differential Backup and when to use it . Below mentioned are two statements one for each : Full Database Backup and Differential Backup. Choose the correct option through which you can do the Full Backup of your database:

Which of the following statements about Transaction Log Backups are correct?

SQL Server tracks all of the backup activity in the following tables in the msdb database Mark all which are correct:

The restore process of a SQL Server database consist of how many phases ?

Among the 3 categories of Restoring databases namely : Complete database(Simple and Full), System database restore and Advanced restores. Given below are some options in which advance restore works best .Choose all that are correct:

Following are the phases of restore process ,mark all or none which are correct:

As a database administrator you have certain tasks that should be performed regularly in terms of Automating SQL Server . Given below are some technologies through which you can automate regular tasks.
• SQL Server Agent
• Maintenance Plans
• PowerShell
• System Center Operations Manager
Which of the following statements about SQL Server Agent is true?

There are four core object types provided by SQL Server Agent. From the options below choose all that are correct

Part1: Sometimes Job fails and does not execute as expected. It is important to follow a consistent process when attempting to work out why job is failing. How many Steps are there for troubleshooting jobs?

Part2: Which of the following is not a part of Job troubleshooting process ?

What happens to a credential when the password of the windows user that the credential references is changed?

Credentials can be created by using the Transact-SQL CREATE statement, or by using SQL Server management Studio. Below mentioned are some steps to configure it. Choose the one which is incorrect:

There are three types of SQL Server Agent Roles namely : SQLAgentUserRole, SQLAgentReaderRole and SQLAgentOperatorRole. Which of the following statements are true about SQLAgentOperatorRole?

Part1: How many types of Error Severity levels are there in SQL Server?

Part2: The severity of an error indicates the type of problem that SQL Server encounters. Which of the following is correct in both description as well as Error Ranges?

Choose all the statements below which are correct regarding Database Mail Profiles. (Database Mail Profile is a collection of one or more database mail accounts.

There are 4 types of Alerts in Azure SQL Database. Choose all the correct options below which are correct:

Which of the following statements about PowerShell is/are not correct?

You can change SQL Server Database settings by assigning new values to the properties of objects. Which of the following options below is correct regarding amending SQL Server Database Settings:

What is an SMO Object?

There are total 3 types in the Architecture of Extended Events. Which of the following is not part of the architecture?

Packages acts as containers for the Extended Events objects and their definitions. For which of the following object type/s does a Package not act as a container?

Which system Dynamic Management View provides the list of events configured in an active Extended Event session?

The component/s that make up the data collection system in SQL Server is/are:

Data Collector is a toolkit for collecting SQL Server performance information into a single location which includes:

Fixed Roles for data collection security are created in the msdb system database. Which of the following is not a fixed role in Data Collection Security?

A key characteristic of good troubleshooters is that they follow a clear methodology in a logical manner. There are many different methodologies, with 4 most common phases namely : Investigate, Validate, Analyze and Implement. From the options below what should be the logical order of these phases?

When troubleshooting Service Related issues, the most common one is SQL Server service not starting or cannot be accessed. If it does not start from the options below which options should be selected to resolve the issue?

Choose all the answers below which are correct about SQL Server Error Log:

You want to import data from a text file into a SQL Server table, which of the following data transfer tools you can use to accomplish this task?

SSIS is an extensible platform for building complex ETL solutions. It is included with SQL Server and consists of a Microsoft Windows service that manages the execution of ETL workflows, along with tools and components for developing them. In SSIS a service called SSIS Service is used to perform management of control flow , execution of task workflows, which are defined in the packages. Which of the following statements below are false about SSIS Service?

A DAC is a logical collection of all the database objects—such as tables, stored procedures, logins, and users—associated with a SQL Server user database. Definitions for all the objects in a DAC can be combined into a deployment package file, called a DAC package (DACPAC), which can be used to install or upgrade a DAC across multiple instances of the database engine. Which of the following operations can you perform on a DAC?