Microsoft 70-765 Deutsch Value Pack (Frequently Bought Together)

Correct Answer:

Explanation:
Section: Deploy and migrate applications
Step 1: Perform a tail-log backup.
A tail-log backup captures any log records that have not yet been backed up (the tail of the log) to prevent work loss and to keep the log chain intact. Before you can recover a SQL Server database to its latest point in time, you must back up the tail of its transaction log. The tail-log backup will be the last backup of interest in the recovery plan for the database.
Step 2: Restore a full backup.
Backups must be restored in the order in which they were created. Before you can restore a particular transaction log backup, you must first restore the following previous backups without rolling back uncommitted transactions, that is WITH NORECOVERY:
The full database backup and the last differential backup, if any, taken before the particular transaction log backup.
Step 3: Restore the log backups.
Log backups must be applied in the sequence in which they were created, without any gaps in the log chain.
Step 4: Restore the tail-log backups.
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/restore-a-transaction-log-backup-sqlserver
https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/tail-log-backups-sql-server

Correct Answer:

Explanation:
Query_optimizer_hotfixes
DB1: MAXDOP
You can use the max degree of parallelism (MAXDOP) option to limit the number of processors to use in parallel plan execution.
DB2: LEGACY_CARDINALITY_ESTIMATION
The CE (Cardinality Estimation) predicts how many rows your query will likely return. The cardinality prediction is used by the Query Optimizer to generate the optimal query plan. With more accurate estimations, the Query Optimizer can usually do a better job of producing a more optimal query plan.
Legacy CE: For a SQL Server database set at compatibility level 120 and above, the CE version 70 can be can be activated by using the at the database level by using the ALTER DATABASE SCOPED CONFIGURATION.
Example:
ALTER DATABASE SCOPED CONFIGURATION
SET LEGACY_CARDINALITY_ESTIMATION = ON;
GO

Correct Answer: A  🗳️

Explanation: Only visible for Prep4sureGuide members. You can sign-up / login (it's free).

Correct Answer: B  🗳️

Explanation: Only visible for Prep4sureGuide members. You can sign-up / login (it's free).

Correct Answer:

Explanation:
Box 1: \\LON-SRV1\Marketing\Marketingdata.mdf
The database file must be stored on the Marketing share of the Lon-SVR1 server.
Box 2: 500 MB
Initial size is 400 MB, with an annual 1% increase in size.
Box 3: Filegrowth=0
The file must not automatically increase in size.
Box 4: L:\Logs\Marketing\Marketingdata.ldf
Log files must be stored on the L drive of the SQL Server machine in a folder named Logs.
Box 5: Filegrowth = 10%
The log file must be able to grow.
References:
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-database-transact-sql?view=sql-server-2017