Which Microsoft Azure SQL Database role should you assign the junior database administrator?

Correct Answer for the Question – Which Microsoft Azure SQL Database role should you assign the junior database administrator? is given below You are the senior database administrator for a Microsoft SQL Server environment that uses Microsoft Azure SQL Database.You need to grant a junior database administrator only the permissions required to create new logins.Which Microsoft … Read more

How many SQL Server instances should you add to SQL1?

Correct Answer for the Question – How many SQL Server instances should you add to SQL1? is given below You have a server named SQL1 that has SQL Server installed. SQL1 hosts several applications.You plan to deploy a third-party application to SQL1. The application must have the following:• A vendor-provided password for the sa account• A … Read more

Which set of tools should you install?

Correct Answer for the Question – Which set of tools should you install? is given below You install a Microsoft SQL Server 2012 instance.The instance will store data extracted from two databases running on Windows Azure SQL Database.You hire a data steward to perform interactive data cleansing and ad hoc querying and updating of the database.You … Read more

Which hierarchy type should you use?

Correct Answer for the Question – Which hierarchy type should you use? is given below You are creating a SQL Server Master Data Services (MDS) model for a company.The source data for the company is stored in a single table that contains the manager-to-subordinate relationships.You need to create a hierarchy representing the organizational structure of the … Read more

Which Transact-SQL statement should you use?

Correct Answer for the Question – Which Transact-SQL statement should you use? is given below You administer a Microsoft SQL Server 2012.A process that normally runs in less than 10 seconds has been running for more than an hour.You examine the application log and discover that the process is using session ID 60.You need to find … Read more

Which other shared feature should you add to the installation?

Correct Answer for the Question – Which other shared feature should you add to the installation? is given below You need to install SQL Server on a server. The server must meet the following requirements:Include SQL Server Integration Services (SSIS) Be able to run 32-bit SSIS legacy packagesYou add the Integration Services shared feature to the … Read more

What should you configure?

Correct Answer for the Question – What should you configure? is given below You administer a Microsoft SQL Server environment. The environment contains a SQL Server Reporting Services (SSRS) instance.You need to ensure that users can create subscriptions.What should you configure?User requirements. The author of the subscription must have permission to “Manage reports” and “Manage all … Read more

Which configuration should you use?

Correct Answer for the Question – Which configuration should you use? is given below You are implementing a SQL Server two-node failover cluster.You need to choose a quorum configuration.Which configuration should you use?Node and Disk Majority is recommended for clusters with an even number of nodes.Incorrect Answers:A, D: These are not quorum configuration choices.B: Node Majority … Read more

Which three statements should you execute?

Correct Answer for the Question – Which three statements should you execute? is given below You manage a server that has SQL Server installed and hosts databases for five applications. Each application has a different login to the SQL Server instance.You need to create a TCP endpoint to be used only by a login named Application3. … Read more