Microsoft AI-200 Practice Test

Answer choices

1. A. Use arg_max to parse tokens.
2. B. Use union to split a string into fields.
3. C. Use summarize before extracting the value.
4. D. Use parse or an appropriate extraction function to derive structured columns from the text.

Wrong-answer review

• A. Use arg_max to parse tokens.: Use arg_max to parse tokens. can be valid in a different design, but it does not satisfy the decisive requirement in this scenario. KQL parsing and extraction operators/functions can turn structured patterns embedded in text into separate queryable columns.
• B. Use union to split a string into fields.: Use union to split a string into fields. can be valid in a different design, but it does not satisfy the decisive requirement in this scenario. KQL parsing and extraction operators/functions can turn structured patterns embedded in text into separate queryable columns.
• C. Use summarize before extracting the value.: Use summarize before extracting the value. can be valid in a different design, but it does not satisfy the decisive requirement in this scenario. KQL parsing and extraction operators/functions can turn structured patterns embedded in text into separate queryable columns.

Answer choices

1. A. The key disables indexing on all other properties.
2. B. The active month can become a hot logical partition because most writes share one partition-key value.
3. C. The key guarantees even distribution because dates are sortable.
4. D. The key forces Strong consistency.

Answer choices

1. A. ReceiveAndDelete it and then try to recover it.
2. B. Dead-letter the message explicitly with a reason/description.
3. C. Defer it without preserving its sequence number.
4. D. Complete it successfully.

Answer choices

1. A. App Service converts the image into a Functions ZIP package after first start.
2. B. The container stops checking ACR after the first successful deployment.
3. C. ACR permanently pushes all layers into the web app content share.
4. D. App Service retains image layers on local disk and pulls only changed layers when the image is fetched again.

Answer choices

1. A. Use Service Bus sessions as configuration labels.
2. B. Create a new Key Vault for every nonsecret setting.
3. C. Use labels to store environment-specific variants of the same key.
4. D. Encode the environment into the application binary.

Answer choices

1. A. A new revision is created because template changes are revision-scope.
2. B. Only the running replica count changes; no revision is created.
3. C. The existing revision is modified in place while remaining immutable.
4. D. The change affects only the Container Apps environment, not the app.

Answer choices

1. A. Set IVFFlat lists equal to zero.
2. B. Rebuild the index as a B-tree.
3. C. Increase ef_search indefinitely.
4. D. Reduce hnsw.ef_search after validating recall remains acceptable.

Answer choices

1. A. Put the package bytes in Azure App Configuration.
2. B. Make the package container public.
3. C. Grant the function app managed identity access to the package blob and use identity-based access where supported.
4. D. Embed a storage account key directly in source code.

Answer choices

1. A. The lock applies only after geo-replication is enabled.
2. B. The resource lock protects registry management operations; image data needs repository/image-level protection such as locking or appropriate permissions.
3. C. A CanNotDelete lock disables image pulls but not pushes.
4. D. Tags in ACR are always immutable regardless of permissions.

Answer choices

1. A. Use noeviction if the explicit goal is to free memory automatically.
2. B. Use vector KNN distance as the eviction score.
3. C. Disable all expirations and rely on infinite memory.
4. D. Use an LRU-based eviction policy appropriate to whether all keys or only TTL-bearing keys may be evicted.