- All Exams Instant Download
How should you complete the Transact-SQL statement?
DRAG DROP You have a test server that contains a database named DB1. Backups of the database are written to a single backup device. The backup device has a full, differential, and transaction log backup. You discover that the database is damaged. You restore the database to the point at...
Which features should you identify?
DRAG DROP You plan to deploy SQL Server 2014. You identify the following security requirements for the deployment: Users must be prevented from intercepting and reading the T-SQL statements sent from the clients to the database engine. All database files and log files must be encrypted if the files are...
Which server configuration property should you set?
You administer a Microsoft SQL Server 2016 failover cluster. You need to ensure that a failover occurs when the server diagnostics returns query_processing error. Which server configuration property should you set?A . SqlOumperDumpFlagsB . FailureConditionLevelC . HealthCheckTimeoutD . SqlDumperDumpPathView AnswerAnswer: B Explanation: The SQL Server Database Engine resource DLL determines...
Which permission should you grant?
You manage a Microsoft SQL Server environment. You implement Transparent Data Encryption (TDE). A user will assist in managing TDE. You need to ensure that the user can view the TDE metadata while following the principle of lease privilege. Which permission should you grant?A . DDLAdminB . db_datawriterC . dbcreatorD...
What should you create?
You administer a Microsoft SQL Server 2016 database named Contoso on a server named Server01. You need to write messages to the Application Log when users are added to or removed from a fixed server role in Server01. What should you create?A . a Database Audit SpecificationB . a PolicyC...
How should you complete the Transact-SQL statement?
HOTSPOT You are a database administrator for a company that has an on-premises Microsoft SQL Server environmentand Microsoft Azure SQL Database instances. The environment hosts several customer databases, and eachcustomer uses a dedicated instance. The environments that you manage are shown in the following table. You need to configure the...
Which object should you use to gather information about each instance?
DRAG DROP You have five servers that run Microsoft Windows 2012 R2. Each server hosts a Microsoft SQL Server instance. The topology for the environment is shown in the following diagram. You have an Always On Availability group named AG1. The details for AG1 are shown in the following table....
What should you include in the recommendation?
Overview You are a database administrator for a company named Litware, Inc. Litware is a book publishing house. Litware has a main office and a branch office. You are designing the database infrastructure to support a new web-based application that is being developed. The web application will be accessed at...
How can you meet these requirements?
You work as a Developer at ABC.com. All databases are hosted on Windows Server 2012 servers running SQL Server 2012. The company has a database named Products. Tables in the Products database contain data including part numbers, product name, color, type and size. Users in the Marketing department have created...
Which Transact-SQL statement should you use?
You administer a Microsoft SQL Server 2016 database named Contoso that contains a single user-defined database role namedBillingUsers. All objects in Contoso are in the dbo schema. You need to grant EXECUTE permissions for all stored procedures in Contoso to BillingUsers. Which Transact-SQL statement should you use?A . EXEC sp_addrolemember'db_procexecutor',...
