070-462 試験問題を無料オンラインアクセス

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 user should you create?

• A.SQL user without login
• B.User mapped to an asymmetric key
• C.Domain user
• D.login mapped to a virtual account

You administer a Microsoft SQL Server database.
Every Sunday afternoon, a process inserts a large volume of data. Users generate reports and modify additional data throughout the week.
You need to create a backup strategy that:
* minimizes the size of the transaction log,
* minimizes the size of the backups, and
* ensures a 24-hour recovery point objective (RPO).
Which strategy or strategies should you use? (To answer, drag the appropriate strategy or strategies to their corresponding task or tasks in the answer area. Answer choices may be used once, more than once, or not at all. Answer targets may be used once or not at all. Additionally, you may need to drag the split bar between panes or scroll to view content.)

正解：

Explanation

Recovery Model: Full recovery model
Only the Full recovery model provides a 24-hour recovery point objective.
Sunday backup: Full backup
Nightly backup: Transactional log backup
References:
https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/recovery-models-sql-server

You are designing a SQL Server Integration Services (SSIS) package that uses the Fuzzy Lookup transformation.
The reference data to be used in the transformation does not change.
You need to reuse the Fuzzy Lookup match index to increase performance and reduce maintenance.
What should you do?

• A.Execute the sp_FuzzyLookupTableMaintenanceUninstall stored procedure.
• B.Select the GenerateAndPersistNewIndex option in the Fuzzy Lookup Transformation Editor.
• C.Select the DropExistingMatchIndex option in the Fuzzy Lookup Transformation Editor.
• D.Select the GenerateNewIndex option in the Fuzzy Lookup Transformation Editor.
• E.Execute the sp_FuzzyLookupTableMaintenanceInvoke stored procedure.

You administer a Microsoft SQL Server 2012 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 permission for all stored procedures in Contoso to BillingUsers.
Which Transact-SQL statement should you use?

• A.EXEC sp_addrolemember 'executor', 'BillingUsers'
• B.GRANT EXECUTE ON INFORMATION_SCHEMA.ROUTINES TO BillingUsers
• C.CREATE ROLE proc_callerGRANT EXECUTE ON Schema: : dbo TO proc_callerALTER ROLE proc_caller ADD MEMBER BillingUsers
• D.CREATE ROLE proc_callerGRANT EXECUTE ON ALL PROCEDURES TO proc_callerALTER MEMBER BillingUsers ADD TO ROLE proc_caller

You create an availability group named HaContoso that has replicas named Server01/HA, Server02/HA, and Server03/HA.
Currently, Server01/HA is the primary replica.
You need to ensure that the following requirements are met:
* Backup operations occur on Server02/HA.
* If Server02/HA is unavailable, backup operations occur on Server03/HA.
* Backup operations do not occur on Server01/HA.
How should you configure HaContoso?

• A.Set the backup preference of HaContoso to Prefer Secondary.Set the backup priority of Server02/HA to
  20.Set the backup priority of Server03/HA to 10.
• B.Set the backup preference of HaContoso to Secondary only.Set the backup priority of Server02/HA to
  20.Set the backup priority of Server03/HA to 10.
• C.Set the exclude replica of Server01/HA to true.Set the backup priority of Server02/HA to 10.Set the backup priority of Server03/HA to 20.
• D.Set the backup preference of HaContoso to Secondary only.Set the backup priority of Server02/HA to
  10.Set the backup priority of Server03/HA to 20.