- All Exams Instant Download
Which backup should you perform every two hours?
You administer a Microsoft SQL Server 2012 instance that contains a financial database hosted on a storage area network (SAN). The financial database has the following characteristics: - A data file of 2 terabytes is located on a dedicated LUN (drive D). - A transaction log of 10 GB is...
What should you do?
You administer a Microsoft SQL Server 2012 default instance. The instance is hosted by a server that has a local firewall configureD. The firewall only allows inbound connections on port 1433. The server only hosts a single instance of SQL Server. You need to ensure that the instance is configured...
What should you do?
You administer a Microsoft SQL Server 2012 database instance. You plan to migrate the database to Windows Azure SQL Database. You verify that all objects contained in the database are compatible with Windows Azure SQL Database. You need to ensure that database users and required server logins are migrated to...
Which configuration should you use?
Topic 1, Volume A You administer all the deployments of Microsoft SQL Server 2012 in your company. You need to ensure that an OLTP database that includes up-to-the-minute reporting requirements can be off-loaded from the primary database to another server. You also need to be able to add indexes to...
Which server configuration property should you set?
You administer a Microsoft SQL Server 2012 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
What should you do?
You administer a Microsoft SQL Server 2012 instance. The instance contains a database that supports a retail sales application. The application generates hundreds of transactions per second and is online 24 hours per day and 7 days per week. You plan to define a backup strategy for the database. You...
What should you do?
You administer a Microsoft SQL Server 2012 failover cluster that contains two nodes named Node A and Node B. A single instance of SQL Server is installed on the cluster. An additional node named Node C has been added to the existing cluster. You need to ensure that the SQL...
Which type of user should you create?
You use a contained database named ContosoDb within a domain. You need to create a user who can log on to the ContosoDb database. You also need to ensure that you can port the database to different database servers within the domain without additional user account configurations. Which type of...
Which three actions should you perform in sequence?
DRAG DROP You administer a Microsoft SQL Server 2012 server. You need to install the Power View components on a stand-alone server. Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the...
Which type of solution should you use?
You administer a Microsoft SQL Server 2012 database that includes a table named dbo.Log. This table contains millions of records about user activity in an application. Records in dbo.Log that are more than 90 days old are purged nightly. When records are purged, table locks are causing contention with inserts....
