최신Microsoft Administering Microsoft SQL Server 2012/2014 Databases - 70-462무료샘플문제
문제1
Note: This question is part of a series of questions that use the same set of answers choices. An answer choice may be correct for more than one question in the series.
You administer a Microsoft SQL Server server that hosts a transactional database and a reporting database.
The transactional database is updated through a web application and is operational throughout the day. The reporting database is only updated from the transactional database.
The recovery model and backup schedule are configured as shown in the following table:
One of the hard disk drives that stores the reporting database fails at 23:32 hours.
You need to ensure that the reporting database is restored. You also need to ensure that data loss is minimal.
What should you do?
Note: This question is part of a series of questions that use the same set of answers choices. An answer choice may be correct for more than one question in the series.
You administer a Microsoft SQL Server server that hosts a transactional database and a reporting database.
The transactional database is updated through a web application and is operational throughout the day. The reporting database is only updated from the transactional database.
The recovery model and backup schedule are configured as shown in the following table:
One of the hard disk drives that stores the reporting database fails at 23:32 hours.
You need to ensure that the reporting database is restored. You also need to ensure that data loss is minimal.
What should you do?
정답: F
설명: (ExamPassdump 회원만 볼 수 있음)
문제2
You administer a Microsoft SQL Server database.
You need to ensure that the size of the transaction log file does not exceed 2 GB.
What should you do?
You administer a Microsoft SQL Server database.
You need to ensure that the size of the transaction log file does not exceed 2 GB.
What should you do?
정답: B
설명: (ExamPassdump 회원만 볼 수 있음)
문제3
You administer a Microsoft SQL Server instance named SQL2012 that hosts an OLTP database of 1 terabyte in size.
The database is modified by users only from Monday through Friday from 09:00 hours to 17:00 hours. Users modify more than 30 percent of the data in the database during the week.
Backups are performed as shown in the following schedule:
The Finance department plans to execute a batch process every Saturday at 09:00 hours. This batch process will take a maximum of 8 hours to complete.
The batch process will update three tables that are 10 GB in size. The batch process will update these tables multiple times.
When the batch process completes, the Finance department runs a report to find out whether the batch process has completed correctly.
You need to ensure that if the Finance department disapproves the batch process, the batch operation can be rolled back in the minimum amount of time.
What should you do on Saturday?
You administer a Microsoft SQL Server instance named SQL2012 that hosts an OLTP database of 1 terabyte in size.
The database is modified by users only from Monday through Friday from 09:00 hours to 17:00 hours. Users modify more than 30 percent of the data in the database during the week.
Backups are performed as shown in the following schedule:
The Finance department plans to execute a batch process every Saturday at 09:00 hours. This batch process will take a maximum of 8 hours to complete.
The batch process will update three tables that are 10 GB in size. The batch process will update these tables multiple times.
When the batch process completes, the Finance department runs a report to find out whether the batch process has completed correctly.
You need to ensure that if the Finance department disapproves the batch process, the batch operation can be rolled back in the minimum amount of time.
What should you do on Saturday?
정답: F
문제4
You have a SQL Server database named DB1.
You plan to load 10 million rows to DB1 by running bcp.exe.
You need to modify DB1 to minimize the amount of space required to store the transaction logs during the load operation. The solution must ensure that you can perform a point-in-time restore.
What data base setting should you modify?
You have a SQL Server database named DB1.
You plan to load 10 million rows to DB1 by running bcp.exe.
You need to modify DB1 to minimize the amount of space required to store the transaction logs during the load operation. The solution must ensure that you can perform a point-in-time restore.
What data base setting should you modify?
정답: A
설명: (ExamPassdump 회원만 볼 수 있음)
문제5
You administer a Microsoft SQL Server database named Contoso that contains a single user-defined database role named BillingUsers.
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?
You administer a Microsoft SQL Server database named Contoso that contains a single user-defined database role named BillingUsers.
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?
정답: C
설명: (ExamPassdump 회원만 볼 수 있음)
문제6
Which of the following recovery models must be in use for point-in-time recovery to be possible for an SQL Server 2012 database?
Which of the following recovery models must be in use for point-in-time recovery to be possible for an SQL Server 2012 database?
정답: C
설명: (ExamPassdump 회원만 볼 수 있음)
문제7
Which of the following is NOT a valid recovery model for an SQL 2012 database?
Which of the following is NOT a valid recovery model for an SQL 2012 database?
정답: A
설명: (ExamPassdump 회원만 볼 수 있음)
문제8
Which of the following statements about the tempdb system database is FALSE?
Which of the following statements about the tempdb system database is FALSE?
정답: B
설명: (ExamPassdump 회원만 볼 수 있음)
문제9
You have installed the SQL Server Integration Services (SSIS) feature on a server running Windows Server
2008 R2 SP1.
Which of the following features must you install if you want to ensure that you can run packages in 32-bit mode?
You have installed the SQL Server Integration Services (SSIS) feature on a server running Windows Server
2008 R2 SP1.
Which of the following features must you install if you want to ensure that you can run packages in 32-bit mode?
정답: D
문제10
You administer a Microsoft Azure SQL Database database named Orders.
You need to create a copy of Orders named Orders_Reporting.
Which Transact-SQL command should you use?
You administer a Microsoft Azure SQL Database database named Orders.
You need to create a copy of Orders named Orders_Reporting.
Which Transact-SQL command should you use?
정답: D
문제11
You administer all the deployments of Microsoft SQL Server 2012 in your company.
You need to ensure that data changes are sent to a non-SQL Server database server in near real time.
You also need to ensure that data on the primary server is unaffected.
Which configuration should you use?
You administer all the deployments of Microsoft SQL Server 2012 in your company.
You need to ensure that data changes are sent to a non-SQL Server database server in near real time.
You also need to ensure that data on the primary server is unaffected.
Which configuration should you use?
정답: E
문제12
You administer a Microsoft SQL Server 2012 database named ContosoDB. The database contains a table named Suppliers and a column named IsActive in the Purchases schemA.
You create a new user named ContosoUser in ContosoDB. ContosoUser has no permissions to the Suppliers table.
You need to ensure that ContosoUser can delete rows that are not active from Suppliers. You also need to grant ContosoUser only the minimum required permissions.
Which Transact-SQL statement should you use?
You administer a Microsoft SQL Server 2012 database named ContosoDB. The database contains a table named Suppliers and a column named IsActive in the Purchases schemA.
You create a new user named ContosoUser in ContosoDB. ContosoUser has no permissions to the Suppliers table.
You need to ensure that ContosoUser can delete rows that are not active from Suppliers. You also need to grant ContosoUser only the minimum required permissions.
Which Transact-SQL statement should you use?
정답: A
설명: (ExamPassdump 회원만 볼 수 있음)